BEGIN
FND_FLEX_VAL_API.SET_SESSION_MODE ('customer_data'); /*Mandatory*/
FND_FLEX_VAL_API.CREATE_VALUESET_TABLE (
value_set_name => 'XX_VALUESET',
description => 'createdfrombackend',
security_available => 'N',
enable_longlist => 'N',
format_type => 'Char',
maximum_size => 20,
PRECISION => NULL,
numbers_only => 'N',
uppercase_only => 'N',
right_justify_zero_fill => 'N',
min_value => NULL,
max_value => NULL,
table_application => 'Application Object Library',
table_appl_short_name => 'AOL',
table_name => 'FND_LOOKUP_VALUES FND',
allow_parent_values => 'N',
value_column_name => 'FND.LOOKUP_CODE',
value_column_type => 'Char',
value_column_size => 40,
meaning_column_name => NULL,
meaning_column_type => NULL,
meaning_column_size => 40,
id_column_name => 'FND.MEANING',
id_column_type => 'Char',
id_column_size => 40,
where_order_by => 'where lookup_type=''XXTEST_LOOKUP''',
additional_columns => NULL
);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (SQLERRM);
END;
/
FND_FLEX_VAL_API.SET_SESSION_MODE ('customer_data'); /*Mandatory*/
FND_FLEX_VAL_API.CREATE_VALUESET_TABLE (
value_set_name => 'XX_VALUESET',
description => 'createdfrombackend',
security_available => 'N',
enable_longlist => 'N',
format_type => 'Char',
maximum_size => 20,
PRECISION => NULL,
numbers_only => 'N',
uppercase_only => 'N',
right_justify_zero_fill => 'N',
min_value => NULL,
max_value => NULL,
table_application => 'Application Object Library',
table_appl_short_name => 'AOL',
table_name => 'FND_LOOKUP_VALUES FND',
allow_parent_values => 'N',
value_column_name => 'FND.LOOKUP_CODE',
value_column_type => 'Char',
value_column_size => 40,
meaning_column_name => NULL,
meaning_column_type => NULL,
meaning_column_size => 40,
id_column_name => 'FND.MEANING',
id_column_type => 'Char',
id_column_size => 40,
where_order_by => 'where lookup_type=''XXTEST_LOOKUP''',
additional_columns => NULL
);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (SQLERRM);
END;
/
No comments:
Post a Comment