5647: l_created_by NUMBER(15);
5648: l_last_update_login NUMBER(15);
5649:
5650:
5651: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
5652: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
5653: l_value_column_size fnd_flex_validation_tables.value_column_size%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5648: l_last_update_login NUMBER(15);
5649:
5650:
5651: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
5652: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
5653: l_value_column_size fnd_flex_validation_tables.value_column_size%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5649:
5650:
5651: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
5652: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
5653: l_value_column_size fnd_flex_validation_tables.value_column_size%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5650:
5651: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
5652: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
5653: l_value_column_size fnd_flex_validation_tables.value_column_size%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5651: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
5652: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
5653: l_value_column_size fnd_flex_validation_tables.value_column_size%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5659: l_meaning_column_type fnd_flex_validation_tables.meaning_column_type%TYPE;
5652: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
5653: l_value_column_size fnd_flex_validation_tables.value_column_size%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5659: l_meaning_column_type fnd_flex_validation_tables.meaning_column_type%TYPE;
5660: l_table_application_id fnd_flex_validation_tables.table_application_id%TYPE;
5653: l_value_column_size fnd_flex_validation_tables.value_column_size%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5659: l_meaning_column_type fnd_flex_validation_tables.meaning_column_type%TYPE;
5660: l_table_application_id fnd_flex_validation_tables.table_application_id%TYPE;
5661: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5654: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5659: l_meaning_column_type fnd_flex_validation_tables.meaning_column_type%TYPE;
5660: l_table_application_id fnd_flex_validation_tables.table_application_id%TYPE;
5661: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5662: l_additional_where_clause VARCHAR2(2000);
5655: l_id_column_size fnd_flex_validation_tables.id_column_size%TYPE;
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5659: l_meaning_column_type fnd_flex_validation_tables.meaning_column_type%TYPE;
5660: l_table_application_id fnd_flex_validation_tables.table_application_id%TYPE;
5661: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5662: l_additional_where_clause VARCHAR2(2000);
5663:
5656: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5659: l_meaning_column_type fnd_flex_validation_tables.meaning_column_type%TYPE;
5660: l_table_application_id fnd_flex_validation_tables.table_application_id%TYPE;
5661: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5662: l_additional_where_clause VARCHAR2(2000);
5663:
5664: l_return_status VARCHAR2(1);
5657: l_meaning_column_name fnd_flex_validation_tables.meaning_column_name%TYPE;
5658: l_meaning_column_size fnd_flex_validation_tables.meaning_column_size%TYPE;
5659: l_meaning_column_type fnd_flex_validation_tables.meaning_column_type%TYPE;
5660: l_table_application_id fnd_flex_validation_tables.table_application_id%TYPE;
5661: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5662: l_additional_where_clause VARCHAR2(2000);
5663:
5664: l_return_status VARCHAR2(1);
5665: l_versioned_vs VARCHAR2(10):= 'False'; -- Parameter to get value if vs is versioned.
5685:
5686: CURSOR Cur_table ( cp_value_set_id NUMBER )
5687: IS
5688: SELECT 1 AS table_exist
5689: FROM fnd_flex_validation_tables
5690: WHERE FLEX_VALUE_SET_ID= cp_value_set_id;
5691:
5692:
5693: