APPS.JA_CN_UTILITY dependencies on FND_FLEX_VALIDATION_TABLES

Line 1302: l_Fv_Table Fnd_Flex_Validation_Tables.Application_Table_Name%TYPE;

1298: l_Ledger_Category VARCHAR2(30);
1299: l_Bsv_Option VARCHAR2(1);
1300: l_Bsv_Vset_Id NUMBER;
1301:
1302: l_Fv_Table Fnd_Flex_Validation_Tables.Application_Table_Name%TYPE;
1303: l_Fv_Col Fnd_Flex_Validation_Tables.Value_Column_Name%TYPE;
1304: l_Fv_Type Fnd_Flex_Value_Sets.Validation_Type%TYPE;
1305: l_Insertsql Dbms_Sql.Varchar2s;
1306: l_Line_No NUMBER := 0;

Line 1303: l_Fv_Col Fnd_Flex_Validation_Tables.Value_Column_Name%TYPE;

1299: l_Bsv_Option VARCHAR2(1);
1300: l_Bsv_Vset_Id NUMBER;
1301:
1302: l_Fv_Table Fnd_Flex_Validation_Tables.Application_Table_Name%TYPE;
1303: l_Fv_Col Fnd_Flex_Validation_Tables.Value_Column_Name%TYPE;
1304: l_Fv_Type Fnd_Flex_Value_Sets.Validation_Type%TYPE;
1305: l_Insertsql Dbms_Sql.Varchar2s;
1306: l_Line_No NUMBER := 0;
1307: l_Cursorid INTEGER;

Line 1421: Fnd_Flex_Validation_Tables Fvt

1417: INTO l_Fv_Table,
1418: l_Fv_Col,
1419: l_Fv_Type
1420: FROM Fnd_Flex_Value_Sets Fvs,
1421: Fnd_Flex_Validation_Tables Fvt
1422: WHERE Fvs.Flex_Value_Set_Id = l_Bsv_Vset_Id
1423: AND Fvt.Flex_Value_Set_Id(+) = Fvs.Flex_Value_Set_Id;
1424:
1425: -- Build INSERT statement of the dynamic INSERT SQL