APPS.POR_WITHDRAW_REQ_SV dependencies on PO_REQUISITION_HEADERS

Line 15: l_req_number po_requisition_headers_all.segment1%type;

11: p_new_requisition_id in number,
12: p_existing_requisition_id in number,
13: p_agentId in number) return number is
14:
15: l_req_number po_requisition_headers_all.segment1%type;
16: l_authorization_status varchar2(50);
17: l_req_doc_type VARCHAR2(20) := 'REQUISITION';
18: l_doc_subtype VARCHAR2(20) := 'PURCHASE';
19: l_req_action_history_code VARCHAR2(20) := 'WITHDRAW';

Line 43: from PO_REQUISITION_HEADERS_ALL

39: -- depends on POXAPFOB.pls 110.2 or higher
40:
41: select segment1, authorization_status
42: into l_req_number, l_authorization_status
43: from PO_REQUISITION_HEADERS_ALL
44: where REQUISITION_HEADER_ID = p_existing_requisition_id;
45:
46: po_negotiation_req_notif.call_negotiation_wf('WITHDRAW', p_existing_requisition_id);
47:

Line 77: delete PO_REQUISITION_HEADERS_ALL

73:
74: delete PO_REQUISITION_LINES_ALL
75: where REQUISITION_HEADER_ID = p_existing_requisition_id;
76:
77: delete PO_REQUISITION_HEADERS_ALL
78: where REQUISITION_HEADER_ID = p_existing_requisition_id;
79:
80: delete po_approval_list_lines
81: where APPROVAL_LIST_HEADER_ID in

Line 95: update PO_REQUISITION_HEADERS_ALL

91: update PO_REQUISITION_LINES_ALL
92: set REQUISITION_HEADER_ID = p_existing_requisition_id
93: where REQUISITION_HEADER_ID = p_new_requisition_id;
94:
95: update PO_REQUISITION_HEADERS_ALL
96: set REQUISITION_HEADER_ID = p_existing_requisition_id,
97: SEGMENT1 = l_req_number,
98: AUTHORIZATION_STATUS = 'INCOMPLETE'
99: where REQUISITION_HEADER_ID = p_new_requisition_id;

Line 192: FROM po_requisition_headers

188: -- abort workflow
189:
190: SELECT wf_item_type, wf_item_key
191: INTO l_item_type, l_item_key
192: FROM po_requisition_headers
193: WHERE requisition_header_id= p_headerId;
194:
195: IF l_item_key is NOT NULL THEN
196: l_progress := 'withdraw_req: 01 '|| l_item_key;