APPS.GL_ACCOUNTS_MAP_GRP dependencies on FND_FLEX_VALIDATION_TABLES

Line 404: val_table_name fnd_flex_validation_tables.application_table_name%TYPE;

400: PROCEDURE interim_rollup_map(mapping_id IN NUMBER,
401: to_application_column_name IN VARCHAR2,
402: from_value_set_id IN NUMBER
403: ) IS
404: val_table_name fnd_flex_validation_tables.application_table_name%TYPE;
405: val_column_name fnd_flex_validation_tables.value_column_name%TYPE;
406:
407: detail_parent_flag VARCHAR2(1);
408: detail_ranges_flag VARCHAR2(1);

Line 405: val_column_name fnd_flex_validation_tables.value_column_name%TYPE;

401: to_application_column_name IN VARCHAR2,
402: from_value_set_id IN NUMBER
403: ) IS
404: val_table_name fnd_flex_validation_tables.application_table_name%TYPE;
405: val_column_name fnd_flex_validation_tables.value_column_name%TYPE;
406:
407: detail_parent_flag VARCHAR2(1);
408: detail_ranges_flag VARCHAR2(1);
409: summary_ranges_flag VARCHAR2(1);

Line 414: insert_1_col fnd_flex_validation_tables.application_table_name%TYPE;

410: summary_parent_flag VARCHAR2(1);
411:
412: insert_1 VARCHAR2(3000);
413:
414: insert_1_col fnd_flex_validation_tables.application_table_name%TYPE;
415: insert_1_table fnd_flex_validation_tables.value_column_name%TYPE;
416: insert_1_join VARCHAR2(100);
417: insert_1_select_type VARCHAR2(40);
418:

Line 415: insert_1_table fnd_flex_validation_tables.value_column_name%TYPE;

411:
412: insert_1 VARCHAR2(3000);
413:
414: insert_1_col fnd_flex_validation_tables.application_table_name%TYPE;
415: insert_1_table fnd_flex_validation_tables.value_column_name%TYPE;
416: insert_1_join VARCHAR2(100);
417: insert_1_select_type VARCHAR2(40);
418:
419: -- selects the table and column name used for table validation for the

Line 424: FROM fnd_flex_validation_tables fvt,

420: -- source chart of accounts, if applicable.
421: CURSOR c_check_table_validated IS
422: SELECT fvt.application_table_name,
423: fvt.value_column_name
424: FROM fnd_flex_validation_tables fvt,
425: fnd_flex_value_sets fvs
426: WHERE fvs.flex_value_set_id = from_value_set_id
427: AND fvs.validation_type = 'F'
428: AND fvs.flex_value_set_id = fvt.flex_value_set_id;