APPS.PO_PAR_REQ_CREATE_UTIL dependencies on PO_REQUISITION_HEADERS_ALL

Line 46: INSERT INTO po_requisition_headers_all

42: AND draft_id = p_par_draft_id;
43:
44:
45: -- INSERT HEADERS
46: INSERT INTO po_requisition_headers_all
47: (requisition_header_id,
48: preparer_id,
49: segment1,
50: summary_flag,

Line 605: FROM po_requisition_headers_all

601: END IF;
602:
603: Select preparer_id
604: INTO p_preparer_id
605: FROM po_requisition_headers_all
606: WHERE
607: requisition_header_id = p_par_req_header_id;
608: l_progress := '002';
609: IF ( po_log.d_stmt ) THEN

Line 736: UPDATE po_requisition_headers_all

732: PROCEDURE Par_req_status_update(l_par_req_header_id NUMBER)
733: IS
734: PRAGMA autonomous_transaction;
735: BEGIN
736: UPDATE po_requisition_headers_all
737: SET authorization_status = 'APPROVED'
738: WHERE requisition_header_id = l_par_req_header_id;
739:
740: UPDATE po_requisition_lines_all