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_MULTIPLE_RESPONSE_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 46: FUNCTION multiple_resp_enabled(p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

42: * Returns 'Y' : when ALLOW_MULTIPLE_ACTIVE_OFFERS control is enabled and :
43: if buyer, neg should not two stage enabled
44: if supplier
45: */
46: FUNCTION multiple_resp_enabled(p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
47: p_buyer_user IN VARCHAR2)
48: RETURN VARCHAR2 IS
49:
50: l_multi_resp_enabled VARCHAR2(1);

Line 57: FROM pon_auction_headers_all

53: SELECT Decode(Nvl(ALLOW_MULTIPLE_ACTIVE_OFFERS,'N'),'Y',
54: decode(p_buyer_user,'Y',
55: Decode(Nvl(two_part_flag,'N'),'Y','N','Y'),'Y'),'N')
56: INTO l_multi_resp_enabled
57: FROM pon_auction_headers_all
58: WHERE auction_header_id = p_auction_header_id;
59:
60: RETURN l_multi_resp_enabled;
61:

Line 68: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

64: /* This procedure gives auction_header_id of document in this round and on previous round
65: * which has offers. Draft offers on previous round are not considered.
66: * If offers exist on multiple documents, latest submitted document with offers will be returned.
67: */
68: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
69: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
70: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
71: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
72: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 75: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,

71: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
72: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
73: p_eval_flag IN VARCHAR2,
74: p_buyer_user IN VARCHAR2,
75: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,
76: x_is_prev_amend OUT NOCOPY VARCHAR2) IS
77:
78: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
79: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

Line 78: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;

74: p_buyer_user IN VARCHAR2,
75: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,
76: x_is_prev_amend OUT NOCOPY VARCHAR2) IS
77:
78: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
79: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
80:
81: CURSOR c_get_neg_with_resp IS
82: SELECT ah.auction_header_id,

Line 79: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

75: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,
76: x_is_prev_amend OUT NOCOPY VARCHAR2) IS
77:
78: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
79: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
80:
81: CURSOR c_get_neg_with_resp IS
82: SELECT ah.auction_header_id,
83: Decode(ah.auction_header_id_orig_amend,l_orig_amend_id,'Y','N')

Line 84: FROM pon_auction_headers_all ah,

80:
81: CURSOR c_get_neg_with_resp IS
82: SELECT ah.auction_header_id,
83: Decode(ah.auction_header_id_orig_amend,l_orig_amend_id,'Y','N')
84: FROM pon_auction_headers_all ah,
85: pon_bid_headers bh
86: WHERE (ah.auction_header_id_orig_amend = l_orig_amend_id
87: OR ah.auction_header_id_orig_amend = l_prev_round_id)
88: AND ah.auction_header_id <> p_auc_header_id

Line 107: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2

103:
104: BEGIN
105: SELECT ah.auction_header_id_orig_amend, ah2.auction_header_id_orig_amend
106: INTO l_orig_amend_id, l_prev_round_id
107: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2
108: WHERE ah.auction_header_id = p_auc_header_id
109: and ah2.auction_header_id (+) = ah.auction_header_id_prev_round;
110:
111: OPEN c_get_neg_with_resp;

Line 122: PROCEDURE check_resp_exists(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

118: x_is_prev_amend := NULL;
119:
120: END get_latest_neg_with_resp;
121:
122: PROCEDURE check_resp_exists(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
123: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
124: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
125: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
126: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 132: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;

128: p_buyer_user IN VARCHAR2,
129: x_return_status OUT NOCOPY NUMBER,
130: x_return_code OUT NOCOPY VARCHAR2) IS
131:
132: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
133: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
134: l_terms_cond_apply VARCHAR2(1);
135: l_bid_count NUMBER;
136: -- for the bug 13984944

Line 133: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

129: x_return_status OUT NOCOPY NUMBER,
130: x_return_code OUT NOCOPY VARCHAR2) IS
131:
132: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
133: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
134: l_terms_cond_apply VARCHAR2(1);
135: l_bid_count NUMBER;
136: -- for the bug 13984944
137: l_org_contract_status pon_contracts.contract_status%TYPE;

Line 139: l_org_id pon_auction_headers_all.org_id%TYPE;

