APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_ORCA_CERT_DETAILS

Line 4732: INTO pon_orca_cert_details (

4728: log_message(x_progress);
4729: --ORCA Integration
4730: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(x_doctype_id) = 1 THEN
4731: INSERT
4732: INTO pon_orca_cert_details (
4733: ORCA_CERT_DETAILS_ID,
4734: VENDOR_ID,
4735: VENDOR_SITE_ID,
4736: DUNS_NUMBER,

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