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_AUCTION_HEADERS_ALL

Line 41: from pon_auction_headers_all pah,

37: where pape.batch_id = p_batch_id;
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

Line 500: from pon_auction_headers_all pah

496: where pai.batch_id = p_batch_id;
497:
498: select hdr_attr_enable_weights
499: into l_hdr_attr_enable_weights
500: from pon_auction_headers_all pah
501: where pah.auction_header_id = l_auction_header_id;
502:
503: select pon_auction_pkg.get_message_suffix(doc.internal_name)
504: into l_message_suffix

Line 505: from pon_auction_headers_all pah,

501: where pah.auction_header_id = l_auction_header_id;
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

Line 661: from pon_auction_headers_all pah,

657: where pai.batch_id = p_batch_id;
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

Line 1184: FROM pon_auction_headers_all

1180:
1181: -- determine which price factor types are allowed by the negotiation
1182: SELECT pf_type_allowed
1183: INTO l_auction_pf_type_allowed
1184: FROM pon_auction_headers_all
1185: WHERE auction_header_id = p_auction_header_id;
1186:
1187: -- insert template price elements for all lines
1188: insert into pon_auc_price_elements_int (

Line 1348: l_contract_type pon_auction_headers_all.contract_type%TYPE;

1344: )AS
1345:
1346: l_auction_header_id pon_auc_price_differ_int.auction_header_id%TYPE;
1347: l_message_suffix VARCHAR2(2);
1348: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1349: l_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
1350:
1351: BEGIN
1352:

Line 1349: l_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;

1345:
1346: l_auction_header_id pon_auc_price_differ_int.auction_header_id%TYPE;
1347: l_message_suffix VARCHAR2(2);
1348: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1349: l_global_agreement pon_auction_headers_all.global_agreement_flag%TYPE;
1350:
1351: BEGIN
1352:
1353: -- init vars

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 1372: FROM pon_auction_headers_all pah

1368: --Don't do any validation if its not a global blanket agreement
1369: -- And if there are any rows in the interface table delete them
1370: SELECT pah.contract_type, pah.global_agreement_flag
1371: INTO l_contract_type, l_global_agreement
1372: FROM pon_auction_headers_all pah
1373: WHERE pah.auction_header_id = l_auction_header_id;
1374:
1375: IF ((l_contract_type <> 'BLANKET' AND l_contract_type <> 'CONTRACT') OR l_global_agreement <> 'Y') THEN
1376: DELETE FROM pon_auc_price_differ_int

Line 1510: from pon_auction_headers_all

1506: BEGIN
1507:
1508: select trading_partner_id, nvl(auction_round_number, 1), nvl(amendment_number, 0)
1509: into l_tp_id, l_auction_round_number, l_amendment_number
1510: from pon_auction_headers_all
1511: where auction_header_id = p_auction_header_id;
1512:
1513: select nvl(ppp.preference_value,'GENERAL')
1514: into l_default_attr_group

Line 1849: from pon_auction_headers_all pah

1845: where pai.batch_id = p_batch_id;
1846:
1847: select hdr_attr_enable_weights
1848: into l_hdr_attr_enable_weights
1849: from pon_auction_headers_all pah
1850: where pah.auction_header_id = l_auction_header_id;
1851:
1852: select pon_auction_pkg.get_message_suffix(doc.internal_name)
1853: into l_message_suffix

Line 1854: from pon_auction_headers_all pah,

1850: where pah.auction_header_id = l_auction_header_id;
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

Line 2006: from pon_auction_headers_all pah,

2002: where pai.batch_id = p_batch_id;
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