APPS.CLN_3A9_CANCELPO_PKG dependencies on PO_HEADERS_ALL

Line 42: FROM po_headers_all

38: l_cln_not_parameters := wf_parameter_list_t();
39: IF (p_hdr_type = 'PO' AND p_hdr_sub_type = 'STANDARD') THEN -- Standard PO
40: SELECT authorization_status
41: INTO l_authorization_status
42: FROM po_headers_all
43: WHERE po_header_id = p_document_id;
44: IF l_authorization_status <> 'APPROVED' THEN
45: RETURN;
46: END IF;

Line 144: FROM po_headers_all poh, po_releases_all por

140: -- and Sales Order Number based on PO Header ID or Po Release ID
141: IF l_po_release_id = -1 THEN
142: SELECT poh.segment1, por.release_num, poh.revision_num, poh.vendor_order_num
143: INTO l_po_number, l_rel_number, l_rev_number, l_supp_ord_number
144: FROM po_headers_all poh, po_releases_all por
145: WHERE poh.po_header_id = l_po_header_id
146: AND poh.po_header_id = por.po_header_id(+);
147: ELSE
148: SELECT poh.po_header_id, poh.segment1, por.release_num, por.revision_num, poh.vendor_order_num

Line 150: FROM po_headers_all poh, po_releases_all por

146: AND poh.po_header_id = por.po_header_id(+);
147: ELSE
148: SELECT poh.po_header_id, poh.segment1, por.release_num, por.revision_num, poh.vendor_order_num
149: INTO l_po_header_id, l_po_number, l_rel_number, l_rev_number, l_supp_ord_number
150: FROM po_headers_all poh, po_releases_all por
151: WHERE por.po_release_id = l_po_release_id
152: AND poh.po_header_id = por.po_header_id(+);
153: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POHEADERID', l_po_header_id);
154: END IF;

Line 185: FROM PO_HEADERS_ALL

181: -- Query PO base tables/views to get Party ID and Party Site ID
182: -- based on PO Header ID
183: SELECT VENDOR_ID, VENDOR_SITE_ID
184: INTO l_party_id, l_party_site_id
185: FROM PO_HEADERS_ALL
186: WHERE PO_HEADER_ID = l_po_header_id;
187:
188: IF (l_Debug_Level <= 1) THEN
189: cln_debug_pub.Add('l_party_id:' || l_party_id, 1);

Line 264: FROM po_headers_all poh

260: -- Query for XML flag based on PO Header ID or PO Release ID
261: IF l_po_release_id = -1 THEN
262: SELECT poh.xml_flag
263: INTO l_xml_flag
264: FROM po_headers_all poh
265: WHERE po_header_id= l_po_header_id;
266: ELSE
267: SELECT por.xml_flag
268: INTO l_xml_flag

Line 269: FROM po_headers_all poh, po_releases_all por

265: WHERE po_header_id= l_po_header_id;
266: ELSE
267: SELECT por.xml_flag
268: INTO l_xml_flag
269: FROM po_headers_all poh, po_releases_all por
270: WHERE poh.po_header_id = por.po_header_id
271: AND por.po_release_id = l_po_release_id;
272: END IF;
273: