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 226: from pon_bidding_parties pbp,

222: pbp.requested_supplier_contact_id,
223: pbp.requested_supp_contact_name,
224: pcr.email_address rs_contact_email
225: -- lxchen
226: from pon_bidding_parties pbp,
227: pos_contact_requests pcr
228: where pbp.auction_header_id = x_auction_header_id and
229: pbp.requested_supplier_contact_id = pcr.contact_request_id (+)
230: union

Line 255: FROM pon_bidding_parties

251: where auction_header_id = x_auction_header_id)) and
252: bid_status in ('ACTIVE', 'RESUBMISSION', 'DISQUALIFIED', 'DRAFT') and
253: trading_partner_contact_id NOT IN
254: (SELECT nvl(trading_partner_contact_id, -1)
255: FROM pon_bidding_parties
256: WHERE auction_header_id = x_auction_header_id);
257:
258:
259: CURSOR c1_auction_type IS

Line 871: update pon_bidding_parties

867:
868: wf_engine.StartProcess(itemtype => x_itemtype,
869: itemkey => x_itemkey );
870:
871: update pon_bidding_parties
872: set wf_item_key = x_itemkey
873: where auction_header_id = x_auction_header_id and
874: ((trading_partner_id = bidder.trading_partner_id and
875: vendor_site_id = bidder.vendor_site_id) or

Line 1125: select 'Y' into x_new_bidders_flag from pon_bidding_parties

1121: avalue => x_bid_list);
1122:
1123: IF(x_bid_list = 'Y') THEN
1124: BEGIN
1125: select 'Y' into x_new_bidders_flag from pon_bidding_parties
1126: where auction_header_id = p_auction_header_id
1127: and trading_partner_id is null group by auction_header_id;
1128: EXCEPTION
1129: WHEN NO_DATA_FOUND THEN

Line 2758: from pon_bidding_parties pbp,

2754: x_current_activity varchar2(30);
2755:
2756: CURSOR bidder_list_wf_keys IS
2757: select pbp.wf_item_key wf_item_key, act.activity_label activity_label
2758: from pon_bidding_parties pbp,
2759: wf_item_activity_statuses_v act
2760: where pbp.auction_header_id = p_prev_doc_header_id and
2761: act.item_type = x_itemtype and
2762: act.item_key = pbp.wf_item_key and

Line 3120: FROM pon_bidding_parties pbp,

3116: trading_partner_id party_id,
3117: trading_partner_name party_name,
3118: DECODE(vendor_site_code, '-1', NULL, vendor_site_code) vendor_site_code,
3119: vendor_site_id
3120: FROM pon_bidding_parties pbp,
3121: fnd_user fu
3122: WHERE auction_header_id = x_doc_header_id_prev_round
3123: AND fu.person_party_id = pbp.trading_partner_contact_id
3124: AND nvl(fu.end_date, sysdate+1) > sysdate

Line 3132: FROM pon_bidding_parties pbp,

3128: pbp.trading_partner_id party_id,
3129: pbp.trading_partner_name party_name,
3130: DECODE(pbp.vendor_site_code, '-1', NULL, pbp.vendor_site_code) vendor_site_code,
3131: pbp.vendor_site_id
3132: FROM pon_bidding_parties pbp,
3133: wf_local_user_roles wlur
3134: WHERE pbp.auction_header_id = x_doc_header_id_prev_round
3135: AND wlur.role_name = x_role_name
3136: AND wlur.user_name = pbp.wf_user_name

Line 3154: from pon_bidding_parties pbp

3150: AND wlur.user_name = pbh.trading_partner_contact_name(+);
3151:
3152: CURSOR c2_inv_list (x_doc_header_id NUMBER) IS
3153: select trading_partner_id,vendor_site_id
3154: from pon_bidding_parties pbp
3155: where auction_header_id = x_doc_header_id;
3156:
3157: x_itemtype VARCHAR2(20) := 'PONPBLSH';
3158: x_itemkey VARCHAR2(60);

Line 3202: x_add_contact_email PON_BIDDING_PARTIES.ADDITIONAL_CONTACT_EMAIL%TYPE;

3198: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3199: x_startdate DATE;
3200: x_enddate DATE;
3201: x_auctioneer_user_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
3202: x_add_contact_email PON_BIDDING_PARTIES.ADDITIONAL_CONTACT_EMAIL%TYPE;
3203: x_preview_date DATE;
3204: x_preview_date_notspec VARCHAR2(240);
3205: x_timezone1_disp VARCHAR2(240);
3206: x_newstarttime DATE;

Line 3787: from pon_bidding_parties pbp, pos_contact_requests pcr

3783: pbp.vendor_site_id,
3784: pbp.requested_supplier_id,
3785: pbp.requested_supplier_contact_id,
3786: pcr.email_address rs_contact_email
3787: from pon_bidding_parties pbp, pos_contact_requests pcr
3788: where pbp.auction_header_id = x_auction_header_id
3789: and pbp.requested_supplier_contact_id = pcr.contact_request_id (+);
3790:
3791: CURSOR c_user_name IS

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

