DBA Data[Home] [Help]

APPS.PO_REQ_DOCUMENT_CANCEL_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 66: l_req_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

62: l_progress VARCHAR2(3) := '000';
63:
64: l_encumbrance_flag VARCHAR2(1);
65: l_oe_installed_flag VARCHAR2(1) := 'Y';
66: l_req_subtype PO_REQUISITION_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
67:
68: l_po_return_code VARCHAR2(25);
69: l_online_report_id NUMBER;
70: l_req_control_error_rc VARCHAR2(1);

Line 73: l_document_org_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;

69: l_online_report_id NUMBER;
70: l_req_control_error_rc VARCHAR2(1);
71:
72: -- Bug 3362534 START
73: l_document_org_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;
74: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.GET_CURRENT_ORG_ID ; -- added
75: -- Bug 3362534 END
76:
77: BEGIN

Line 98: FROM PO_REQUISITION_HEADERS_ALL

94: SELECT type_lookup_code,
95: org_id -- Bug 3362534
96: INTO l_req_subtype,
97: l_document_org_id
98: FROM PO_REQUISITION_HEADERS_ALL
99: WHERE requisition_header_id = p_req_header_id(i);
100:
101: -- Bug 3362534 START
102: -- Set the org context to the operating unit of the document.