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_BIDDING_PARTIES

Line 243: from pon_bidding_parties pbp,

239: pbp.requested_supplier_contact_id,
240: pbp.requested_supp_contact_name,
241: pcr.email_address rs_contact_email
242: -- lxchen
243: from pon_bidding_parties pbp,
244: pos_contact_requests pcr
245: where pbp.auction_header_id = x_auction_header_id and
246: pbp.requested_supplier_contact_id = pcr.contact_request_id (+)
247: union

Line 272: FROM pon_bidding_parties

268: where auction_header_id = x_auction_header_id)) and
269: bid_status in ('ACTIVE', 'RESUBMISSION', 'DISQUALIFIED', 'DRAFT') and
270: trading_partner_contact_id NOT IN
271: (SELECT nvl(trading_partner_contact_id, -1)
272: FROM pon_bidding_parties
273: WHERE auction_header_id = x_auction_header_id);
274:
275:
276: CURSOR c1_auction_type IS

Line 921: from pon_bidding_parties b

917: --choli for SUPPLIER_EXEMPTED_INFO
918: BEGIN
919: select exempt_flag
920: into x_exempt_flag
921: from pon_bidding_parties b
922: where auction_header_id = x_auction_header_id
923: and trading_partner_id = bidder.trading_partner_id
924: and rownum = 1;
925: EXCEPTION

Line 964: SELECT sequence INTO x_supplier_sequence FROM pon_bidding_parties

960: ELSIF(x_new_amend_flag = 'Y') THEN
961: x_refund_supplier_msg := getMessage('PON_EMD_REFUND_SUP_NEW_AMEND');
962: END IF;
963:
964: SELECT sequence INTO x_supplier_sequence FROM pon_bidding_parties
965: WHERE auction_header_id = (SELECT Decode(Nvl(auction_header_id_prev_round,0),0,Nvl(auction_header_id_prev_amend,0),auction_header_id_prev_round)
966: FROM pon_auction_headers_all
967: WHERE auction_header_id = x_auction_header_id)
968: --x_auction_header_id_orig_amend

Line 1055: update pon_bidding_parties

1051:
1052: wf_engine.StartProcess(itemtype => x_itemtype,
1053: itemkey => x_itemkey );
1054:
1055: update pon_bidding_parties
1056: set wf_item_key = x_itemkey
1057: where auction_header_id = x_auction_header_id and
1058: ((trading_partner_id = bidder.trading_partner_id and
1059: vendor_site_id = bidder.vendor_site_id) or

Line 1570: select 'Y' into x_new_bidders_flag from pon_bidding_parties

1566: avalue => x_bid_list);
1567:
1568: IF(x_bid_list = 'Y') THEN
1569: BEGIN
1570: select 'Y' into x_new_bidders_flag from pon_bidding_parties
1571: where auction_header_id = p_auction_header_id
1572: and trading_partner_id is null group by auction_header_id;
1573: EXCEPTION
1574: WHEN NO_DATA_FOUND THEN

Line 3268: from pon_bidding_parties pbp,

3264: x_current_activity varchar2(30);
3265:
3266: CURSOR bidder_list_wf_keys IS
3267: select pbp.wf_item_key wf_item_key, act.activity_label activity_label
3268: from pon_bidding_parties pbp,
3269: wf_item_activity_statuses_v act
3270: where pbp.auction_header_id = p_prev_doc_header_id and
3271: act.item_type = x_itemtype and
3272: act.item_key = pbp.wf_item_key and

Line 3630: FROM pon_bidding_parties pbp,

3626: trading_partner_id party_id,
3627: trading_partner_name party_name,
3628: DECODE(vendor_site_code, '-1', NULL, vendor_site_code) vendor_site_code,
3629: vendor_site_id
3630: FROM pon_bidding_parties pbp,
3631: fnd_user fu
3632: WHERE auction_header_id = x_doc_header_id_prev_round
3633: AND fu.person_party_id = pbp.trading_partner_contact_id
3634: AND nvl(fu.end_date, sysdate+1) > sysdate

Line 3642: FROM pon_bidding_parties pbp,

3638: pbp.trading_partner_id party_id,
3639: pbp.trading_partner_name party_name,
3640: DECODE(pbp.vendor_site_code, '-1', NULL, pbp.vendor_site_code) vendor_site_code,
3641: pbp.vendor_site_id
3642: FROM pon_bidding_parties pbp,
3643: wf_local_user_roles wlur
3644: WHERE pbp.auction_header_id = x_doc_header_id_prev_round
3645: AND wlur.role_name = x_role_name
3646: AND wlur.user_name = pbp.wf_user_name

Line 3664: from pon_bidding_parties pbp

3660: AND wlur.user_name = pbh.trading_partner_contact_name(+);
3661:
3662: CURSOR c2_inv_list (x_doc_header_id NUMBER) IS
3663: select trading_partner_id,vendor_site_id
3664: from pon_bidding_parties pbp
3665: where auction_header_id = x_doc_header_id;
3666:
3667: x_itemtype VARCHAR2(20) := 'PONPBLSH';
3668: x_itemkey VARCHAR2(60);

Line 3712: x_add_contact_email PON_BIDDING_PARTIES.ADDITIONAL_CONTACT_EMAIL%TYPE;

3708: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3709: x_startdate DATE;
3710: x_enddate DATE;
3711: x_auctioneer_user_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
3712: x_add_contact_email PON_BIDDING_PARTIES.ADDITIONAL_CONTACT_EMAIL%TYPE;
3713: x_preview_date DATE;
3714: x_preview_date_notspec VARCHAR2(240);
3715: x_timezone1_disp VARCHAR2(240);
3716: x_newstarttime DATE;

Line 4097: SELECT sequence INTO x_supplier_sequence FROM pon_bidding_parties

4093: */
4094: BEGIN
4095: x_refund_supplier_msg := getMessage('PON_EMD_REFUND_N_RND_NOINV');
4096:
4097: SELECT sequence INTO x_supplier_sequence FROM pon_bidding_parties
4098: WHERE auction_header_id = x_doc_header_id_prev_round
4099: AND TRADING_PARTNER_ID = x_prev_trading_partner_id
4100: AND vendor_site_id = x_prev_supplier_site_id;
4101:

Line 4353: from pon_bidding_parties pbp, pos_contact_requests pcr

4349: pbp.vendor_site_id,
4350: pbp.requested_supplier_id,
4351: pbp.requested_supplier_contact_id,
4352: pcr.email_address rs_contact_email
4353: from pon_bidding_parties pbp, pos_contact_requests pcr
4354: where pbp.auction_header_id = x_auction_header_id
4355: and pbp.requested_supplier_contact_id = pcr.contact_request_id (+);
4356:
4357: CURSOR c_user_name IS

Line 4470: -- However, if the row in pon_bidding_parties does not have a contact,

4466: -- Bug 3824928: If trading partner contact is not there then prevent
4467: -- this SELECT from erroring out
4468: -- The steps below try to set up the user for the additional contact
4469: -- email so that they have the same settings as the existing contact.
4470: -- However, if the row in pon_bidding_parties does not have a contact,
4471: -- then the additional contact user inherits the settings of the
4472: -- auctioneer
4473:
4474: IF bidder.trading_partner_contact_id IS NOT NULL --{

Line 4533: UPDATE pon_bidding_parties set

4529: null,
4530: 'ACTIVE',
4531: null);
4532: x_progress := '023';
4533: UPDATE pon_bidding_parties set
4534: wf_user_name = x_user_name
4535: WHERE auction_header_id = x_auction_header_id
4536: AND trading_partner_id = bidder.trading_partner_id
4537: AND vendor_site_id = bidder.vendor_site_id;

Line 4580: -- record wf_user_name in pon_bidding_parties

4576: 'ACTIVE',
4577: null);
4578: x_progress := '023_REQ';
4579:
4580: -- record wf_user_name in pon_bidding_parties
4581: UPDATE pon_bidding_parties
4582: set wf_user_name = x_user_name
4583: WHERE auction_header_id = x_auction_header_id
4584: AND requested_supplier_id = bidder.requested_supplier_id;

Line 4581: UPDATE pon_bidding_parties

4577: null);
4578: x_progress := '023_REQ';
4579:
4580: -- record wf_user_name in pon_bidding_parties
4581: UPDATE pon_bidding_parties
4582: set wf_user_name = x_user_name
4583: WHERE auction_header_id = x_auction_header_id
4584: AND requested_supplier_id = bidder.requested_supplier_id;
4585:

Line 4895: from pon_bidding_parties

4891: x_progress := '020';
4892:
4893: begin
4894: select 'Y' into x_flag
4895: from pon_bidding_parties
4896: where auction_header_id = x_auction_header_id
4897: and trading_partner_contact_id = x_bidder_contact_id
4898: group by trading_partner_contact_id;
4899: exception when NO_DATA_FOUND then

Line 6633: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

6629: IS
6630:
6631: x_doc_number number;
6632: x_profile_user VARCHAR2(240) := '';
6633: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
6634: x_vendor_site_code PON_BIDDING_PARTIES.VENDOR_SITE_CODE%TYPE;
6635: x_vendor_site_id NUMBER;
6636: x_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
6637: x_wf_role_name varchar2(100) := '';

Line 6634: x_vendor_site_code PON_BIDDING_PARTIES.VENDOR_SITE_CODE%TYPE;

6630:
6631: x_doc_number number;
6632: x_profile_user VARCHAR2(240) := '';
6633: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
6634: x_vendor_site_code PON_BIDDING_PARTIES.VENDOR_SITE_CODE%TYPE;
6635: x_vendor_site_id NUMBER;
6636: x_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
6637: x_wf_role_name varchar2(100) := '';
6638: x_language_code varchar2(30);

Line 6661: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties

6657: select wfu.user_name user_name, person_party_id
6658: from wf_user_roles wfu, fnd_user fnd
6659: where role_name = x_wf_role_name
6660: and fnd.user_name (+) = wfu.user_name
6661: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6662: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);
6663:
6664: CURSOR bidders_info IS
6665: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id

Line 6666: from pon_bidding_parties

6662: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);
6663:
6664: CURSOR bidders_info IS
6665: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6666: from pon_bidding_parties
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

Line 6809: from pon_bidding_parties

6805: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_profile_user,x_language_code);
6806:
6807: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6808: into x_bidder_tp_name, x_vendor_site_code, x_vendor_site_id
6809: from pon_bidding_parties
6810: where wf_user_name = bidder.user_name
6811: and auction_header_id = x_doc_number;
6812:
6813: -- Get the timezone for the user

Line 7231: from pon_bidding_parties pbp,

7227: pbp.requested_supplier_name,
7228: pbp.requested_supplier_contact_id,
7229: pbp.requested_supp_contact_name,
7230: pcr.email_address rs_contact_email
7231: from pon_bidding_parties pbp,
7232: pos_contact_requests pcr
7233: where auction_header_id = x_auction_header_id
7234: and pbp.requested_supplier_contact_id = pcr.contact_request_id(+)
7235: and wf_item_key IS NULL;

Line 7762: UPDATE pon_bidding_parties set

7758:
7759: -- Bug 3709564
7760: -- If this update is not performed here, it will error out
7761: -- in notify_bidder_list_reminder as wf_user_name will be null
7762: UPDATE pon_bidding_parties set
7763: wf_user_name = x_additional_user_name
7764: WHERE auction_header_id = x_auction_header_id
7765: AND trading_partner_id = bidder.trading_partner_id
7766: AND vendor_site_id = bidder.vendor_site_id;

Line 7823: UPDATE pon_bidding_parties SET

7819: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
7820: l_users);
7821: end if;
7822:
7823: UPDATE pon_bidding_parties SET
7824: wf_user_name = x_rs_user_name
7825: WHERE auction_header_id = x_auction_header_id
7826: AND (trading_partner_id = bidder.trading_partner_id
7827: or requested_supplier_id = bidder.requested_supplier_id)

Line 7864: update pon_bidding_parties

7860:
7861: -- Bug 3709564
7862: -- If this update is not performed here, wf_engine.abort_process call
7863: -- in notify_bidder_list_reminder will fail, as wf_item_key will be null
7864: update pon_bidding_parties
7865: set wf_item_key = t_itemkey
7866: where auction_header_id = x_auction_header_id and
7867: (trading_partner_id = bidder.trading_partner_id
7868: or requested_supplier_id = bidder.requested_supplier_Id) and

Line 7949: from pon_bidding_parties

7945: BEGIN
7946: begin
7947: select trading_partner_contact_id
7948: into x_user_id
7949: from pon_bidding_parties
7950: where auction_header_id = p_doc_id
7951: and wf_user_name = p_user_name;
7952:
7953: if x_user_id is null then -- it means the additional contact is not associated to any

Line 8380: UPDATE pon_bidding_parties

8376: x_now := SYSDATE;
8377:
8378: IF (x_closedate>x_now AND x_auction_status<>'CANCELLED' AND x_auction_status<>'DELETED') then
8379:
8380: UPDATE pon_bidding_parties
8381: SET supp_acknowledgement='Y',
8382: ack_note_to_auctioneer = x_note,
8383: ack_partner_contact_id = trading_partner_contact_id,
8384: acknowledgement_time = x_now

