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_PKG

Line 39: select pon_auction_pkg.get_message_suffix(doc.internal_name)

35: into l_auction_header_id
36: from pon_auc_price_elements_int pape
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

Line 503: select pon_auction_pkg.get_message_suffix(doc.internal_name)

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
505: from pon_auction_headers_all pah,
506: pon_auc_doctypes doc
507: where pah.auction_header_id = l_auction_header_id

Line 659: select pon_auction_pkg.get_message_suffix(doc.internal_name)

655: into l_auction_header_id
656: from pon_auc_attributes_interface pai
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

Line 820: decode(l_group_pref_name,'LINE_ATTR_DEFAULT_GROUP',pon_auction_pkg.getMessage('PON_AUCTS_BID_RESPONSE',l_message_suffix),pon_auction_pkg.getMessage('PON_AUCTS_TYPE')),

816: (
817: selected_batch_id,
818: selected_interface_line_id,
819: 'PON_AUC_ATTRIBUTES_INTERFACE',
820: decode(l_group_pref_name,'LINE_ATTR_DEFAULT_GROUP',pon_auction_pkg.getMessage('PON_AUCTS_BID_RESPONSE',l_message_suffix),pon_auction_pkg.getMessage('PON_AUCTS_TYPE')),
821: 'PON_CAT_INVALID_VALUE',
822: selected_response_type_name
823: )
824:

Line 951: pon_auction_pkg.getMessage('PON_AUCTS_ATTR_TARGET',l_message_suffix),

947: (
948: selected_batch_id,
949: selected_interface_line_id,
950: 'PON_AUC_ATTRIBUTES_INTERFACE',
951: pon_auction_pkg.getMessage('PON_AUCTS_ATTR_TARGET',l_message_suffix),
952: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
953: 'PON_AUCTS_ATTR_DISPLAY_TARGET', 'PON_AUCTS_REQ_DISPLAY_TARGET'),
954: selected_value
955: )

Line 1357: SELECT pon_auction_pkg.get_message_suffix(doc.internal_name)

1353: INTO l_auction_header_id
1354: FROM pon_auc_price_differ_int papd
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;