APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_HEADERS_ALL

Line 4570: from po_headers_all

4566: x_error_code := PO_SUCCESS;
4567: -- In case of federal : Populate clm_document_number column to order_number
4568: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(x_doctype_id) = 1 THEN
4569: select clm_document_number into x_order_number
4570: from po_headers_all
4571: where
4572: po_header_id = x_po_header_id;
4573: END IF;
4574: ELSIF (x_return_status = FND_API.g_ret_sts_error

Line 4665: from po_headers_all

4661: x_error_code := PO_SUCCESS;
4662: -- In case of federal : Populate clm_document_number column to order_number
4663: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(x_doctype_id) = 1 THEN
4664: select clm_document_number into x_order_number
4665: from po_headers_all
4666: where
4667: po_header_id = x_po_header_id;
4668: END IF;
4669: ELSIF (x_return_status = PO_INTERFACE_S.G_RET_STS_DUP_DOC_NUM) THEN

Line 4772: FROM pon_orca_cert_details pocd, po_headers_all pha, pon_auction_headers_all paha

4768: sysdate,
4769: fnd_global.user_id,
4770: sysdate,
4771: fnd_global.login_id
4772: FROM pon_orca_cert_details pocd, po_headers_all pha, pon_auction_headers_all paha
4773: WHERE pocd.document_number = paha.document_number
4774: AND paha.auction_header_id = p_auction_header_id
4775: AND pha.po_header_id = x_po_header_id
4776: AND pha.vendor_id = pocd.vendor_id