APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_REQUISITION_HEADERS_ALL

Line 55: po_requisition_headers_all.type_lookup_code%TYPE;

51: -- Bulk collect
52: l_id_key NUMBER;
53: -- First their table types
54: TYPE l_doc_sub_type_list_type IS TABLE OF
55: po_requisition_headers_all.type_lookup_code%TYPE;
56: TYPE l_approval_id_list_type IS TABLE OF
57: po_document_types_all.default_approval_path_id%TYPE;
58: TYPE l_org_id_list_type IS TABLE OF
59: po_requisition_headers_all.org_id%TYPE;

Line 59: po_requisition_headers_all.org_id%TYPE;

55: po_requisition_headers_all.type_lookup_code%TYPE;
56: TYPE l_approval_id_list_type IS TABLE OF
57: po_document_types_all.default_approval_path_id%TYPE;
58: TYPE l_org_id_list_type IS TABLE OF
59: po_requisition_headers_all.org_id%TYPE;
60:
61: TYPE l_rowid_char_tbl_type IS TABLE OF VARCHAR2(18);
62: -- The local tables
63: l_doc_sub_type_tbl l_doc_sub_type_list_type;

Line 120: FROM po_requisition_headers_all prh,

116: =
117: ( SELECT prh.type_lookup_code,
118: podc.default_approval_path_id,
119: prh.org_id
120: FROM po_requisition_headers_all prh,
121: po_document_types_all podc
122: WHERE prh.requisition_header_id = p_req_header_id_tbl(i)
123: AND podc.document_type_code = 'REQUISITION'
124: AND podc.document_subtype = prh.type_lookup_code

Line 152: FROM po_requisition_headers_all

148: --Update the header status to returned for PAR document,if no par line exists on any mod.
149: UPDATE po_drafts
150: SET status = 'RETURNED'
151: WHERE draft_id IN (SELECT par_draft_id
152: FROM po_requisition_headers_all
153: -- Bug 16778189- Use column_value instaed of requisition_header_id
154: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl)))
155: AND NOT EXISTS (SELECT par_line_id
156: FROM po_requisition_lines_all prl

Line 175: FROM po_requisition_headers_all

171: FROM po_requisition_lines_all
172: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl)))
173: --Bug 16778189 - Include draftId condition
174: AND draft_id IN (SELECT par_draft_id
175: FROM po_requisition_headers_all
176: WHERE requisition_header_id IN (SELECT column_value FROM TABLE(p_req_header_id_tbl)))
177: AND mod_draft_id IS NULL;
178:
179: IF (SQL%ROWCOUNT > 0) THEN