3893: -- Bug 3824928: If trading partner contact is not there then prevent
3894: -- this SELECT from erroring out
3895: -- The steps below try to set up the user for the additional contact
3896: -- email so that they have the same settings as the existing contact.
3897: -- However, if the row in pon_bidding_parties does not have a contact,
3898: -- then the additional contact user inherits the settings of the
3899: -- auctioneer
3900:
3901: IF bidder.trading_partner_contact_id IS NOT NULL --{

Line 3960: UPDATE pon_bidding_parties set

3956: null,
3957: 'ACTIVE',
3958: null);
3959: x_progress := '023';
3960: UPDATE pon_bidding_parties set
3961: wf_user_name = x_user_name
3962: WHERE auction_header_id = x_auction_header_id
3963: AND trading_partner_id = bidder.trading_partner_id
3964: AND vendor_site_id = bidder.vendor_site_id;

Line 4002: -- record wf_user_name in pon_bidding_parties

3998: 'ACTIVE',
3999: null);
4000: x_progress := '023_REQ';
4001:
4002: -- record wf_user_name in pon_bidding_parties
4003: UPDATE pon_bidding_parties
4004: set wf_user_name = x_user_name
4005: WHERE auction_header_id = x_auction_header_id
4006: AND requested_supplier_id = bidder.requested_supplier_id;

Line 4003: UPDATE pon_bidding_parties

3999: null);
4000: x_progress := '023_REQ';
4001:
4002: -- record wf_user_name in pon_bidding_parties
4003: UPDATE pon_bidding_parties
4004: set wf_user_name = x_user_name
4005: WHERE auction_header_id = x_auction_header_id
4006: AND requested_supplier_id = bidder.requested_supplier_id;
4007:

Line 4309: from pon_bidding_parties

4305: x_progress := '020';
4306:
4307: begin
4308: select 'Y' into x_flag
4309: from pon_bidding_parties
4310: where auction_header_id = x_auction_header_id
4311: and trading_partner_contact_id = x_bidder_contact_id
4312: group by trading_partner_contact_id;
4313: exception when NO_DATA_FOUND then

Line 6037: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;

6033: IS
6034:
6035: x_doc_number number;
6036: x_profile_user VARCHAR2(240) := '';
6037: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
6038: x_vendor_site_code PON_BIDDING_PARTIES.VENDOR_SITE_CODE%TYPE;
6039: x_vendor_site_id NUMBER;
6040: x_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
6041: x_wf_role_name varchar2(100) := '';

Line 6038: x_vendor_site_code PON_BIDDING_PARTIES.VENDOR_SITE_CODE%TYPE;

6034:
6035: x_doc_number number;
6036: x_profile_user VARCHAR2(240) := '';
6037: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
6038: x_vendor_site_code PON_BIDDING_PARTIES.VENDOR_SITE_CODE%TYPE;
6039: x_vendor_site_id NUMBER;
6040: x_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
6041: x_wf_role_name varchar2(100) := '';
6042: x_language_code varchar2(30);

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

6061: select wfu.user_name user_name, person_party_id
6062: from wf_user_roles wfu, fnd_user fnd
6063: where role_name = x_wf_role_name
6064: and fnd.user_name (+) = wfu.user_name
6065: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6066: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);
6067:
6068: CURSOR bidders_info IS
6069: 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 6070: from pon_bidding_parties

6066: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);
6067:
6068: CURSOR bidders_info IS
6069: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6070: from pon_bidding_parties
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

Line 6213: from pon_bidding_parties

6209: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_profile_user,x_language_code);
6210:
6211: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6212: into x_bidder_tp_name, x_vendor_site_code, x_vendor_site_id
6213: from pon_bidding_parties
6214: where wf_user_name = bidder.user_name
6215: and auction_header_id = x_doc_number;
6216:
6217: -- Get the timezone for the user

Line 6627: from pon_bidding_parties pbp,

6623: pbp.requested_supplier_name,
6624: pbp.requested_supplier_contact_id,
6625: pbp.requested_supp_contact_name,
6626: pcr.email_address rs_contact_email
6627: from pon_bidding_parties pbp,
6628: pos_contact_requests pcr
6629: where auction_header_id = x_auction_header_id
6630: and pbp.requested_supplier_contact_id = pcr.contact_request_id(+)
6631: and wf_item_key IS NULL;

Line 7118: UPDATE pon_bidding_parties set

7114:
7115: -- Bug 3709564
7116: -- If this update is not performed here, it will error out
7117: -- in notify_bidder_list_reminder as wf_user_name will be null
7118: UPDATE pon_bidding_parties set
7119: wf_user_name = x_additional_user_name
7120: WHERE auction_header_id = x_auction_header_id
7121: AND trading_partner_id = bidder.trading_partner_id
7122: AND vendor_site_id = bidder.vendor_site_id;

Line 7173: UPDATE pon_bidding_parties SET

7169:
7170: WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
7171: x_rs_user_name);
7172:
7173: UPDATE pon_bidding_parties SET
7174: wf_user_name = x_rs_user_name
7175: WHERE auction_header_id = x_auction_header_id
7176: AND (trading_partner_id = bidder.trading_partner_id
7177: or requested_supplier_id = bidder.requested_supplier_id)

Line 7195: update pon_bidding_parties

7191:
7192: -- Bug 3709564
7193: -- If this update is not performed here, wf_engine.abort_process call
7194: -- in notify_bidder_list_reminder will fail, as wf_item_key will be null
7195: update pon_bidding_parties
7196: set wf_item_key = t_itemkey
7197: where auction_header_id = x_auction_header_id and
7198: (trading_partner_id = bidder.trading_partner_id
7199: or requested_supplier_id = bidder.requested_supplier_Id) and

Line 7280: from pon_bidding_parties

7276: BEGIN
7277: begin
7278: select trading_partner_contact_id
7279: into x_user_id
7280: from pon_bidding_parties
7281: where auction_header_id = p_doc_id
7282: and wf_user_name = p_user_name;
7283:
7284: if x_user_id is null then -- it means the additional contact is not associated to any

Line 7702: UPDATE pon_bidding_parties

7698: x_now := SYSDATE;
7699:
7700: IF (x_closedate>x_now AND x_auction_status<>'CANCELLED' AND x_auction_status<>'DELETED') then
7701:
7702: UPDATE pon_bidding_parties
7703: SET supp_acknowledgement='Y',
7704: ack_note_to_auctioneer = x_note,
7705: ack_partner_contact_id = trading_partner_contact_id,
7706: acknowledgement_time = x_now

Line 7774: UPDATE pon_bidding_parties

7770:
7771: IF (x_closedate>x_now AND x_auction_status<>'CANCELLED' AND x_auction_status<>'DELETED') then
7772:
7773:
7774: UPDATE pon_bidding_parties
7775: SET supp_acknowledgement='N',
7776: ack_note_to_auctioneer = x_note,
7777: ack_partner_contact_id = trading_partner_contact_id,
7778: acknowledgement_time = x_now

Line 8297: UPDATE pon_bidding_parties set

8293: itemkey => p_itemkey,
8294: aname => 'TRADING_PARTNER_ID');
8295:
8296:
8297: UPDATE pon_bidding_parties set
8298: wf_item_key = x_itemkey
8299: WHERE trading_partner_id = x_tp_id
8300: AND auction_header_id = x_auction_header_id;
8301:

Line 8333: from pon_bidding_parties pbd,

8329: pbd.additional_contact_email,
8330: pbd.registration_id,
8331: pbd.trading_partner_contact_id, -- Bug 3824928 added
8332: pbd.vendor_site_id
8333: from pon_bidding_parties pbd,
8334: fnd_user fu
8335: WHERE pbd.trading_partner_contact_id=fu.person_party_id (+) AND -- Bug 3824928: added outer join
8336: nvl(fu.end_date, sysdate+1) > sysdate AND -- Added for TCA project
8337: pbd.auction_header_id=x_doc_number AND

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

8807: -- partner contact id is not null
8808:
8809: IF bidder.trading_partner_contact_id IS NOT NULL THEN -- {
8810:
8811: -- For members, store item key in pon_bidding_parties
8812: -- End the previous waiting process
8813: Wf_Engine.AbortProcess(x_itemtype, bidder.wf_item_key, '', null);
8814:
8815: UPDATE pon_bidding_parties set

Line 8815: UPDATE pon_bidding_parties set

8811: -- For members, store item key in pon_bidding_parties
8812: -- End the previous waiting process
8813: Wf_Engine.AbortProcess(x_itemtype, bidder.wf_item_key, '', null);
8814:
8815: UPDATE pon_bidding_parties set
8816: wf_item_key = x_itemkey
8817: WHERE trading_partner_id = bidder.trading_partner_id
8818: AND auction_header_id = x_doc_number
8819: AND vendor_site_id = bidder.vendor_site_id; -- Supplier/supplier site combination can be different in 11.5.10

Line 11070: FROM PON_BIDDING_PARTIES PBP,

11066: HZ1.PERSON_FIRST_NAME FIRST_NAME,
11067: HZ1.PERSON_LAST_NAME LAST_NAME,
11068: HZ.PARTY_ID COMPANY_ID,
11069: HZ.PARTY_NAME COMPANY_NAME
11070: FROM PON_BIDDING_PARTIES PBP,
11071: HZ_PARTIES HZ,
11072: HZ_PARTIES HZ1
11073: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
11074: AND HZ.PARTY_ID=PBP.TRADING_PARTNER_ID

Line 12549: pon_bidding_parties ppbp

12545: ppbp.auction_header_id
12546: INTO
12547: v_temp
12548: FROM
12549: pon_bidding_parties ppbp
12550: WHERE
12551: ppbp.auction_header_id = p_auction_header_id
12552: and ppbp.trading_partner_id = p_user_trading_partner_id
12553: AND rownum = 1;

Line 12575: pon_bidding_parties pbp

12571: ),
12572: (SELECT
12573: count(pbp.auction_header_id)
12574: FROM
12575: pon_bidding_parties pbp
12576: WHERE
12577: pbp.auction_header_id = p_auction_header_id
12578: and pbp.trading_partner_id = p_user_trading_partner_id
12579: ), 'Y', 'N')