APPS.FV_BE_INT_PKG dependencies on FND_FLEX_VALIDATION_TABLES

Line 128: l_application_table_name FND_FLEX_VALIDATION_TABLES.application_table_name%type;

124:
125: l_module_name VARCHAR2(200);
126: v_status VARCHAR2(25);
127: l_bu_group_id NUMBER(15);
128: l_application_table_name FND_FLEX_VALIDATION_TABLES.application_table_name%type;
129: l_value_column_name FND_FLEX_VALIDATION_TABLES.value_column_name%type;
130: l_table_stmt VARCHAR2(1000);
131: l_validation_type VARCHAR2(2);
132:

Line 129: l_value_column_name FND_FLEX_VALIDATION_TABLES.value_column_name%type;

125: l_module_name VARCHAR2(200);
126: v_status VARCHAR2(25);
127: l_bu_group_id NUMBER(15);
128: l_application_table_name FND_FLEX_VALIDATION_TABLES.application_table_name%type;
129: l_value_column_name FND_FLEX_VALIDATION_TABLES.value_column_name%type;
130: l_table_stmt VARCHAR2(1000);
131: l_validation_type VARCHAR2(2);
132:
133: -- Cursor for selecting records from

Line 812: FROM FND_FLEX_VALIDATION_TABLES

808: SELECT
809: application_table_name,
810: value_column_name
811: INTO l_application_table_name,l_value_column_name
812: FROM FND_FLEX_VALIDATION_TABLES
813: WHERE flex_value_set_id=val_set_id_array(substr(app_col_rec.application_column_name,8,2));
814:
815: l_table_stmt := ' SELECT 1 FROM '||l_application_table_name ||
816: ' WHERE ' || l_value_column_name ||' = :b_seg_value' ;