Line 8452: UPDATE pon_bidding_parties

8448:
8449: IF (x_closedate>x_now AND x_auction_status<>'CANCELLED' AND x_auction_status<>'DELETED') then
8450:
8451:
8452: UPDATE pon_bidding_parties
8453: SET supp_acknowledgement='N',
8454: ack_note_to_auctioneer = x_note,
8455: ack_partner_contact_id = trading_partner_contact_id,
8456: acknowledgement_time = x_now

Line 8977: from pon_bidding_parties b

8973: --choli for SUPPLIER_EXEMPTED_INFO
8974: BEGIN
8975: select exempt_flag
8976: into x_exempt_flag
8977: from pon_bidding_parties b
8978: where auction_header_id = x_auction_header_id
8979: and trading_partner_id = x_tp_id
8980: and rownum = 1;
8981: EXCEPTION

Line 9004: UPDATE pon_bidding_parties set

9000: itemkey => x_itemkey );
9001:
9002:
9003:
9004: UPDATE pon_bidding_parties set
9005: wf_item_key = x_itemkey
9006: WHERE trading_partner_id = x_tp_id
9007: AND auction_header_id = x_auction_header_id;
9008:

Line 9040: from pon_bidding_parties pbd,

9036: pbd.additional_contact_email,
9037: pbd.registration_id,
9038: pbd.trading_partner_contact_id, -- Bug 3824928 added
9039: pbd.vendor_site_id
9040: from pon_bidding_parties pbd,
9041: fnd_user fu
9042: WHERE pbd.trading_partner_contact_id=fu.person_party_id (+) AND -- Bug 3824928: added outer join
9043: nvl(fu.end_date, sysdate+1) > sysdate AND -- Added for TCA project
9044: pbd.auction_header_id=x_doc_number AND

Line 9537: -- For members, store item key in pon_bidding_parties

9533: -- partner contact id is not null
9534:
9535: IF bidder.trading_partner_contact_id IS NOT NULL THEN -- {
9536:
9537: -- For members, store item key in pon_bidding_parties
9538: -- End the previous waiting process
9539: Wf_Engine.AbortProcess(x_itemtype, bidder.wf_item_key, '', null);
9540:
9541: UPDATE pon_bidding_parties set

Line 9541: UPDATE pon_bidding_parties set

9537: -- For members, store item key in pon_bidding_parties
9538: -- End the previous waiting process
9539: Wf_Engine.AbortProcess(x_itemtype, bidder.wf_item_key, '', null);
9540:
9541: UPDATE pon_bidding_parties set
9542: wf_item_key = x_itemkey
9543: WHERE trading_partner_id = bidder.trading_partner_id
9544: AND auction_header_id = x_doc_number
9545: AND vendor_site_id = bidder.vendor_site_id; -- Supplier/supplier site combination can be different in 11.5.10

Line 11906: FROM PON_BIDDING_PARTIES PBP,

11902: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11903: HZ1.PERSON_LAST_NAME LAST_NAME,
11904: HZ.PARTY_ID COMPANY_ID,
11905: HZ.PARTY_NAME COMPANY_NAME
11906: FROM PON_BIDDING_PARTIES PBP,
11907: HZ_PARTIES HZ,
11908: HZ_PARTIES HZ1
11909: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
11910: AND HZ.PARTY_ID=PBP.TRADING_PARTNER_ID

Line 13405: pon_bidding_parties ppbp

13401: ppbp.auction_header_id
13402: INTO
13403: v_temp
13404: FROM
13405: pon_bidding_parties ppbp
13406: WHERE
13407: ppbp.auction_header_id = p_auction_header_id
13408: and ppbp.trading_partner_id = p_user_trading_partner_id
13409: AND rownum = 1;

Line 13432: pon_bidding_parties pbp

13428: ),
13429: (SELECT
13430: count(pbp.auction_header_id)
13431: FROM
13432: pon_bidding_parties pbp
13433: WHERE
13434: pbp.auction_header_id = p_auction_header_id
13435: and pbp.trading_partner_id = p_user_trading_partner_id
13436: ), 'Y', 'N')

Line 14966: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

14962: x_preview_date_notspec VARCHAR2(240);
14963: x_auction_start_date DATE;
14964: x_auction_end_date DATE;
14965: x_disqualify_reason varchar2(2000) := '';
14966: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
14967: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
14968: x_view_quote_url VARCHAR2(2000);
14969: x_disqualify_date DATE;
14970: x_bid_name VARCHAR2(10);

Line 15170: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

15166: x_preview_date DATE;
15167: x_preview_date_notspec VARCHAR2(240);
15168: x_auction_start_date DATE;
15169: x_auction_end_date DATE;
15170: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
15171: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
15172: x_staggered_close_note VARCHAR2(1000);
15173: x_timezone1_disp VARCHAR2(240);
15174: x_timezone_disp VARCHAR2(240);

Line 15333: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

15329: x_preview_date DATE;
15330: x_preview_date_notspec VARCHAR2(240);
15331: x_auction_start_date DATE;
15332: x_auction_end_date DATE;
15333: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
15334: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
15335: x_view_quote_url VARCHAR2(2000);
15336: x_bid_name VARCHAR2(10);
15337: x_staggered_close_note VARCHAR2(1000);

Line 15551: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

15547: x_preview_date DATE;
15548: x_preview_date_notspec VARCHAR2(240);
15549: x_auction_start_date DATE;
15550: x_auction_end_date DATE;
15551: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
15552: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
15553: x_view_quote_url VARCHAR2(2000);
15554: x_bid_name VARCHAR2(10);
15555: x_staggered_close_note VARCHAR2(1000);

Line 15760: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

15756: x_preview_date DATE;
15757: x_preview_date_notspec VARCHAR2(240);
15758: x_auction_start_date DATE;
15759: x_auction_end_date DATE;
15760: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
15761: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
15762: x_view_quote_url VARCHAR2(2000);
15763: x_bid_name VARCHAR2(10);
15764: x_staggered_close_note VARCHAR2(1000);

Line 15991: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

15987: x_preview_date DATE;
15988: x_preview_date_notspec VARCHAR2(240);
15989: x_auction_start_date DATE;
15990: x_auction_end_date DATE;
15991: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
15992: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
15993: x_view_quote_url VARCHAR2(2000);
15994: x_bid_name VARCHAR2(10);
15995: x_staggered_close_note VARCHAR2(1000);

Line 16199: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

16195: l_item_type wf_items.item_type%TYPE;
16196: l_item_key wf_items.item_key%TYPE;
16197: x_auction_start_date DATE;
16198: x_auction_end_date DATE;
16199: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
16200: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
16201: x_neg_summary_url VARCHAR2(2000);
16202: x_staggered_close_note VARCHAR2(1000);
16203: x_timezone_disp VARCHAR2(240);

Line 16350: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

16346: x_preview_date DATE;
16347: x_preview_date_notspec VARCHAR2(240);
16348: x_auction_start_date DATE;
16349: x_auction_end_date DATE;
16350: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
16351: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
16352: x_ack_participation_url VARCHAR2(2000);
16353: x_neg_summary_url VARCHAR2(2000);
16354: x_staggered_close_note VARCHAR2(1000);

Line 16589: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

16585: x_preview_date DATE;
16586: x_preview_date_notspec VARCHAR2(240);
16587: x_auction_start_date DATE;
16588: x_auction_end_date DATE;
16589: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
16590: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
16591: x_neg_summary_url VARCHAR2(2000);
16592: x_staggered_close_note VARCHAR2(1000);
16593: x_timezone1_disp VARCHAR2(240);

Line 16773: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

16769: x_preview_date DATE;
16770: x_preview_date_notspec VARCHAR2(240);
16771: x_auction_start_date DATE;
16772: x_auction_end_date DATE;
16773: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
16774: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
16775: x_neg_summary_url VARCHAR2(2000);
16776: x_ack_participation_url VARCHAR2(2000);
16777: x_isupplier_reg_url VARCHAR2(2000);

Line 16972: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

16968: x_preview_date DATE;
16969: x_preview_date_notspec VARCHAR2(240);
16970: x_auction_start_date DATE;
16971: x_auction_end_date DATE;
16972: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
16973: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
16974: x_neg_summary_url VARCHAR2(2000);
16975: x_staggered_close_note VARCHAR2(1000);
16976: x_timezone1_disp VARCHAR2(240);

Line 17154: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

17150: x_preview_date DATE;
17151: x_preview_date_notspec VARCHAR2(240);
17152: x_auction_start_date DATE;
17153: x_auction_end_date DATE;
17154: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
17155: x_bidder_tp_addresssname PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
17156: x_neg_summary_url VARCHAR2(2000);
17157: x_isupplier_reg_url VARCHAR2(2000);
17158: x_ack_participation_url VARCHAR2(2000);