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 262: from pon_bid_headers

258: null requested_supplier_name,
259: null requested_supplier_contact_id,
260: null requested_supp_contact_name,
261: null rs_contact_email
262: from pon_bid_headers
263: where x_isAmendment = 'Y' and
264: auction_header_id in (select auction_header_id
265: from pon_auction_headers_all
266: where auction_header_id_orig_amend = (select auction_header_id_orig_amend

Line 1110: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;

1106: x_bidder_contact_id NUMBER;
1107: x_timezone_disp VARCHAR2(240);
1108: x_bid VARCHAR2(10);
1109: x_bid_caps VARCHAR2(10);
1110: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
1111: x_view_quote_url_supplier VARCHAR2(2000);
1112: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
1113: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1114: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

Line 1114: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

1110: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
1111: x_view_quote_url_supplier VARCHAR2(2000);
1112: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
1113: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1114: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
1115: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
1116: x_preview_date DATE;
1117: x_preview_date_in_tz DATE;
1118: x_timezone1_disp VARCHAR2(240);

Line 1115: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;

1111: x_view_quote_url_supplier VARCHAR2(2000);
1112: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
1113: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1114: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
1115: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
1116: x_preview_date DATE;
1117: x_preview_date_in_tz DATE;
1118: x_timezone1_disp VARCHAR2(240);
1119: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

Line 1122: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;

1118: x_timezone1_disp VARCHAR2(240);
1119: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
1120: x_staggered_closing_interval NUMBER;
1121: x_staggered_close_note VARCHAR2(1000);
1122: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;
1123:
1124:
1125:
1126: BEGIN

Line 1340: from pon_bid_headers

1336: x_progress VARCHAR2(3);
1337:
1338: CURSOR bidder_list IS
1339: select trading_partner_contact_name
1340: from pon_bid_headers
1341: where auction_header_id = x_auction_header_id;
1342:
1343: BEGIN
1344:

Line 2083: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

2079:
2080: x_newendtime1 VARCHAR2(80);
2081: x_newstarttime1 VARCHAR2(80);
2082: p_view_quote_url_supplier VARCHAR2(2000);
2083: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2084: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2085: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
2086: x_preview_date DATE;
2087: x_preview_date_in_tz DATE;

Line 2084: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;

2080: x_newendtime1 VARCHAR2(80);
2081: x_newstarttime1 VARCHAR2(80);
2082: p_view_quote_url_supplier VARCHAR2(2000);
2083: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2084: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2085: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
2086: x_preview_date DATE;
2087: x_preview_date_in_tz DATE;
2088: x_timezone1_disp VARCHAR2(240);

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

2100: nvl(substr(bhz.attribute2,0,3),''),
2101: bhz.person_first_name || ' ' || bhz.person_last_name,
2102: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2103: ah.view_by_date, ah.staggered_closing_interval
2104: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2105: where bhz.party_id = bih.trading_partner_contact_id
2106: and bih.bid_number = p_bid_id
2107: and ah.auction_header_id = bih.auction_header_id
2108: and ah.doctype_id = dt.doctype_id;

Line 2149: from pon_bid_headers

2145: --
2146:
2147: select trading_partner_contact_id
2148: into x_bidder_contact_id
2149: from pon_bid_headers
2150: where bid_number = p_bid_id ;
2151:
2152: x_oex_timezone := Get_Oex_Time_Zone;
2153:

Line 2651: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;

2647: x_bidder_contact_id NUMBER;
2648: x_timezone_disp VARCHAR2(240);
2649: x_bid VARCHAR2(10);
2650: x_bid_caps VARCHAR2(10);
2651: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
2652: x_view_quote_url_supplier VARCHAR2(2000);
2653: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2654: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2655: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

Line 2655: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;

2651: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
2652: x_view_quote_url_supplier VARCHAR2(2000);
2653: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2654: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2655: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2656: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2657: x_preview_date DATE;
2658: x_preview_date_in_tz DATE;
2659: x_timezone1_disp VARCHAR2(240);

Line 2656: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;

2652: x_view_quote_url_supplier VARCHAR2(2000);
2653: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2654: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2655: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2656: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2657: x_preview_date DATE;
2658: x_preview_date_in_tz DATE;
2659: x_timezone1_disp VARCHAR2(240);
2660: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

Line 2663: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;

2659: x_timezone1_disp VARCHAR2(240);
2660: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
2661: x_staggered_closing_interval NUMBER;
2662: x_staggered_close_note VARCHAR2(1000);
2663: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;
2664:
2665: l_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE :='';
2666:
2667:

Line 2665: l_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE :='';

2661: x_staggered_closing_interval NUMBER;
2662: x_staggered_close_note VARCHAR2(1000);
2663: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;
2664:
2665: l_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE :='';
2666:
2667:
2668: CURSOR c1_bid_info(x_lang VARCHAR2) IS
2669: select bid_type, nvl(ah.auction_round_number, 1) auction_round_number, bih.note_to_supplier,

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

2670: ah.document_number, dt.doctype_group_name, dt.doctype_id,
2671: bhz.person_first_name || ' ' || bhz.person_last_name, ah.trading_partner_contact_name,
2672: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2673: view_by_date, nvl(ah.has_items_flag, 'Y'), ah.staggered_closing_interval,bih.award_status
2674: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2675: where bhz.party_id = bih.trading_partner_contact_id
2676: and bih.bid_number = p_bid_id
2677: and ah.auction_header_id = bih.auction_header_id
2678: and ah.doctype_id = dt.doctype_id;

Line 2958: from pon_bid_headers

2954:
2955:
2956: select trading_partner_contact_id
2957: into x_bidder_contact_id
2958: from pon_bid_headers
2959: where bid_number = p_bid_id;
2960:
2961: begin
2962: x_timezone := Get_Time_Zone(x_bidder_contact_id);

Line 3657: pon_bid_headers pbh

3653: pbh.trading_partner_name party_name,
3654: DECODE(pbh.vendor_site_code, '-1', NULL, pbh.vendor_site_code) vendor_site_code,
3655: pbh.vendor_site_id
3656: FROM wf_local_user_roles wlur,
3657: pon_bid_headers pbh
3658: WHERE wlur.role_name = x_role_name
3659: AND x_doc_header_id_prev_round = pbh.auction_header_id
3660: AND wlur.user_name = pbh.trading_partner_contact_name(+);
3661:

Line 6671: from pon_bid_headers

6667: where trading_partner_contact_id = x_trading_partner_contact_id
6668: and auction_header_id = x_doc_number
6669: union
6670: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6671: from pon_bid_headers
6672: where trading_partner_contact_id = x_trading_partner_contact_id
6673: and auction_header_id = x_doc_number;
6674:
6675:

Line 9186: FROM pon_bid_headers

9182: FOR bidder IN bidders LOOP --{
9183:
9184: SELECT COUNT(bid_number)
9185: INTO x_bids_by_company
9186: FROM pon_bid_headers
9187: WHERE auction_header_id=x_doc_number
9188: AND trading_partner_id=bidder.trading_partner_id;
9189:
9190: x_total_participations :=x_bids_by_company;

Line 11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;

11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
11381: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11382: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
11383: l_timezone_disp VARCHAR2(240);

Line 11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;

11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
11381: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11382: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
11383: l_timezone_disp VARCHAR2(240);
11384: l_bid_contact_dp_name VARCHAR2(350);

Line 11446: pon_bid_headers pbh,

11442: l_bidder_tpc_id,
11443: l_auction_header_id
11444: from pon_auction_headers_all auh,
11445: pon_auc_doctypes pad,
11446: pon_bid_headers pbh,
11447: fnd_user fu
11448: where pbh.bid_number = p_bid_number
11449: AND pad.doctype_id = auh.doctype_id
11450: AND auh.auction_header_id = pbh.auction_header_id

Line 11497: pon_bid_headers pbh,

11493: l_bidder_tpc_id,
11494: l_auction_header_id
11495: from pon_auction_headers_all auh,
11496: pon_auc_doctypes pad,
11497: pon_bid_headers pbh,
11498: fnd_user fu
11499: where pbh.bid_number = p_bid_number
11500: AND pad.doctype_id = auh.doctype_id
11501: AND auh.auction_header_id = pbh.auction_header_id

Line 11920: FROM PON_BID_HEADERS PBH,

11916: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11917: HZ1.PERSON_LAST_NAME LAST_NAME,
11918: HZ.PARTY_ID COMPANY_ID,
11919: HZ.PARTY_NAME COMPANY_NAME
11920: FROM PON_BID_HEADERS PBH,
11921: HZ_PARTIES HZ,
11922: HZ_PARTIES HZ1
11923: WHERE PBH.AUCTION_HEADER_ID = p_auction_header_id
11924: AND HZ.PARTY_ID=PBH.TRADING_PARTNER_ID

Line 13385: pon_bid_headers b

13381: INTO
13382: v_temp
13383: FROM
13384: pon_auction_headers_all a,
13385: pon_bid_headers b
13386: WHERE
13387: a.auction_header_id = b.auction_header_id
13388: and a.auction_header_id = p_auction_header_id
13389: and b.trading_partner_id = p_user_trading_partner_id

Line 13422: pon_bid_headers ppbh

13418: DECODE(
13419: (SELECT
13420: count(distinct vendor_site_id)
13421: FROM
13422: pon_bid_headers ppbh
13423: WHERE
13424: ppbh.auction_header_id = p_auction_header_id
13425: and ppbh.trading_partner_id = p_user_trading_partner_id
13426: and ppbh.bid_status = 'ACTIVE'

Line 13812: FROM pon_bid_headers

13808: AS
13809: -- get list of bidders, along with the shortlist flags.
13810: CURSOR bidder_list IS
13811: SELECT bid_number, trading_partner_contact_name, nvl(shortlist_flag, 'Y') as shortlist_flag
13812: FROM pon_bid_headers
13813: WHERE auction_header_id = p_auction_header_id
13814: AND bid_status = 'ACTIVE'
13815: AND nvl(evaluation_flag, 'N') = 'N';
13816:

Line 13820: l_bidder_name pon_bid_headers.trading_partner_contact_name%TYPE;

13816:
13817: -- other local variables
13818: x_item_key VARCHAR2(15); -- workflow item key
13819: x_item_type VARCHAR2(8) := 'PONTEVAL'; -- workflow item type
13820: l_bidder_name pon_bid_headers.trading_partner_contact_name%TYPE;
13821: l_auction_title pon_auction_headers_all.auction_title%TYPE;
13822: l_document_number pon_auction_headers_all.document_number%TYPE;
13823: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
13824:

Line 15342: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;

15338: x_timezone1_disp VARCHAR2(240);
15339: x_timezone_disp VARCHAR2(240);
15340: x_bid_id NUMBER;
15341: x_bid_caps VARCHAR2(10);
15342: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
15343: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
15344: x_number_awarded NUMBER;
15345: x_number_rejected NUMBER;
15346: x_preview_date_format VARCHAR2(80);

Line 15560: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;

15556: x_timezone1_disp VARCHAR2(240);
15557: x_timezone_disp VARCHAR2(240);
15558: x_bid_id NUMBER;
15559: x_bid_caps VARCHAR2(10);
15560: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
15561: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
15562: x_preview_date_format VARCHAR2(80);
15563: x_auction_start_date_format VARCHAR2(80);
15564: x_auction_end_date_format VARCHAR2(80);

Line 15769: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;

15765: x_timezone1_disp VARCHAR2(240);
15766: x_timezone_disp VARCHAR2(240);
15767: x_bid_id NUMBER;
15768: x_bid_caps VARCHAR2(10);
15769: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
15770: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
15771: x_event_title varchar2(80);
15772: x_number_awarded NUMBER;
15773: x_number_rejected NUMBER;

Line 16000: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;

15996: x_timezone1_disp VARCHAR2(240);
15997: x_timezone_disp VARCHAR2(240);
15998: x_bid_id NUMBER;
15999: x_bid_caps VARCHAR2(10);
16000: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
16001: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
16002: x_event_title varchar2(80);
16003: x_preview_date_format VARCHAR2(80);
16004: x_auction_start_date_format VARCHAR2(80);

Line 17515: l_bid_number pon_bid_headers.bid_number%TYPE;

17511: PROCEDURE SYNC_BID_HEADER_ATTACHMENTS(p_auction_header_id IN NUMBER)
17512: AS
17513:
17514: l_intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%TYPE;
17515: l_bid_number pon_bid_headers.bid_number%TYPE;
17516: l_vendor_id pon_bid_headers.vendor_id%TYPE;
17517:
17518: CURSOR get_intgr_hdr_attach_flag IS
17519: SELECT intgr_hdr_attach_flag

Line 17516: l_vendor_id pon_bid_headers.vendor_id%TYPE;

17512: AS
17513:
17514: l_intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%TYPE;
17515: l_bid_number pon_bid_headers.bid_number%TYPE;
17516: l_vendor_id pon_bid_headers.vendor_id%TYPE;
17517:
17518: CURSOR get_intgr_hdr_attach_flag IS
17519: SELECT intgr_hdr_attach_flag
17520: FROM pon_auction_headers_all

Line 17525: FROM pon_bid_headers

17521: WHERE auction_header_id = p_auction_header_id;
17522:
17523: CURSOR bids_cursor IS
17524: SELECT bid_number, vendor_id
17525: FROM pon_bid_headers
17526: WHERE auction_header_id = p_auction_header_id
17527: AND bid_status = 'ACTIVE'
17528: AND vendor_id <> -1;
17529:

Line 17541: X_from_entity_name => 'PON_BID_HEADERS',

17537:
17538: FOR bid IN bids_cursor LOOP
17539:
17540: fnd_attached_documents2_pkg.copy_attachments(
17541: X_from_entity_name => 'PON_BID_HEADERS',
17542: X_from_pk1_value => p_auction_header_id,
17543: X_from_pk2_value => bid.bid_number,
17544: X_to_entity_name => 'PO_VENDORS',
17545: X_to_pk1_value => bid.vendor_id,