eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on DBMS_SQL

Line 28: l_line_ids dbms_sql.NUMBER_TABLE;

24: END IF;
25: END bool_to_varchar;
26:
27: PROCEDURE delete_requisition_internal(p_header_id IN NUMBER, p_working_copy IN BOOLEAN, p_is_purge_req_process IN BOOLEAN default false) IS
28: l_line_ids dbms_sql.NUMBER_TABLE;
29: l_award_ids dbms_sql.NUMBER_TABLE;
30: l_status VARCHAR2(1);
31: l_err_msg VARCHAR2(4000);
32: l_progress VARCHAR2(4) := '000';

Line 29: l_award_ids dbms_sql.NUMBER_TABLE;

25: END bool_to_varchar;
26:
27: PROCEDURE delete_requisition_internal(p_header_id IN NUMBER, p_working_copy IN BOOLEAN, p_is_purge_req_process IN BOOLEAN default false) IS
28: l_line_ids dbms_sql.NUMBER_TABLE;
29: l_award_ids dbms_sql.NUMBER_TABLE;
30: l_status VARCHAR2(1);
31: l_err_msg VARCHAR2(4000);
32: l_progress VARCHAR2(4) := '000';
33: l_DocumentTypeCode po_requisition_headers_all.type_lookup_code%TYPE;

Line 420: cursorID := dbms_sql.open_cursor;

416:
417: --bug 2522835 changed the direct select statement to dynamic query
418: --to remove dependency on POR_REQ_NUMBER_S sequence
419:
420: cursorID := dbms_sql.open_cursor;
421:
422: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);

Line 424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);

420: cursorID := dbms_sql.open_cursor;
421:
422: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
425: dbms_sql.define_column(cursorID, 1, l_req_num);
426: result := dbms_sql.execute_and_fetch(cursorID,false);
427: dbms_sql.column_value(cursorID, 1, l_req_num);
428:

Line 425: dbms_sql.define_column(cursorID, 1, l_req_num);

421:
422: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
425: dbms_sql.define_column(cursorID, 1, l_req_num);
426: result := dbms_sql.execute_and_fetch(cursorID,false);
427: dbms_sql.column_value(cursorID, 1, l_req_num);
428:
429: WHILE (req_number_invalid(l_req_num) AND l_counter <= l_no_of_trials ) LOOP

Line 426: result := dbms_sql.execute_and_fetch(cursorID,false);

422: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
425: dbms_sql.define_column(cursorID, 1, l_req_num);
426: result := dbms_sql.execute_and_fetch(cursorID,false);
427: dbms_sql.column_value(cursorID, 1, l_req_num);
428:
429: WHILE (req_number_invalid(l_req_num) AND l_counter <= l_no_of_trials ) LOOP
430: result := dbms_sql.execute_and_fetch(cursorID,false);

Line 427: dbms_sql.column_value(cursorID, 1, l_req_num);

423: sqlString := 'select POR_REQ_NUMBER_S.nextval from sys.dual';
424: dbms_sql.parse(cursorID, sqlString, dbms_sql.NATIVE);
425: dbms_sql.define_column(cursorID, 1, l_req_num);
426: result := dbms_sql.execute_and_fetch(cursorID,false);
427: dbms_sql.column_value(cursorID, 1, l_req_num);
428:
429: WHILE (req_number_invalid(l_req_num) AND l_counter <= l_no_of_trials ) LOOP
430: result := dbms_sql.execute_and_fetch(cursorID,false);
431: dbms_sql.column_value(cursorID, 1, l_req_num);

Line 430: result := dbms_sql.execute_and_fetch(cursorID,false);

426: result := dbms_sql.execute_and_fetch(cursorID,false);
427: dbms_sql.column_value(cursorID, 1, l_req_num);
428:
429: WHILE (req_number_invalid(l_req_num) AND l_counter <= l_no_of_trials ) LOOP
430: result := dbms_sql.execute_and_fetch(cursorID,false);
431: dbms_sql.column_value(cursorID, 1, l_req_num);
432: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
433: l_counter := l_counter + 1;
434: END LOOP;

Line 431: dbms_sql.column_value(cursorID, 1, l_req_num);

427: dbms_sql.column_value(cursorID, 1, l_req_num);
428:
429: WHILE (req_number_invalid(l_req_num) AND l_counter <= l_no_of_trials ) LOOP
430: result := dbms_sql.execute_and_fetch(cursorID,false);
431: dbms_sql.column_value(cursorID, 1, l_req_num);
432: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
433: l_counter := l_counter + 1;
434: END LOOP;
435:

Line 436: dbms_sql.close_cursor(cursorID);

432: --select POR_REQ_NUMBER_S.nextval into l_req_num from sys.dual;
433: l_counter := l_counter + 1;
434: END LOOP;
435:
436: dbms_sql.close_cursor(cursorID);
437:
438: IF (l_counter < l_no_of_trials) THEN
439: RETURN l_req_num;
440: ELSE