APPS.JA_CN_UTILITY dependencies on DBMS_SQL

Line 1305: l_Insertsql Dbms_Sql.Varchar2s;

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

Line 1494: l_Cursorid := Dbms_Sql.Open_Cursor;

1490: l_Insertsql(l_Line_No) := 'AND bsv.summary_flag = ''N'' ';
1491: END IF;
1492:
1493: -- Open cursor
1494: l_Cursorid := Dbms_Sql.Open_Cursor;
1495: Dbms_Sql.Parse(l_Cursorid,
1496: l_Insertsql,
1497: 1,
1498: l_Line_No,

Line 1495: Dbms_Sql.Parse(l_Cursorid,

1491: END IF;
1492:
1493: -- Open cursor
1494: l_Cursorid := Dbms_Sql.Open_Cursor;
1495: Dbms_Sql.Parse(l_Cursorid,
1496: l_Insertsql,
1497: 1,
1498: l_Line_No,
1499: TRUE,

Line 1500: Dbms_Sql.Native);

1496: l_Insertsql,
1497: 1,
1498: l_Line_No,
1499: TRUE,
1500: Dbms_Sql.Native);
1501:
1502: -- Bind variables
1503: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1504: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);

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

1499: TRUE,
1500: Dbms_Sql.Native);
1501:
1502: -- Bind variables
1503: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1504: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);
1505:
1506: -- Execute INSERT SQL
1507: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);

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

1500: Dbms_Sql.Native);
1501:
1502: -- Bind variables
1503: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1504: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);
1505:
1506: -- Execute INSERT SQL
1507: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);
1508:

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

1503: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id1', p_Ledger_Id);
1504: Dbms_Sql.Bind_Variable(l_Cursorid, ':lg_id2', p_Ledger_Id);
1505:
1506: -- Execute INSERT SQL
1507: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);
1508:
1509: -- Close cursor
1510: Dbms_Sql.Close_Cursor(l_Cursorid);
1511:

Line 1510: Dbms_Sql.Close_Cursor(l_Cursorid);

1506: -- Execute INSERT SQL
1507: l_Return_No := Dbms_Sql.EXECUTE(l_Cursorid);
1508:
1509: -- Close cursor
1510: Dbms_Sql.Close_Cursor(l_Cursorid);
1511:
1512: ELSE
1513: -- Invalid BSV option code for the passed ledger
1514: RETURN 'S';