APPS.CLN_3A9_CANCELPO_PKG dependencies on PO_RELEASES_ALL

Line 53: FROM po_releases_all

49: ELSIF (p_hdr_type = 'RELEASE' AND (p_hdr_sub_type = 'BLANKET'
50: OR p_hdr_sub_type = 'SCHEDULED')) THEN -- Release
51: SELECT authorization_status
52: INTO l_authorization_status
53: FROM po_releases_all
54: WHERE po_release_id = p_document_id;
55: IF l_authorization_status <> 'APPROVED' THEN
56: RETURN;
57: 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 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: