eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1364: FROM pon_auction_headers_all pah,pon_auc_doctypes doc

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

Line 1855: pon_auc_doctypes doc

1851:
1852: select pon_auction_pkg.get_message_suffix(doc.internal_name)
1853: into l_message_suffix
1854: from pon_auction_headers_all pah,
1855: pon_auc_doctypes doc
1856: where pah.auction_header_id = l_auction_header_id
1857: and pah.doctype_id = doc.doctype_id;
1858: EXCEPTION
1859: WHEN no_data_found THEN

Line 2007: pon_auc_doctypes doc

2003:
2004: select pon_auction_pkg.get_message_suffix(doc.internal_name)
2005: into l_message_suffix
2006: from pon_auction_headers_all pah,
2007: pon_auc_doctypes doc
2008: where pah.auction_header_id = l_auction_header_id
2009: and pah.doctype_id = doc.doctype_id;
2010: EXCEPTION
2011: WHEN no_data_found THEN