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.

[Home] [Help]

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 2636: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

2632: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
2633: l_restricted_flag VARCHAR2(1);
2634: l_rel12_draft VARCHAR2(1);
2635: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2636: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2637:
2638: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2639: l_batch_start pon_bid_item_prices.line_number%TYPE;
2640: l_batch_end pon_bid_item_prices.line_number%TYPE;

Line 2665: FROM pon_bidding_parties bp

2661: BEGIN
2662: -- Check if the supplier has restricted lines, and get sequence number
2663: SELECT decode(bp.access_type, 'RESTRICTED', 'Y', 'N'), bp.sequence
2664: INTO l_restricted_flag, l_supp_seq_number
2665: FROM pon_bidding_parties bp
2666: WHERE bp.auction_header_id = p_auc_header_id
2667: AND bp.trading_partner_id = p_tpid
2668: AND nvl(bp.vendor_site_id, -1) = p_vensid;
2669: EXCEPTION

Line 3059: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3057: l_userid pon_bid_headers.created_by%TYPE;
3058: l_vensid pon_bid_headers.vendor_site_id%TYPE;
3059: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
3060: l_has_pe_flag VARCHAR2(1);
3061: l_blanket VARCHAR2(1);
3062: l_full_qty VARCHAR2(1);
3063: l_rate pon_bid_headers.rate%TYPE;

Line 3107: FROM pon_bidding_parties bp

3103: BEGIN
3104: -- Get the supplier sequence number
3105: SELECT bp.sequence
3106: INTO l_supp_seq_number
3107: FROM pon_bidding_parties bp
3108: WHERE bp.auction_header_id = l_auc_header_id
3109: AND bp.trading_partner_id = l_tpid
3110: AND bp.vendor_site_id = l_vensid;
3111:

Line 3349: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,

3345: -- COMMENT: Determine if the vensid, venscode combination can bid on the negotiation
3346: -- ======================================================================
3347: PROCEDURE validate_site
3348: (
3349: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3350: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3351: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3352: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3353: x_return_status OUT NOCOPY NUMBER,

Line 3350: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,

3346: -- ======================================================================
3347: PROCEDURE validate_site
3348: (
3349: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3350: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3351: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3352: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3353: x_return_status OUT NOCOPY NUMBER,
3354: x_return_code OUT NOCOPY VARCHAR2

Line 3351: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,

3347: PROCEDURE validate_site
3348: (
3349: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3350: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3351: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3352: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3353: x_return_status OUT NOCOPY NUMBER,
3354: x_return_code OUT NOCOPY VARCHAR2
3355: ) IS

Line 3352: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,

3348: (
3349: p_auc_header_id IN pon_bidding_parties.auction_header_id%TYPE,
3350: p_tpid IN pon_bidding_parties.trading_partner_id%TYPE,
3351: p_vensid IN pon_bidding_parties.vendor_site_id%TYPE,
3352: p_venscode IN pon_bidding_parties.vendor_site_code%TYPE,
3353: x_return_status OUT NOCOPY NUMBER,
3354: x_return_code OUT NOCOPY VARCHAR2
3355: ) IS
3356: CURSOR sites IS

Line 3358: FROM pon_bidding_parties

3354: x_return_code OUT NOCOPY VARCHAR2
3355: ) IS
3356: CURSOR sites IS
3357: SELECT vendor_site_id id, vendor_site_code code
3358: FROM pon_bidding_parties
3359: WHERE auction_header_id = p_auc_header_id
3360: AND trading_partner_id = p_tpid;
3361:
3362: l_sites_invited BOOLEAN DEFAULT false;

Line 3593: FROM pon_bidding_parties

3589:
3590: -- Do an existence check
3591: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
3592: INTO l_invited_flag
3593: FROM pon_bidding_parties
3594: WHERE auction_header_id = p_auc_header_id
3595: AND trading_partner_id = p_tpid;
3596:
3597: IF (l_invited_flag = 'N') THEN