APPS.FV_BE_INT_PKG dependencies on FND_FLEX_VALIDATION_TABLES

Line 127: l_application_table_name FND_FLEX_VALIDATION_TABLES.application_table_name%type;

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

Line 128: l_value_column_name FND_FLEX_VALIDATION_TABLES.value_column_name%type;

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

Line 777: FROM FND_FLEX_VALIDATION_TABLES

773: SELECT
774: application_table_name,
775: value_column_name
776: INTO l_application_table_name,l_value_column_name
777: FROM FND_FLEX_VALIDATION_TABLES
778: WHERE flex_value_set_id=val_set_id_array(substr(app_col_rec.application_column_name,8,2));
779:
780: l_table_stmt := ' SELECT 1 FROM '||l_application_table_name ||
781: ' WHERE ' || l_value_column_name ||' = :b_seg_value' ;