APPS.JA_CN_UTILITY dependencies on DBMS_SQL

Line 1183: l_Insertsql Dbms_Sql.Varchar2s;

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;
1186: l_Return_No NUMBER;
1187: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

Line 1372: l_Cursorid := Dbms_Sql.Open_Cursor;

1368: l_Insertsql(l_Line_No) := 'AND bsv.summary_flag = ''N'' ';
1369: END IF;
1370:
1371: -- Open cursor
1372: l_Cursorid := Dbms_Sql.Open_Cursor;
1373: Dbms_Sql.Parse(l_Cursorid,
1374: l_Insertsql,
1375: 1,
1376: l_Line_No,

Line 1373: Dbms_Sql.Parse(l_Cursorid,

1369: END IF;
1370:
1371: -- Open cursor
1372: l_Cursorid := Dbms_Sql.Open_Cursor;
1373: Dbms_Sql.Parse(l_Cursorid,
1374: l_Insertsql,
1375: 1,
1376: l_Line_No,
1377: TRUE,

Line 1378: Dbms_Sql.Native);

1374: l_Insertsql,
1375: 1,
1376: l_Line_No,
1377: TRUE,
1378: Dbms_Sql.Native);
1379:
1380: -- Bind variables
1381: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1382: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);

Line 1381: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);

1377: TRUE,
1378: Dbms_Sql.Native);
1379:
1380: -- Bind variables
1381: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1382: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);
1383:
1384: -- Execute INSERT SQL
1385: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);

Line 1382: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);

1378: Dbms_Sql.Native);
1379:
1380: -- Bind variables
1381: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1382: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);
1383:
1384: -- Execute INSERT SQL
1385: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);
1386:

Line 1385: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);

1381: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1382: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);
1383:
1384: -- Execute INSERT SQL
1385: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);
1386:
1387: -- Close cursor
1388: Dbms_Sql.Close_Cursor(l_Cursorid);
1389:

Line 1388: Dbms_Sql.Close_Cursor(l_Cursorid);

1384: -- Execute INSERT SQL
1385: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);
1386:
1387: -- Close cursor
1388: Dbms_Sql.Close_Cursor(l_Cursorid);
1389:
1390: ELSE
1391: -- Invalid BSV option code for the passed ledger
1392: RETURN 'S';