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_AUCTION_PKG dependencies on PON_BID_HEADERS

Line 245: from pon_bid_headers

241: null requested_supplier_name,
242: null requested_supplier_contact_id,
243: null requested_supp_contact_name,
244: null rs_contact_email
245: from pon_bid_headers
246: where x_isAmendment = 'Y' and
247: auction_header_id in (select auction_header_id
248: from pon_auction_headers_all
249: where auction_header_id_orig_amend = (select auction_header_id_orig_amend

Line 897: from pon_bid_headers

893: x_progress VARCHAR2(3);
894:
895: CURSOR bidder_list IS
896: select trading_partner_contact_name
897: from pon_bid_headers
898: where auction_header_id = x_auction_header_id;
899:
900: BEGIN
901:

Line 1621: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

1617:
1618: x_newendtime1 VARCHAR2(80);
1619: x_newstarttime1 VARCHAR2(80);
1620: p_view_quote_url_supplier VARCHAR2(2000);
1621: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
1622: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
1623: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
1624: x_preview_date DATE;
1625: x_preview_date_in_tz DATE;

Line 1622: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;

1618: x_newendtime1 VARCHAR2(80);
1619: x_newstarttime1 VARCHAR2(80);
1620: p_view_quote_url_supplier VARCHAR2(2000);
1621: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
1622: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
1623: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
1624: x_preview_date DATE;
1625: x_preview_date_in_tz DATE;
1626: x_timezone1_disp VARCHAR2(240);

Line 1642: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

1638: nvl(substr(bhz.attribute2,0,3),''),
1639: bhz.person_first_name || ' ' || bhz.person_last_name,
1640: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
1641: ah.view_by_date, ah.staggered_closing_interval
1642: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
1643: where bhz.party_id = bih.trading_partner_contact_id
1644: and bih.bid_number = p_bid_id
1645: and ah.auction_header_id = bih.auction_header_id
1646: and ah.doctype_id = dt.doctype_id;

Line 1687: from pon_bid_headers

1683: --
1684:
1685: select trading_partner_contact_id
1686: into x_bidder_contact_id
1687: from pon_bid_headers
1688: where bid_number = p_bid_id ;
1689:
1690: x_oex_timezone := Get_Oex_Time_Zone;
1691:

Line 2182: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;

2178: x_bidder_contact_id NUMBER;
2179: x_timezone_disp VARCHAR2(240);
2180: x_bid VARCHAR2(10);
2181: x_bid_caps VARCHAR2(10);
2182: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
2183: x_view_quote_url_supplier VARCHAR2(2000);
2184: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2185: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2186: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

Line 2186: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

2182: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
2183: x_view_quote_url_supplier VARCHAR2(2000);
2184: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2185: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2186: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2187: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2188: x_preview_date DATE;
2189: x_preview_date_in_tz DATE;
2190: x_timezone1_disp VARCHAR2(240);

Line 2187: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;

2183: x_view_quote_url_supplier VARCHAR2(2000);
2184: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2185: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2186: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2187: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2188: x_preview_date DATE;
2189: x_preview_date_in_tz DATE;
2190: x_timezone1_disp VARCHAR2(240);
2191: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

Line 2194: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;

2190: x_timezone1_disp VARCHAR2(240);
2191: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
2192: x_staggered_closing_interval NUMBER;
2193: x_staggered_close_note VARCHAR2(1000);
2194: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;
2195:
2196: CURSOR c1_bid_info(x_lang VARCHAR2) IS
2197: select bid_type, nvl(ah.auction_round_number, 1) auction_round_number, bih.note_to_supplier,
2198: ah.document_number, dt.doctype_group_name, dt.doctype_id,

Line 2202: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

2198: ah.document_number, dt.doctype_group_name, dt.doctype_id,
2199: bhz.person_first_name || ' ' || bhz.person_last_name, ah.trading_partner_contact_name,
2200: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2201: view_by_date, nvl(ah.has_items_flag, 'Y'), ah.staggered_closing_interval,bih.award_status
2202: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2203: where bhz.party_id = bih.trading_partner_contact_id
2204: and bih.bid_number = p_bid_id
2205: and ah.auction_header_id = bih.auction_header_id
2206: and ah.doctype_id = dt.doctype_id;

Line 2474: from pon_bid_headers

2470:
2471:
2472: select trading_partner_contact_id
2473: into x_bidder_contact_id
2474: from pon_bid_headers
2475: where bid_number = p_bid_id;
2476:
2477: begin
2478: x_timezone := Get_Time_Zone(x_bidder_contact_id);

Line 3147: pon_bid_headers pbh

3143: pbh.trading_partner_name party_name,
3144: DECODE(pbh.vendor_site_code, '-1', NULL, pbh.vendor_site_code) vendor_site_code,
3145: pbh.vendor_site_id
3146: FROM wf_local_user_roles wlur,
3147: pon_bid_headers pbh
3148: WHERE wlur.role_name = x_role_name
3149: AND x_doc_header_id_prev_round = pbh.auction_header_id
3150: AND wlur.user_name = pbh.trading_partner_contact_name(+);
3151:

Line 6075: from pon_bid_headers

6071: where trading_partner_contact_id = x_trading_partner_contact_id
6072: and auction_header_id = x_doc_number
6073: union
6074: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6075: from pon_bid_headers
6076: where trading_partner_contact_id = x_trading_partner_contact_id
6077: and auction_header_id = x_doc_number;
6078:
6079:

Line 8474: FROM pon_bid_headers

8470: FOR bidder IN bidders LOOP --{
8471:
8472: SELECT COUNT(bid_number)
8473: INTO x_bids_by_company
8474: FROM pon_bid_headers
8475: WHERE auction_header_id=x_doc_number
8476: AND trading_partner_id=bidder.trading_partner_id;
8477:
8478: x_total_participations :=x_bids_by_company;

Line 10543: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;

10539: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10540: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
10541: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
10542: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
10543: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
10544: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
10545: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10546: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
10547: l_timezone_disp VARCHAR2(240);

Line 10544: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;

10540: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
10541: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
10542: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
10543: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
10544: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
10545: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10546: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
10547: l_timezone_disp VARCHAR2(240);
10548: l_bid_contact_dp_name VARCHAR2(350);

Line 10610: pon_bid_headers pbh,

10606: l_bidder_tpc_id,
10607: l_auction_header_id
10608: from pon_auction_headers_all auh,
10609: pon_auc_doctypes pad,
10610: pon_bid_headers pbh,
10611: fnd_user fu
10612: where pbh.bid_number = p_bid_number
10613: AND pad.doctype_id = auh.doctype_id
10614: AND auh.auction_header_id = pbh.auction_header_id

Line 10661: pon_bid_headers pbh,

10657: l_bidder_tpc_id,
10658: l_auction_header_id
10659: from pon_auction_headers_all auh,
10660: pon_auc_doctypes pad,
10661: pon_bid_headers pbh,
10662: fnd_user fu
10663: where pbh.bid_number = p_bid_number
10664: AND pad.doctype_id = auh.doctype_id
10665: AND auh.auction_header_id = pbh.auction_header_id

Line 11084: FROM PON_BID_HEADERS PBH,

11080: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11081: HZ1.PERSON_LAST_NAME LAST_NAME,
11082: HZ.PARTY_ID COMPANY_ID,
11083: HZ.PARTY_NAME COMPANY_NAME
11084: FROM PON_BID_HEADERS PBH,
11085: HZ_PARTIES HZ,
11086: HZ_PARTIES HZ1
11087: WHERE PBH.AUCTION_HEADER_ID = p_auction_header_id
11088: AND HZ.PARTY_ID=PBH.TRADING_PARTNER_ID

Line 12529: pon_bid_headers b

12525: INTO
12526: v_temp
12527: FROM
12528: pon_auction_headers_all a,
12529: pon_bid_headers b
12530: WHERE
12531: a.auction_header_id = b.auction_header_id
12532: and a.auction_header_id = p_auction_header_id
12533: and b.trading_partner_id = p_user_trading_partner_id

Line 12566: pon_bid_headers ppbh

12562: DECODE(
12563: (SELECT
12564: count(distinct vendor_site_id)
12565: FROM
12566: pon_bid_headers ppbh
12567: WHERE
12568: ppbh.auction_header_id = p_auction_header_id
12569: and ppbh.trading_partner_id = p_user_trading_partner_id
12570: and ppbh.bid_status = 'ACTIVE'

Line 12954: FROM pon_bid_headers

12950: AS
12951: -- get list of bidders, along with the shortlist flags.
12952: CURSOR bidder_list IS
12953: SELECT bid_number, trading_partner_contact_name, nvl(shortlist_flag, 'Y') as shortlist_flag
12954: FROM pon_bid_headers
12955: WHERE auction_header_id = p_auction_header_id
12956: AND bid_status = 'ACTIVE';
12957:
12958: -- other local variables

Line 12961: l_bidder_name pon_bid_headers.trading_partner_contact_name%TYPE;

12957:
12958: -- other local variables
12959: x_item_key VARCHAR2(15); -- workflow item key
12960: x_item_type VARCHAR2(8) := 'PONTEVAL'; -- workflow item type
12961: l_bidder_name pon_bid_headers.trading_partner_contact_name%TYPE;
12962: l_auction_title pon_auction_headers_all.auction_title%TYPE;
12963: l_document_number pon_auction_headers_all.document_number%TYPE;
12964: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
12965: