APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_DOCTYPES

Line 42: pon_auc_doctypes doc

38:
39: select pon_auction_pkg.get_message_suffix(doc.internal_name)
40: into l_message_suffix
41: from pon_auction_headers_all pah,
42: pon_auc_doctypes doc
43: where pah.auction_header_id = l_auction_header_id
44: and pah.doctype_id = doc.doctype_id;
45: EXCEPTION
46: WHEN no_data_found THEN

Line 506: pon_auc_doctypes doc

502:
503: select pon_auction_pkg.get_message_suffix(doc.internal_name)
504: into l_message_suffix
505: from pon_auction_headers_all pah,
506: pon_auc_doctypes doc
507: where pah.auction_header_id = l_auction_header_id
508: and pah.doctype_id = doc.doctype_id;
509: EXCEPTION
510: WHEN no_data_found THEN

Line 662: pon_auc_doctypes doc

658:
659: select pon_auction_pkg.get_message_suffix(doc.internal_name)
660: into l_message_suffix
661: from pon_auction_headers_all pah,
662: pon_auc_doctypes doc
663: where pah.auction_header_id = l_auction_header_id
664: and pah.doctype_id = doc.doctype_id;
665: EXCEPTION
666: WHEN no_data_found THEN

Line 1359: FROM pon_auction_headers_all pah,pon_auc_doctypes doc

1355: WHERE papd.batch_id = p_batch_id;
1356:
1357: SELECT pon_auction_pkg.get_message_suffix(doc.internal_name)
1358: INTO l_message_suffix
1359: FROM pon_auction_headers_all pah,pon_auc_doctypes doc
1360: WHERE pah.auction_header_id = l_auction_header_id
1361: AND pah.doctype_id = doc.doctype_id;
1362:
1363: --Don't do any validation if its not a global blanket agreement