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_BID_HEADERS

Line 69: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

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,
73: p_eval_flag IN VARCHAR2,

Line 70: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

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,
73: p_eval_flag IN VARCHAR2,
74: p_buyer_user IN VARCHAR2,

Line 71: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

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,
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,

Line 72: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

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,
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

Line 85: pon_bid_headers bh

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
89: AND EXISTS

Line 90: (SELECT 1 FROM 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
89: AND EXISTS
90: (SELECT 1 FROM pon_bid_headers bh
91: WHERE bh.auction_header_id = ah.auction_header_id
92: AND Nvl(bh.surrog_bid_flag,'N') = p_buyer_user
93: AND bh.trading_partner_id = p_tpid
94: AND ((p_eval_flag = 'N' AND bh.trading_partner_contact_id = p_tpcid) OR

Line 123: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

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,
127: p_eval_flag IN VARCHAR2,

Line 124: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

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,
127: p_eval_flag IN VARCHAR2,
128: p_buyer_user IN VARCHAR2,

Line 125: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

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,
127: p_eval_flag IN VARCHAR2,
128: p_buyer_user IN VARCHAR2,
129: x_return_status OUT NOCOPY NUMBER,

Line 126: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

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,
127: p_eval_flag IN VARCHAR2,
128: p_buyer_user IN VARCHAR2,
129: x_return_status OUT NOCOPY NUMBER,
130: x_return_code OUT NOCOPY VARCHAR2) 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 267: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,

263: --
264: -- ======================================================================
265: PROCEDURE handle_proxy
266: (
267: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
268: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
269: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 268: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,

264: -- ======================================================================
265: PROCEDURE handle_proxy
266: (
267: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
268: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
269: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
272: ------------ Supplier Management: Supplier Evaluation ------------

Line 269: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

265: PROCEDURE handle_proxy
266: (
267: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
268: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
269: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
272: ------------ Supplier Management: Supplier Evaluation ------------
273: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

266: (
267: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
268: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
269: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
272: ------------ Supplier Management: Supplier Evaluation ------------
273: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
274: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

Line 271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

267: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
268: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
269: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
272: ------------ Supplier Management: Supplier Evaluation ------------
273: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
274: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
275: ------------------------------------------------------------------

Line 273: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

269: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
272: ------------ Supplier Management: Supplier Evaluation ------------
273: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
274: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
275: ------------------------------------------------------------------
276: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
277: x_rebid_flag OUT NOCOPY VARCHAR2

Line 274: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

270: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
271: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
272: ------------ Supplier Management: Supplier Evaluation ------------
273: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
274: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
275: ------------------------------------------------------------------
276: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
277: x_rebid_flag OUT NOCOPY VARCHAR2
278: ) IS

Line 276: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

272: ------------ Supplier Management: Supplier Evaluation ------------
273: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
274: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
275: ------------------------------------------------------------------
276: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
277: x_rebid_flag OUT NOCOPY VARCHAR2
278: ) IS
279: l_max_line_number pon_bid_item_prices.line_number%TYPE;
280: l_batch_start pon_bid_item_prices.line_number%TYPE;

Line 286: FROM pon_bid_headers bh

282: BEGIN
283:
284: SELECT bh.old_bid_number
285: INTO x_prev_bid_number
286: FROM pon_bid_headers bh
287: WHERE bh.bid_number = p_draft_bid_num;
288:
289: SELECT bh.bid_number, Decode(bh.bid_status,'ACTIVE','Y','N')
290: INTO x_prev_bid_number, x_rebid_flag

Line 291: FROM pon_bid_headers bh

287: WHERE bh.bid_number = p_draft_bid_num;
288:
289: SELECT bh.bid_number, Decode(bh.bid_status,'ACTIVE','Y','N')
290: INTO x_prev_bid_number, x_rebid_flag
291: FROM pon_bid_headers bh
292: WHERE bh.bid_number = x_prev_bid_number;
293:
294:
295: IF x_rebid_flag = 'Y' THEN

Line 367: p_source_bid_num IN pon_bid_headers.BID_NUMBER%TYPE,

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:
371: BEGIN

Line 368: p_draft_bid_num OUT NOCOPY pon_bid_headers.BID_NUMBER%TYPE)

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:
371: BEGIN
372:

Line 375: FROM pon_bid_headers

371: BEGIN
372:
373: SELECT bid_number
374: INTO p_draft_bid_num
375: FROM pon_bid_headers
376: WHERE auction_header_id = p_auc_header_id
377: AND old_bid_number = p_source_bid_num;
378:
379: EXCEPTION

Line 387: p_draft_number IN pon_bid_headers.bid_number%TYPE,

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,
391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

Line 389: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

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,
391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
392: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

Line 390: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

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,
391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
392: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 391: p_tpid IN pon_bid_headers.trading_partner_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,
391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
392: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

Line 392: p_evaluator_id IN pon_bid_headers.evaluator_id%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,
391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
392: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
396: x_rebid_flag OUT NOCOPY VARCHAR2,

Line 393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

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,
391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
392: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
396: x_rebid_flag OUT NOCOPY VARCHAR2,
397: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

390: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
392: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
396: x_rebid_flag OUT NOCOPY VARCHAR2,
397: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
398: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

391: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
392: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
396: x_rebid_flag OUT NOCOPY VARCHAR2,
397: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
398: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
399: x_amend_bid_def OUT NOCOPY VARCHAR2,

Line 397: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

393: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
396: x_rebid_flag OUT NOCOPY VARCHAR2,
397: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
398: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
399: x_amend_bid_def OUT NOCOPY VARCHAR2,
400: x_round_bid_def OUT NOCOPY VARCHAR2,
401: x_prev_bid_disq OUT NOCOPY VARCHAR2,

Line 398: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

394: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
395: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
396: x_rebid_flag OUT NOCOPY VARCHAR2,
397: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
398: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
399: x_amend_bid_def OUT NOCOPY VARCHAR2,
400: x_round_bid_def OUT NOCOPY VARCHAR2,
401: x_prev_bid_disq OUT NOCOPY VARCHAR2,
402: x_prev_bid_wthd OUT NOCOPY VARCHAR2,

Line 491: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

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,
495: x_prev_bid_disq OUT NOCOPY VARCHAR2,

Line 500: l_bid_status pon_bid_headers.bid_status%TYPE;

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
504: INTO l_orig_amend_id

Line 525: FROM pon_bid_headers bh,

521: x_amend_bid_def,
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:

Line 535: UPDATE pon_bid_headers

531: -- mark it as archived_draft
532: IF l_bid_status = 'DRAFT'
533: AND (x_round_bid_def = 'Y' OR x_amend_bid_def = 'Y') THEN
534:
535: UPDATE pon_bid_headers
536: SET bid_status = 'ARCHIVED_DRAFT',
537: last_update_date = SYSDATE
538: WHERE bid_number = p_source_bid_num;
539:

Line 591: p_draft_number IN pon_bid_headers.bid_number%TYPE,

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,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,

Line 592: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

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,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,

Line 593: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

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,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,
597: p_venid IN pon_bid_headers.vendor_id%TYPE,

Line 594: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

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,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,
597: p_venid IN pon_bid_headers.vendor_id%TYPE,
598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%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,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,
597: p_venid IN pon_bid_headers.vendor_id%TYPE,
598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 596: p_userid IN pon_bid_headers.created_by%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,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,
597: p_venid IN pon_bid_headers.vendor_id%TYPE,
598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
600: p_buyer_user IN VARCHAR2,

Line 597: p_venid IN pon_bid_headers.vendor_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,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,
597: p_venid IN pon_bid_headers.vendor_id%TYPE,
598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
600: p_buyer_user IN VARCHAR2,
601: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

Line 598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

594: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,
597: p_venid IN pon_bid_headers.vendor_id%TYPE,
598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
600: p_buyer_user IN VARCHAR2,
601: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
602: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

Line 599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

595: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
596: p_userid IN pon_bid_headers.created_by%TYPE,
597: p_venid IN pon_bid_headers.vendor_id%TYPE,
598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
600: p_buyer_user IN VARCHAR2,
601: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
602: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
603:

Line 601: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

597: p_venid IN pon_bid_headers.vendor_id%TYPE,
598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
600: p_buyer_user IN VARCHAR2,
601: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
602: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
603:
604: ----------- Supplier Management: Supplier Evaluation -----------
605: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 602: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,

598: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
599: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
600: p_buyer_user IN VARCHAR2,
601: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
602: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
603:
604: ----------- Supplier Management: Supplier Evaluation -----------
605: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
606: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

Line 605: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

601: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
602: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
603:
604: ----------- Supplier Management: Supplier Evaluation -----------
605: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
606: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
607: ----------------------------------------------------------------
608:
609: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

Line 606: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,

602: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
603:
604: ----------- Supplier Management: Supplier Evaluation -----------
605: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
606: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
607: ----------------------------------------------------------------
608:
609: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
610: x_rebid_flag OUT NOCOPY VARCHAR2,

Line 609: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

605: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
606: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
607: ----------------------------------------------------------------
608:
609: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
610: x_rebid_flag OUT NOCOPY VARCHAR2,
611: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
612: x_amend_bid_def OUT NOCOPY VARCHAR2,
613: x_round_bid_def OUT NOCOPY VARCHAR2,

Line 611: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,

607: ----------------------------------------------------------------
608:
609: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
610: x_rebid_flag OUT NOCOPY VARCHAR2,
611: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
612: x_amend_bid_def OUT NOCOPY VARCHAR2,
613: x_round_bid_def OUT NOCOPY VARCHAR2,
614: x_prev_bid_disq OUT NOCOPY VARCHAR2,
615: x_prev_bid_wthd OUT NOCOPY VARCHAR2,

Line 620: p_rev_bid_number IN pon_bid_headers.bid_number%TYPE,

616: x_withdraw_reason OUT NOCOPY VARCHAR2,
617: x_edit_draft OUT NOCOPY VARCHAR2,
618:
619: p_action_code IN VARCHAR2,
620: p_rev_bid_number IN pon_bid_headers.bid_number%TYPE,
621: x_return_status OUT NOCOPY NUMBER,
622: x_return_code OUT NOCOPY VARCHAR2
623: ) IS
624: l_new_round_or_amended VARCHAR2(1);

Line 625: l_existing_draft_bid pon_bid_headers.bid_number%TYPE;

621: x_return_status OUT NOCOPY NUMBER,
622: x_return_code OUT NOCOPY VARCHAR2
623: ) IS
624: l_new_round_or_amended VARCHAR2(1);
625: l_existing_draft_bid pon_bid_headers.bid_number%TYPE;
626:
627: BEGIN
628: --insert_into_vhk_dummy('Start of procedure check_and_load_bid p_rev_bid_number : '||p_rev_bid_number);
629: