DBA Data[Home] [Help]

APPS.JA_CN_UTILITY dependencies on FND_FLEX_VALIDATION_TABLES

Line 1180: l_Fv_Table Fnd_Flex_Validation_Tables.Application_Table_Name%TYPE;

1176: l_Ledger_Category VARCHAR2(30);
1177: l_Bsv_Option VARCHAR2(1);
1178: l_Bsv_Vset_Id NUMBER;
1179:
1180: l_Fv_Table Fnd_Flex_Validation_Tables.Application_Table_Name%TYPE;
1181: l_Fv_Col Fnd_Flex_Validation_Tables.Value_Column_Name%TYPE;
1182: l_Fv_Type Fnd_Flex_Value_Sets.Validation_Type%TYPE;
1183: l_Insertsql Dbms_Sql.Varchar2s;
1184: l_Line_No NUMBER := 0;

Line 1181: l_Fv_Col Fnd_Flex_Validation_Tables.Value_Column_Name%TYPE;

1177: l_Bsv_Option VARCHAR2(1);
1178: l_Bsv_Vset_Id NUMBER;
1179:
1180: l_Fv_Table Fnd_Flex_Validation_Tables.Application_Table_Name%TYPE;
1181: l_Fv_Col Fnd_Flex_Validation_Tables.Value_Column_Name%TYPE;
1182: l_Fv_Type Fnd_Flex_Value_Sets.Validation_Type%TYPE;
1183: l_Insertsql Dbms_Sql.Varchar2s;
1184: l_Line_No NUMBER := 0;
1185: l_Cursorid INTEGER;

Line 1299: Fnd_Flex_Validation_Tables Fvt

1295: INTO l_Fv_Table,
1296: l_Fv_Col,
1297: l_Fv_Type
1298: FROM Fnd_Flex_Value_Sets Fvs,
1299: Fnd_Flex_Validation_Tables Fvt
1300: WHERE Fvs.Flex_Value_Set_Id = l_Bsv_Vset_Id
1301: AND Fvt.Flex_Value_Set_Id(+) = Fvs.Flex_Value_Set_Id;
1302:
1303: -- Build INSERT statement of the dynamic INSERT SQL