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_EVAL_TEAM_UTIL_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 399: FROM pon_auction_headers_all pah,

395: SELECT pah.document_number,
396: pah.auction_title,
397: hz.party_name preparer_tp_name,
398: pad.message_suffix
399: FROM pon_auction_headers_all pah,
400: pon_auc_doctypes pad,
401: hz_parties hz
402: WHERE pah.auction_header_id = p_auction_header_id
403: AND pad.doctype_id = pah.doctype_id

Line 407: l_doc_number pon_auction_headers_all.document_number%TYPE;

403: AND pad.doctype_id = pah.doctype_id
404: AND hz.party_id = pah.trading_partner_id;
405:
406: l_language_code VARCHAR2(3);
407: l_doc_number pon_auction_headers_all.document_number%TYPE;
408: l_auction_title pon_auction_headers_all.auction_title%TYPE;
409: l_preparer_tp_name hz_parties.party_name%TYPE;
410: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;
411: l_doc_type VARCHAR2(50);

Line 408: l_auction_title pon_auction_headers_all.auction_title%TYPE;

404: AND hz.party_id = pah.trading_partner_id;
405:
406: l_language_code VARCHAR2(3);
407: l_doc_number pon_auction_headers_all.document_number%TYPE;
408: l_auction_title pon_auction_headers_all.auction_title%TYPE;
409: l_preparer_tp_name hz_parties.party_name%TYPE;
410: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;
411: l_doc_type VARCHAR2(50);
412: l_member_user_name fnd_user.user_name%TYPE;

Line 651: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;

647:
648: l_itemtype VARCHAR2(8);
649: l_itemkey VARCHAR2(240);
650:
651: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
652: l_member_user_id fnd_user.user_id%TYPE;
653: l_doc_type VARCHAR2(50);
654: l_doc_number pon_auction_headers_all.document_number%TYPE;
655: l_neg_summary_url VARCHAR2(2000);

Line 654: l_doc_number pon_auction_headers_all.document_number%TYPE;

650:
651: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
652: l_member_user_id fnd_user.user_id%TYPE;
653: l_doc_type VARCHAR2(50);
654: l_doc_number pon_auction_headers_all.document_number%TYPE;
655: l_neg_summary_url VARCHAR2(2000);
656: l_notification_id NUMBER;
657: l_has_full_access VARCHAR2(1);
658:

Line 910: pon_auction_headers_all pah,

906: pah.auction_title,
907: hz.party_name preparer_tp_name,
908: pad.message_suffix
909: FROM pon_bid_headers pbh,
910: pon_auction_headers_all pah,
911: pon_auc_doctypes pad,
912: hz_parties hz
913: WHERE pbh.bid_number = p_bid_number
914: AND pah.auction_header_id = pbh.auction_header_id

Line 959: l_doc_number pon_auction_headers_all.document_number%TYPE;

955: TYPE notify_tbl_type IS TABLE OF c_notify_scorer%ROWTYPE;
956:
957: l_notify_tbl notify_tbl_type;
958:
959: l_doc_number pon_auction_headers_all.document_number%TYPE;
960: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
961: l_auction_title pon_auction_headers_all.auction_title%TYPE;
962: l_preparer_tp_name hz_parties.party_name%TYPE;
963: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;

Line 960: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;

956:
957: l_notify_tbl notify_tbl_type;
958:
959: l_doc_number pon_auction_headers_all.document_number%TYPE;
960: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
961: l_auction_title pon_auction_headers_all.auction_title%TYPE;
962: l_preparer_tp_name hz_parties.party_name%TYPE;
963: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;
964: l_language_code VARCHAR2(3);

Line 961: l_auction_title pon_auction_headers_all.auction_title%TYPE;

957: l_notify_tbl notify_tbl_type;
958:
959: l_doc_number pon_auction_headers_all.document_number%TYPE;
960: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
961: l_auction_title pon_auction_headers_all.auction_title%TYPE;
962: l_preparer_tp_name hz_parties.party_name%TYPE;
963: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;
964: l_language_code VARCHAR2(3);
965: l_doc_type VARCHAR2(50);

Line 1120: l_doc_number pon_auction_headers_all.document_number%TYPE;

1116:
1117: l_team_member VARCHAR2(240);
1118: l_neg_summary_url VARCHAR2(2000);
1119: l_doc_type VARCHAR2(50);
1120: l_doc_number pon_auction_headers_all.document_number%TYPE;
1121: l_auction_title pon_auction_headers_all.auction_title%TYPE;
1122: l_scorer_user_name fnd_user.user_name%TYPE;
1123: l_notification_id NUMBER;
1124:

Line 1121: l_auction_title pon_auction_headers_all.auction_title%TYPE;

1117: l_team_member VARCHAR2(240);
1118: l_neg_summary_url VARCHAR2(2000);
1119: l_doc_type VARCHAR2(50);
1120: l_doc_number pon_auction_headers_all.document_number%TYPE;
1121: l_auction_title pon_auction_headers_all.auction_title%TYPE;
1122: l_scorer_user_name fnd_user.user_name%TYPE;
1123: l_notification_id NUMBER;
1124:
1125: l_language_code VARCHAR2(3);