BEGIN
FND_FLEX_VAL_API.CREATE_VALUESET_TABLE
(
VALUE_SET_NAME =>'TEI_PROJECT_NO',
DESCRIPTION =>'createdfrombackend',
SECURITY_AVAILABLE =>'N',
ENABLE_LONGLIST =>'N',
FORMAT_TYPE =>'Char',
MAXIMUM_SIZE =>30,
precision => NULL,
numbers_only =>'N',
uppercase_only =>'N',
right_justify_zero_fill =>'N',
min_value => NULL,
MAX_VALUE => NULL,
TABLE_APPLICATION => 'Projects',
table_appl_short_name =>'' ,
TABLE_NAME =>'pa_projects_all PPA',
ALLOW_PARENT_VALUES =>'N',
VALUE_COLUMN_NAME =>'PPA.SEGMENT1',
VALUE_COLUMN_TYPE =>'Char',
value_column_size =>30,
meaning_column_name =>'PPA.NAME',
meaning_column_type => 'Char',
MEANING_COLUMN_SIZE => 30,
ID_COLUMN_NAME =>'PPA.PROJECT_ID',--'PRH.SEGMENT1',
ID_COLUMN_TYPE =>'NUMBER',--'Char',
ID_COLUMN_SIZE =>30,--u20,
WHERE_ORDER_BY =>'',
ADDITIONAL_COLUMNS => NULL
);
Commit;
Exception
WHEN OTHERS THEN
dbms_output.put_line(sqlerrm);
end;
FND_FLEX_VAL_API.CREATE_VALUESET_TABLE
(
VALUE_SET_NAME =>'TEI_PROJECT_NO',
DESCRIPTION =>'createdfrombackend',
SECURITY_AVAILABLE =>'N',
ENABLE_LONGLIST =>'N',
FORMAT_TYPE =>'Char',
MAXIMUM_SIZE =>30,
precision => NULL,
numbers_only =>'N',
uppercase_only =>'N',
right_justify_zero_fill =>'N',
min_value => NULL,
MAX_VALUE => NULL,
TABLE_APPLICATION => 'Projects',
table_appl_short_name =>'' ,
TABLE_NAME =>'pa_projects_all PPA',
ALLOW_PARENT_VALUES =>'N',
VALUE_COLUMN_NAME =>'PPA.SEGMENT1',
VALUE_COLUMN_TYPE =>'Char',
value_column_size =>30,
meaning_column_name =>'PPA.NAME',
meaning_column_type => 'Char',
MEANING_COLUMN_SIZE => 30,
ID_COLUMN_NAME =>'PPA.PROJECT_ID',--'PRH.SEGMENT1',
ID_COLUMN_TYPE =>'NUMBER',--'Char',
ID_COLUMN_SIZE =>30,--u20,
WHERE_ORDER_BY =>'',
ADDITIONAL_COLUMNS => NULL
);
Commit;
Exception
WHEN OTHERS THEN
dbms_output.put_line(sqlerrm);
end;
No comments:
Post a Comment