APPS.IEX_SEND_XML_PVT dependencies on DBMS_SQL

Line 825: v_cursor := DBMS_SQL.OPEN_CURSOR;

821: -- no check of the query
822: -- execute the query to see if any records returned.
823: BEGIN
824: WriteLog('GetXmlData: execute query');
825: v_cursor := DBMS_SQL.OPEN_CURSOR;
826: DBMS_SQL.parse( v_cursor, l_new_query, 1);
827: v_numrows := DBMS_SQL.EXECUTE( v_cursor);
828: v_numrows := DBMS_SQL.FETCH_ROWS( v_cursor);
829: DBMS_SQL.CLOSE_CURSOR( v_cursor);

Line 826: DBMS_SQL.parse( v_cursor, l_new_query, 1);

822: -- execute the query to see if any records returned.
823: BEGIN
824: WriteLog('GetXmlData: execute query');
825: v_cursor := DBMS_SQL.OPEN_CURSOR;
826: DBMS_SQL.parse( v_cursor, l_new_query, 1);
827: v_numrows := DBMS_SQL.EXECUTE( v_cursor);
828: v_numrows := DBMS_SQL.FETCH_ROWS( v_cursor);
829: DBMS_SQL.CLOSE_CURSOR( v_cursor);
830: EXCEPTION

Line 827: v_numrows := DBMS_SQL.EXECUTE( v_cursor);

823: BEGIN
824: WriteLog('GetXmlData: execute query');
825: v_cursor := DBMS_SQL.OPEN_CURSOR;
826: DBMS_SQL.parse( v_cursor, l_new_query, 1);
827: v_numrows := DBMS_SQL.EXECUTE( v_cursor);
828: v_numrows := DBMS_SQL.FETCH_ROWS( v_cursor);
829: DBMS_SQL.CLOSE_CURSOR( v_cursor);
830: EXCEPTION
831: when others then

Line 828: v_numrows := DBMS_SQL.FETCH_ROWS( v_cursor);

824: WriteLog('GetXmlData: execute query');
825: v_cursor := DBMS_SQL.OPEN_CURSOR;
826: DBMS_SQL.parse( v_cursor, l_new_query, 1);
827: v_numrows := DBMS_SQL.EXECUTE( v_cursor);
828: v_numrows := DBMS_SQL.FETCH_ROWS( v_cursor);
829: DBMS_SQL.CLOSE_CURSOR( v_cursor);
830: EXCEPTION
831: when others then
832: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');

Line 829: DBMS_SQL.CLOSE_CURSOR( v_cursor);

825: v_cursor := DBMS_SQL.OPEN_CURSOR;
826: DBMS_SQL.parse( v_cursor, l_new_query, 1);
827: v_numrows := DBMS_SQL.EXECUTE( v_cursor);
828: v_numrows := DBMS_SQL.FETCH_ROWS( v_cursor);
829: DBMS_SQL.CLOSE_CURSOR( v_cursor);
830: EXCEPTION
831: when others then
832: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_CANT_EXEC_QRY');
833: FND_MESSAGE.Set_Token ('ID', p_query_id);