135: l_bid_count NUMBER;
136: -- for the bug 13984944
137: l_org_contract_status pon_contracts.contract_status%TYPE;
138: l_enabled_flag pon_contracts.enabled_flag%TYPE;
139: l_org_id pon_auction_headers_all.org_id%TYPE;
140: l_count_org NUMBER;
141:
142: -- select bids on all amendments/previous round by the current user for the current site
143: CURSOR c_check_bids_exist IS

Line 145: FROM pon_bid_headers bh, pon_auction_headers_all ah

141:
142: -- select bids on all amendments/previous round by the current user for the current site
143: CURSOR c_check_bids_exist IS
144: SELECT Count(*)
145: FROM pon_bid_headers bh, pon_auction_headers_all ah
146: WHERE
147: -- look at all amendments on the current round
148: (ah.auction_header_id_orig_amend = l_orig_amend_id
149: -- look at all amendments on the previous round

Line 173: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2

169: -- Also check if contracts have been installed
170: SELECT ah.auction_header_id_orig_amend, ah2.auction_header_id_orig_amend,
171: nvl2(ah.contract_id, 'Y', 'N'), ah.org_id
172: INTO l_orig_amend_id, l_prev_round_id, l_terms_cond_apply, l_org_id
173: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2
174: WHERE ah.auction_header_id = p_auc_header_id
175: and ah2.auction_header_id (+) = ah.auction_header_id_prev_round;
176:
177: log_message ('check_resp_exists', 'l_orig_amend_id = ' || l_orig_amend_id ||

Line 300: FROM pon_auction_headers_all ah

296:
297: -- Determine the maximum line number for the negotiation
298: SELECT ah.max_internal_line_num
299: INTO l_max_line_number
300: FROM pon_auction_headers_all ah
301: WHERE ah.auction_header_id = p_auc_header_id;
302:
303: -- Define the initial batch range (line numbers are indexed from 1)
304: l_batch_start := 1;

Line 366: PROCEDURE check_draft_exists(p_auc_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,

362:
363: END handle_proxy;
364:
365:
366: PROCEDURE check_draft_exists(p_auc_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,
367: p_source_bid_num IN pon_bid_headers.BID_NUMBER%TYPE,
368: p_draft_bid_num OUT NOCOPY pon_bid_headers.BID_NUMBER%TYPE)
369: IS
370:

Line 386: PROCEDURE lock_draft_bid(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

382:
383: END check_draft_exists;
384:
385: /* This is a overloaded procedure for pon_bid_defaulting_pkg.lock_draft */
386: PROCEDURE lock_draft_bid(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
387: p_draft_number IN pon_bid_headers.bid_number%TYPE,
388: p_buyer_user IN VARCHAR2,
389: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
390: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

Line 490: PROCEDURE get_source_bid_details(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

486:
487: END lock_draft_bid;
488:
489:
490: PROCEDURE get_source_bid_details(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
491: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
492: x_rebid_flag OUT NOCOPY VARCHAR2,
493: x_amend_bid_def OUT NOCOPY VARCHAR2,
494: x_round_bid_def OUT NOCOPY VARCHAR2,

Line 499: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

495: x_prev_bid_disq OUT NOCOPY VARCHAR2,
496: x_prev_bid_wthd OUT NOCOPY VARCHAR2,
497: x_withdraw_reason OUT NOCOPY VARCHAR2)
498: IS
499: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
500: l_bid_status pon_bid_headers.bid_status%TYPE;
501:
502: BEGIN
503: SELECT ah.auction_header_id_orig_amend

Line 505: FROM pon_auction_headers_all ah

501:
502: BEGIN
503: SELECT ah.auction_header_id_orig_amend
504: INTO l_orig_amend_id
505: FROM pon_auction_headers_all ah
506: WHERE ah.auction_header_id = p_auc_header_id;
507:
508: SELECT
509: bh.bid_status,

Line 526: pon_auction_headers_all ah

522: x_prev_bid_disq,
523: x_prev_bid_wthd,
524: x_withdraw_reason
525: FROM pon_bid_headers bh,
526: pon_auction_headers_all ah
527: WHERE bid_number = p_source_bid_num
528: AND ah.auction_header_id = bh.auction_header_id;
529:
530: -- If source bid is draft on previous amendment or new round, then

Line 590: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

586: -- is to be created. Or whether a draft already exists
587: -- ======================================================================
588: PROCEDURE check_and_load_bid
589: (
590: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
591: p_draft_number IN pon_bid_headers.bid_number%TYPE,
592: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
593: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
594: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,