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_BID_DEFAULTING_PKG dependencies on PON_BIDDING_PARTIES

Line 53: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,

49: PROCEDURE populate_display_pf_flag
50: (
51: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
52: p_bid_number IN pon_bid_headers.bid_number%TYPE,
53: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
54: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
56: x_skip_pf_for_batch OUT NOCOPY VARCHAR2
57: ) IS

Line 169: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,

165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
166: p_has_pe_flag IN VARCHAR2,
167: p_blanket IN VARCHAR2,
168: p_full_qty IN VARCHAR2,
169: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
170: p_rate IN pon_bid_headers.rate%TYPE,
171: p_price_prec IN pon_bid_headers.number_price_decimals%TYPE,
172: p_curr_prec IN fnd_currencies.precision%TYPE,
173: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 178: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

174: p_batch_end IN pon_bid_item_prices.line_number%TYPE
175: ) IS
176: l_skip_pf_for_batch VARCHAR2(1);
177: l_restricted_flag VARCHAR2(1);
178: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
179: BEGIN
180:
181:
182: /************************************************************

Line 261: FROM pon_bidding_parties bp

257: BEGIN
258: -- Check if the supplier has restricted lines, and get sequence number
259: SELECT decode(bp.access_type, 'RESTRICTED', 'Y', 'N'), bp.sequence
260: INTO l_restricted_flag, l_supp_seq_number
261: FROM pon_bidding_parties bp
262: WHERE bp.auction_header_id = p_auc_header_id
263: AND bp.trading_partner_id = p_tpid
264: AND nvl(bp.vendor_site_id, -1) = p_vensid;
265: EXCEPTION

Line 2879: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

2875: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
2876: l_restricted_flag VARCHAR2(1);
2877: l_rel12_draft VARCHAR2(1);
2878: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2879: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2880:
2881: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2882: l_batch_start pon_bid_item_prices.line_number%TYPE;
2883: l_batch_end pon_bid_item_prices.line_number%TYPE;

Line 2969: FROM pon_bidding_parties bp

2965: BEGIN
2966: -- Check if the supplier has restricted lines, and get sequence number
2967: SELECT decode(bp.access_type, 'RESTRICTED', 'Y', 'N'), bp.sequence
2968: INTO l_restricted_flag, l_supp_seq_number
2969: FROM pon_bidding_parties bp
2970: WHERE bp.auction_header_id = p_auc_header_id
2971: AND bp.trading_partner_id = p_tpid
2972: AND nvl(bp.vendor_site_id, -1) = p_vensid;
2973: EXCEPTION

Line 3629: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

3625: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3626: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3627: l_userid pon_bid_headers.created_by%TYPE;
3628: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3629: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
3630: l_has_pe_flag VARCHAR2(1);
3631: l_blanket VARCHAR2(1);
3632: l_full_qty VARCHAR2(1);
3633: l_rate pon_bid_headers.rate%TYPE;

Line 3677: FROM pon_bidding_parties bp

3673: BEGIN
3674: -- Get the supplier sequence number
3675: SELECT bp.sequence
3676: INTO l_supp_seq_number
3677: FROM pon_bidding_parties bp
3678: WHERE bp.auction_header_id = l_auc_header_id
3679: AND bp.trading_partner_id = l_tpid
3680: AND bp.vendor_site_id = l_vensid;
3681:

Line 3919: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,

3915: -- COMMENT: Determine if the vensid, venscode combination can bid on the negotiation
3916: -- ======================================================================
3917: PROCEDURE validate_site
3918: (
3919: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3920: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3921: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3922: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3923: x_return_status OUT NOCOPY NUMBER,

Line 3920: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,

3916: -- ======================================================================
3917: PROCEDURE validate_site
3918: (
3919: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3920: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3921: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3922: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3923: x_return_status OUT NOCOPY NUMBER,
3924: x_return_code OUT NOCOPY VARCHAR2

Line 3921: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,

3917: PROCEDURE validate_site
3918: (
3919: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3920: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3921: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3922: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3923: x_return_status OUT NOCOPY NUMBER,
3924: x_return_code OUT NOCOPY VARCHAR2
3925: ) IS

Line 3922: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,

3918: (
3919: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3920: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3921: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3922: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3923: x_return_status OUT NOCOPY NUMBER,
3924: x_return_code OUT NOCOPY VARCHAR2
3925: ) IS
3926: CURSOR sites IS

Line 3928: FROM pon_bidding_parties

3924: x_return_code OUT NOCOPY VARCHAR2
3925: ) IS
3926: CURSOR sites IS
3927: SELECT vendor_site_id id, vendor_site_code code
3928: FROM pon_bidding_parties
3929: WHERE auction_header_id = p_auc_header_id
3930: AND trading_partner_id = p_tpid;
3931:
3932: l_sites_invited BOOLEAN DEFAULT false;

Line 4248: FROM pon_bidding_parties

4244:
4245: -- Do an existence check
4246: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
4247: INTO l_invited_flag
4248: FROM pon_bidding_parties
4249: WHERE auction_header_id = p_auc_header_id
4250: -- AND trading_partner_id = p_tpid; -- Modified for ER: Supplier Management: Supplier Evaluation
4251: AND ((trading_partner_id IS NOT NULL AND trading_partner_id = p_tpid) OR
4252: (trading_partner_id IS NULL AND requested_supplier_id = p_tpid));

Line 6133: FROM pon_bidding_parties

6129: --In case the vendor is not in the invited, return -1 and let the old flow work.
6130: BEGIN
6131: SELECT vendor_site_id
6132: INTO site_id
6133: FROM pon_bidding_parties
6134: WHERE auction_header_id = p_auction_header_id
6135: AND trading_partner_id = p_tp_id
6136: AND ROWNUM = 1;
6137:

Line 6154: FROM pon_bidding_parties

6150:
6151: BEGIN
6152: SELECT vendor_site_id
6153: INTO site_id
6154: FROM pon_bidding_parties
6155: WHERE auction_header_id = p_auction_header_id
6156: AND trading_partner_id = p_tp_id
6157: AND vendor_site_id NOT IN
6158: (SELECT vendor_site_id

Line 6169: FROM pon_bidding_parties

6165: EXCEPTION WHEN No_Data_Found THEN
6166:
6167: SELECT vendor_site_id
6168: INTO site_id
6169: FROM pon_bidding_parties
6170: WHERE auction_header_id = p_auction_header_id
6171: AND trading_partner_id = p_tp_id
6172: AND ROWNUM = 1;
6173: