[Home] [Help]
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_BID_DEFAULTING_PKG';
5: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.bidDefaultingPkg.';
7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;
8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;
9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;
48: -- ======================================================================
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
156: -- COMMENT: Insert missing auction side lines into a draft bid
157: -- ======================================================================
158: PROCEDURE insert_auction_lines
159: (
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
157: -- ======================================================================
158: PROCEDURE insert_auction_lines
159: (
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
158: PROCEDURE insert_auction_lines
159: (
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
166: p_has_pe_flag IN VARCHAR2,
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%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,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%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,
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,
174: p_batch_end IN pon_bid_item_prices.line_number%TYPE
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,
174: p_batch_end IN pon_bid_item_prices.line_number%TYPE
175: ) IS
685: -- COMMENT: Populate old value columns for a bid
686: -- ======================================================================
687: PROCEDURE populate_old_value_columns
688: (
689: p_bid_number IN pon_bid_headers.bid_number%TYPE,
690: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
691: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
692: p_batch_end IN pon_bid_item_prices.line_number%TYPE
693: ) IS
686: -- ======================================================================
687: PROCEDURE populate_old_value_columns
688: (
689: p_bid_number IN pon_bid_headers.bid_number%TYPE,
690: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
691: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
692: p_batch_end IN pon_bid_item_prices.line_number%TYPE
693: ) IS
694: BEGIN
815: -- if the bid was a rebid
816: -- ======================================================================
817: PROCEDURE handle_proxy
818: (
819: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
820: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
821: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
822: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
823: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
816: -- ======================================================================
817: PROCEDURE handle_proxy
818: (
819: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
820: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
821: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
822: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
823: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
824: ------------ Supplier Management: Supplier Evaluation ------------
817: PROCEDURE handle_proxy
818: (
819: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
820: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
821: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
822: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
823: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
824: ------------ Supplier Management: Supplier Evaluation ------------
825: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
818: (
819: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
820: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
821: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
822: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
823: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
824: ------------ Supplier Management: Supplier Evaluation ------------
825: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
826: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
819: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
820: p_draft_bid_num IN pon_bid_headers.bid_number%TYPE,
821: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
822: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
823: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
824: ------------ Supplier Management: Supplier Evaluation ------------
825: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
826: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
827: ------------------------------------------------------------------
821: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
822: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
823: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
824: ------------ Supplier Management: Supplier Evaluation ------------
825: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
826: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
827: ------------------------------------------------------------------
828: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
829: x_rebid_flag OUT NOCOPY VARCHAR2
822: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
823: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
824: ------------ Supplier Management: Supplier Evaluation ------------
825: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
826: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
827: ------------------------------------------------------------------
828: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
829: x_rebid_flag OUT NOCOPY VARCHAR2
830: ) IS
824: ------------ Supplier Management: Supplier Evaluation ------------
825: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
826: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
827: ------------------------------------------------------------------
828: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
829: x_rebid_flag OUT NOCOPY VARCHAR2
830: ) IS
831: l_max_line_number pon_bid_item_prices.line_number%TYPE;
832: l_batch_start pon_bid_item_prices.line_number%TYPE;
845: -- Add evaluator_id and evaluation_flag to the query --
846: --------------------------------------------------------
847: SELECT bh.bid_number, 'Y'
848: INTO x_prev_bid_number, x_rebid_flag
849: FROM pon_bid_headers bh
850: WHERE bh.auction_header_id = p_auc_header_id
851: AND bh.trading_partner_id = p_tpid
852: AND bh.trading_partner_contact_id =
853: (SELECT trading_partner_contact_id
850: WHERE bh.auction_header_id = p_auc_header_id
851: AND bh.trading_partner_id = p_tpid
852: AND bh.trading_partner_contact_id =
853: (SELECT trading_partner_contact_id
854: FROM pon_bid_headers bh2
855: WHERE bh2.bid_number = p_draft_bid_num)
856: AND bh.vendor_site_id = p_vensid
857: AND bh.bid_status = 'ACTIVE'
858: AND nvl(bh.evaluator_id, -1) = nvl(p_evaluator_id, -1)
860: AND rownum = 1
861: ORDER BY bh.publish_date DESC;
862:
863: -- Update old_bid_number to new source bid
864: UPDATE pon_bid_headers bh
865: SET bh.old_bid_number = x_prev_bid_number
866: WHERE bh.bid_number = p_draft_bid_num;
867:
868: -- START BATCHING
930: -- No ACTIVE bids on the current amendment
931: WHEN NO_DATA_FOUND THEN
932: SELECT bh.old_bid_number
933: INTO x_prev_bid_number
934: FROM pon_bid_headers bh
935: WHERE bh.bid_number = p_draft_bid_num;
936: x_rebid_flag := 'N';
937:
938: END handle_proxy;
962: -- ======================================================================
963: PROCEDURE insert_into_bid_header
964: (
965: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
966: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
967: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
963: PROCEDURE insert_into_bid_header
964: (
965: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
966: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
967: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
964: (
965: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
966: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
967: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
965: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
966: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
967: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
966: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
967: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
967: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
970: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
978: ----------- Supplier Management: Supplier Evaluation -----------
971: p_userid IN pon_bid_headers.created_by%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
978: ----------- Supplier Management: Supplier Evaluation -----------
979: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
972: p_venid IN pon_bid_headers.vendor_id%TYPE,
973: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
974: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
978: ----------- Supplier Management: Supplier Evaluation -----------
979: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
980: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
975: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
978: ----------- Supplier Management: Supplier Evaluation -----------
979: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
980: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
981: ----------------------------------------------------------------
982: p_rebid_flag IN VARCHAR2,
983: p_prev_bid_disq IN VARCHAR2,
976: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
977: p_buyer_user IN VARCHAR2,
978: ----------- Supplier Management: Supplier Evaluation -----------
979: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
980: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
981: ----------------------------------------------------------------
982: p_rebid_flag IN VARCHAR2,
983: p_prev_bid_disq IN VARCHAR2,
984: p_prev_bid_wthd IN VARCHAR2,
981: ----------------------------------------------------------------
982: p_rebid_flag IN VARCHAR2,
983: p_prev_bid_disq IN VARCHAR2,
984: p_prev_bid_wthd IN VARCHAR2,
985: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
986: ) IS
987: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
988: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
989: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
1008: , l_two_part_flag
1009: , l_technical_evaluation_status
1010: -------------------------------------------------------
1011: FROM PON_AUCTION_HEADERS_ALL pah,
1012: PON_BID_HEADERS pbh
1013: WHERE pah.auction_header_id = pbh.auction_header_id
1014: AND pbh.bid_number = p_source_bid_num;
1015: END IF;
1016:
1014: AND pbh.bid_number = p_source_bid_num;
1015: END IF;
1016:
1017: -- Generate next bid number
1018: SELECT pon_bid_headers_s.nextval INTO x_bid_number
1019: FROM dual;
1020:
1021: INSERT INTO pon_bid_headers
1022: (
1017: -- Generate next bid number
1018: SELECT pon_bid_headers_s.nextval INTO x_bid_number
1019: FROM dual;
1020:
1021: INSERT INTO pon_bid_headers
1022: (
1023: BID_NUMBER,
1024: AUCTION_HEADER_ID,
1025: BIDDERS_BID_NUMBER,
1158: ---------------- Supplier Management: Supplier Evaluation ----------------
1159: ,decode(p_eval_flag, 'Y', p_evaluator_id, null) -- EVALUATOR_ID
1160: ,p_eval_flag -- EVALUATION_FLAG
1161: --------------------------------------------------------------------------
1162: FROM pon_auction_headers_all ah, pon_bid_headers bh
1163: WHERE ah.auction_header_id = p_auc_header_id
1164: AND bh.bid_number (+) = p_source_bid_num
1165: AND ah.auction_header_id >= bh.auction_header_id (+));
1166:
1182: -- ======================================================================
1183: PROCEDURE insert_into_bid_items
1184: (
1185: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1186: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1187: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1188: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1189: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1190: p_userid IN pon_bid_headers.created_by%TYPE,
1183: PROCEDURE insert_into_bid_items
1184: (
1185: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1186: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1187: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1188: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1189: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1190: p_userid IN pon_bid_headers.created_by%TYPE,
1191: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1184: (
1185: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1186: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1187: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1188: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1189: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1190: p_userid IN pon_bid_headers.created_by%TYPE,
1191: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1192: p_rebid_flag IN VARCHAR2,
1185: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1186: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1187: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1188: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1189: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1190: p_userid IN pon_bid_headers.created_by%TYPE,
1191: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1192: p_rebid_flag IN VARCHAR2,
1193: p_restricted_flag IN VARCHAR2,
1186: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1187: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1188: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1189: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1190: p_userid IN pon_bid_headers.created_by%TYPE,
1191: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1192: p_rebid_flag IN VARCHAR2,
1193: p_restricted_flag IN VARCHAR2,
1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1187: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1188: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1189: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
1190: p_userid IN pon_bid_headers.created_by%TYPE,
1191: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1192: p_rebid_flag IN VARCHAR2,
1193: p_restricted_flag IN VARCHAR2,
1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1195: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1192: p_rebid_flag IN VARCHAR2,
1193: p_restricted_flag IN VARCHAR2,
1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1195: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1196: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1197: ) IS
1198: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
1199: l_blanket VARCHAR2(1);
1200: l_full_qty VARCHAR2(1);
1582: IF (l_enforce_prevrnd_price_flag = 'Y' AND p_rebid_flag <> 'Y') THEN
1583: BEGIN
1584: SELECT MAX(bid_number)
1585: INTO l_prev_rnd_active_bid_number
1586: FROM pon_bid_headers bh
1587: WHERE bh.auction_header_id = l_auction_header_id_prev_round
1588: AND bh.trading_partner_id = p_tpid
1589: AND bh.trading_partner_contact_id = p_tpcid
1590: AND bh.bid_status ='ACTIVE'
1707: -- ======================================================================
1708: PROCEDURE insert_into_header_attributes
1709: (
1710: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1711: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1712: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1713: p_userid IN pon_bid_headers.created_by%TYPE,
1714: ----------- Supplier Management: Supplier Evaluation -----------
1715: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
1708: PROCEDURE insert_into_header_attributes
1709: (
1710: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1711: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1712: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1713: p_userid IN pon_bid_headers.created_by%TYPE,
1714: ----------- Supplier Management: Supplier Evaluation -----------
1715: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
1716: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
1709: (
1710: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1711: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1712: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1713: p_userid IN pon_bid_headers.created_by%TYPE,
1714: ----------- Supplier Management: Supplier Evaluation -----------
1715: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
1716: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
1717: ----------------------------------------------------------------
1711: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1712: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1713: p_userid IN pon_bid_headers.created_by%TYPE,
1714: ----------- Supplier Management: Supplier Evaluation -----------
1715: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
1716: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
1717: ----------------------------------------------------------------
1718: p_rebid_flag IN VARCHAR2
1719: ) IS
1712: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1713: p_userid IN pon_bid_headers.created_by%TYPE,
1714: ----------- Supplier Management: Supplier Evaluation -----------
1715: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
1716: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
1717: ----------------------------------------------------------------
1718: p_rebid_flag IN VARCHAR2
1719: ) IS
1720:
1837: -- ======================================================================
1838: PROCEDURE insert_into_line_attributes
1839: (
1840: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1841: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1842: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1843: p_userid IN pon_bid_headers.created_by%TYPE,
1844: p_rebid_flag IN VARCHAR2,
1845: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1838: PROCEDURE insert_into_line_attributes
1839: (
1840: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1841: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1842: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1843: p_userid IN pon_bid_headers.created_by%TYPE,
1844: p_rebid_flag IN VARCHAR2,
1845: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1846: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1839: (
1840: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1841: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1842: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1843: p_userid IN pon_bid_headers.created_by%TYPE,
1844: p_rebid_flag IN VARCHAR2,
1845: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1846: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1847: ) IS
1918: -- ======================================================================
1919: PROCEDURE insert_into_price_factors
1920: (
1921: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1922: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1923: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1924: p_userid IN pon_bid_headers.created_by%TYPE,
1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1926: p_rebid_flag IN VARCHAR2,
1919: PROCEDURE insert_into_price_factors
1920: (
1921: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1922: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1923: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1924: p_userid IN pon_bid_headers.created_by%TYPE,
1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1926: p_rebid_flag IN VARCHAR2,
1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1920: (
1921: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1922: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1923: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1924: p_userid IN pon_bid_headers.created_by%TYPE,
1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1926: p_rebid_flag IN VARCHAR2,
1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1926: p_rebid_flag IN VARCHAR2,
1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1929: ) IS
1930: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1931: l_curr_prec fnd_currencies.precision%TYPE;
1932: l_rate pon_bid_headers.rate%TYPE;
1933: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1934: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1929: ) IS
1930: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1931: l_curr_prec fnd_currencies.precision%TYPE;
1932: l_rate pon_bid_headers.rate%TYPE;
1933: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1934: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1935: BEGIN
1936:
1940: bh.rate
1941: INTO l_price_prec,
1942: l_curr_prec,
1943: l_rate
1944: FROM pon_bid_headers bh,
1945: fnd_currencies cu
1946: WHERE bh.bid_number = p_bid_number
1947: AND cu.currency_code = bh.bid_currency_code;
1948:
2080: -- ======================================================================
2081: PROCEDURE insert_into_price_tiers
2082: (
2083: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2084: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2085: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2086: p_userid IN pon_bid_headers.created_by%TYPE,
2087: p_rebid_flag IN VARCHAR2,
2088: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2081: PROCEDURE insert_into_price_tiers
2082: (
2083: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2084: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2085: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2086: p_userid IN pon_bid_headers.created_by%TYPE,
2087: p_rebid_flag IN VARCHAR2,
2088: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2089: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2082: (
2083: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2084: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2085: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2086: p_userid IN pon_bid_headers.created_by%TYPE,
2087: p_rebid_flag IN VARCHAR2,
2088: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2089: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2090: ) IS
2255: -- ======================================================================
2256: PROCEDURE insert_into_price_diff
2257: (
2258: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2259: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2260: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2261: p_userid IN pon_bid_headers.created_by%TYPE,
2262: p_rebid_flag IN VARCHAR2,
2263: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2256: PROCEDURE insert_into_price_diff
2257: (
2258: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2259: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2260: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2261: p_userid IN pon_bid_headers.created_by%TYPE,
2262: p_rebid_flag IN VARCHAR2,
2263: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2264: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2257: (
2258: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2259: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2260: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2261: p_userid IN pon_bid_headers.created_by%TYPE,
2262: p_rebid_flag IN VARCHAR2,
2263: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2264: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2265: ) IS
2366: -- Create and default payments
2367: PROCEDURE insert_into_payments
2368: (
2369: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2370: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2371: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2372: p_copy_only_from_auc IN VARCHAR2,
2373: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2374: p_userid IN pon_bid_headers.created_by%TYPE,
2367: PROCEDURE insert_into_payments
2368: (
2369: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2370: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2371: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2372: p_copy_only_from_auc IN VARCHAR2,
2373: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2374: p_userid IN pon_bid_headers.created_by%TYPE,
2375: p_rebid_flag IN VARCHAR2,
2370: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2371: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2372: p_copy_only_from_auc IN VARCHAR2,
2373: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2374: p_userid IN pon_bid_headers.created_by%TYPE,
2375: p_rebid_flag IN VARCHAR2,
2376: p_new_round_or_amended IN VARCHAR2,
2377: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2378: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2663: -- COMMENT: copies over line attachments from source bid
2664: -- ======================================================================
2665: PROCEDURE copy_line_attachments
2666: (
2667: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2668: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2669: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2670: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2671: p_userid IN pon_bid_headers.created_by%TYPE,
2664: -- ======================================================================
2665: PROCEDURE copy_line_attachments
2666: (
2667: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2668: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2669: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2670: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2671: p_userid IN pon_bid_headers.created_by%TYPE,
2672: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2665: PROCEDURE copy_line_attachments
2666: (
2667: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2668: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2669: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2670: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2671: p_userid IN pon_bid_headers.created_by%TYPE,
2672: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2673: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2666: (
2667: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2668: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2669: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2670: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2671: p_userid IN pon_bid_headers.created_by%TYPE,
2672: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2673: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2674: p_to_category_id IN NUMBER,
2667: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
2668: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2669: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2670: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2671: p_userid IN pon_bid_headers.created_by%TYPE,
2672: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2673: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2674: p_to_category_id IN NUMBER,
2675: p_change_categ_id IN VARCHAR2
2733: -- ======================================================================
2734: PROCEDURE populate_has_bid_flag
2735: (
2736: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2737: p_bid_number IN pon_bid_headers.bid_number%TYPE
2738: ) IS
2739: l_full_qty_reqd VARCHAR2(1);
2740: BEGIN
2741:
2847: -- ======================================================================
2848: PROCEDURE create_new_draft_bid
2849: (
2850: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2851: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2852: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2848: PROCEDURE create_new_draft_bid
2849: (
2850: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2851: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2852: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2849: (
2850: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2851: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2852: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2850: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2851: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2852: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2851: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2852: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2852: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2855: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2863: ----------- Supplier Management: Supplier Evaluation -----------
2856: p_userid IN pon_bid_headers.created_by%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2863: ----------- Supplier Management: Supplier Evaluation -----------
2864: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
2857: p_venid IN pon_bid_headers.vendor_id%TYPE,
2858: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
2859: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2863: ----------- Supplier Management: Supplier Evaluation -----------
2864: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
2865: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
2860: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2863: ----------- Supplier Management: Supplier Evaluation -----------
2864: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
2865: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
2866: ----------------------------------------------------------------
2867: p_new_round_or_amended IN VARCHAR2,
2868: p_rebid_flag IN VARCHAR2,
2861: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
2862: p_buyer_user IN VARCHAR2,
2863: ----------- Supplier Management: Supplier Evaluation -----------
2864: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
2865: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
2866: ----------------------------------------------------------------
2867: p_new_round_or_amended IN VARCHAR2,
2868: p_rebid_flag IN VARCHAR2,
2869: p_prev_bid_disq IN VARCHAR2,
2867: p_new_round_or_amended IN VARCHAR2,
2868: p_rebid_flag IN VARCHAR2,
2869: p_prev_bid_disq IN VARCHAR2,
2870: p_prev_bid_wthd IN VARCHAR2,
2871: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
2872: x_return_status OUT NOCOPY NUMBER,
2873: x_return_code OUT NOCOPY VARCHAR2
2874: ) IS
2875: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
2874: ) IS
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;
2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2888: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2889: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2890: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2891: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2892:
2893:
2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2888: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2889: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2890: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2891: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2892:
2893:
2894: -- Two-part RFQ related variables
2908:
2909: l_order_type_lookup_type pon_auction_item_prices_all.order_type_lookup_code%TYPE;
2910: l_auc_quantity pon_auction_item_prices_all.quantity%TYPE;
2911:
2912: l_rate PON_BID_HEADERS.RATE%TYPE;
2913: l_tp_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
2914: l_vendor_site_id PON_BID_HEADERS.VENDOR_SITE_ID%TYPE;
2915: l_precision PON_BID_HEADERS.NUMBER_PRICE_DECIMALS%TYPE;
2916:
2909: l_order_type_lookup_type pon_auction_item_prices_all.order_type_lookup_code%TYPE;
2910: l_auc_quantity pon_auction_item_prices_all.quantity%TYPE;
2911:
2912: l_rate PON_BID_HEADERS.RATE%TYPE;
2913: l_tp_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
2914: l_vendor_site_id PON_BID_HEADERS.VENDOR_SITE_ID%TYPE;
2915: l_precision PON_BID_HEADERS.NUMBER_PRICE_DECIMALS%TYPE;
2916:
2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD
2910: l_auc_quantity pon_auction_item_prices_all.quantity%TYPE;
2911:
2912: l_rate PON_BID_HEADERS.RATE%TYPE;
2913: l_tp_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
2914: l_vendor_site_id PON_BID_HEADERS.VENDOR_SITE_ID%TYPE;
2915: l_precision PON_BID_HEADERS.NUMBER_PRICE_DECIMALS%TYPE;
2916:
2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD
2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;
2911:
2912: l_rate PON_BID_HEADERS.RATE%TYPE;
2913: l_tp_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
2914: l_vendor_site_id PON_BID_HEADERS.VENDOR_SITE_ID%TYPE;
2915: l_precision PON_BID_HEADERS.NUMBER_PRICE_DECIMALS%TYPE;
2916:
2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD
2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;
2919:
3016: IF (p_source_bid_num IS NOT null) THEN
3017:
3018: SELECT bh.auction_header_id
3019: INTO l_source_header_id
3020: FROM pon_bid_headers bh
3021: WHERE bh.bid_number = p_source_bid_num;
3022:
3023: -- get value of two-part flags for current and prev rounds
3024: select decode(pah.auction_header_id_prev_round, null, 'N', 'Y'),
3056: log_message(l_module, 'Two-Part related variables: l_to_category_id: ' || l_to_category_id || '; l_categ_id_supp_tech: '||l_categ_id_supp_tech||'; l_categ_id_supp: ' || l_categ_id_supp);
3057:
3058: -- Copy header attachments to new target category
3059: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
3060: (x_from_entity_name => 'PON_BID_HEADERS',
3061: x_from_pk1_value => l_source_header_id,
3062: x_from_pk2_value => p_source_bid_num,
3063: x_to_entity_name => 'PON_BID_HEADERS',
3064: x_to_pk1_value => p_auc_header_id,
3059: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
3060: (x_from_entity_name => 'PON_BID_HEADERS',
3061: x_from_pk1_value => l_source_header_id,
3062: x_from_pk2_value => p_source_bid_num,
3063: x_to_entity_name => 'PON_BID_HEADERS',
3064: x_to_pk1_value => p_auc_header_id,
3065: x_to_pk2_value => x_bid_number,
3066: x_created_by => p_userid,
3067: x_last_update_login => fnd_global.login_id,
3069:
3070: ELSE
3071: -- Copy header level attachments without changing categories
3072: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
3073: (x_from_entity_name => 'PON_BID_HEADERS',
3074: x_from_pk1_value => l_source_header_id,
3075: x_from_pk2_value => p_source_bid_num,
3076: x_to_entity_name => 'PON_BID_HEADERS',
3077: x_to_pk1_value => p_auc_header_id,
3072: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
3073: (x_from_entity_name => 'PON_BID_HEADERS',
3074: x_from_pk1_value => l_source_header_id,
3075: x_from_pk2_value => p_source_bid_num,
3076: x_to_entity_name => 'PON_BID_HEADERS',
3077: x_to_pk1_value => p_auc_header_id,
3078: x_to_pk2_value => x_bid_number,
3079: x_created_by => p_userid,
3080: x_last_update_login => fnd_global.login_id);
3110: bh.surrog_bid_flag
3111: INTO g_curr_prec,
3112: g_bid_rate,
3113: l_surrog_bid_flag
3114: FROM pon_bid_headers bh,
3115: fnd_currencies cu
3116: WHERE bh.bid_number = x_bid_number
3117: AND cu.currency_code = bh.bid_currency_code;
3118:
3334: IF(p_source_bid_num IS NOT NULL) THEN
3335:
3336: SELECT RATE, TRADING_PARTNER_ID, VENDOR_SITE_ID, NUMBER_PRICE_DECIMALS
3337: INTO l_rate, l_tp_id, l_vendor_site_id, l_precision
3338: FROM PON_BID_HEADERS
3339: WHERE BID_NUMBER = x_bid_number
3340: AND AUCTION_HEADER_ID = p_auc_header_id
3341: AND BID_STATUS = 'DRAFT';
3342:
3514: /* Offer Enhancement Chnages Start */
3515:
3516: select bid_number,nvl(surrog_bid_flag, 'N')
3517: into l_other_draft_bid_number,l_surrogate_bid_flag
3518: from pon_bid_headers
3519: where auction_header_id = p_auc_header_id
3520: and bid_number <> x_bid_number
3521: and bid_status = 'DRAFT'
3522: and trading_partner_id = p_tpid
3570: IF p_source_bid_num IS NOT null AND l_allow_unsol_lines = 'Y' THEN
3571:
3572: SELECT Decode(pbh.auction_header_id, p_auc_header_id, 'Y', 'N')
3573: INTO l_can_copy_unsol_lines
3574: FROM pon_bid_headers pbh
3575: WHERE pbh.bid_number = p_source_bid_num;
3576:
3577: IF l_can_copy_unsol_lines = 'Y' THEN
3578: -- Call the copy api.
3590: -- END BATCHING
3591:
3592: -- Populate header level display_price_factors_flag
3593: -- It is 'Y' if any line has the line level flag set
3594: UPDATE pon_bid_headers bh
3595: SET bh.display_price_factors_flag =
3596: nvl((SELECT 'Y'
3597: FROM pon_bid_item_prices bl
3598: WHERE bl.bid_number = bh.bid_number
3614: -- As such, they need to be expanded to include them
3615: -- ======================================================================
3616: PROCEDURE expand_draft
3617: (
3618: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3619: x_rebid_flag OUT NOCOPY VARCHAR2
3620: ) IS
3621: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3622:
3617: (
3618: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3619: x_rebid_flag OUT NOCOPY VARCHAR2
3620: ) IS
3621: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3622:
3623: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3624: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3625: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3621: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3622:
3623: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3624: l_auctpid pon_auction_headers_all.trading_partner_id%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;
3622:
3623: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3624: l_auctpid pon_auction_headers_all.trading_partner_id%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);
3623: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3624: l_auctpid pon_auction_headers_all.trading_partner_id%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);
3624: l_auctpid pon_auction_headers_all.trading_partner_id%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);
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;
3634: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3635: l_curr_prec fnd_currencies.precision%TYPE;
3636:
3637: l_max_line_number pon_bid_item_prices.line_number%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;
3634: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3635: l_curr_prec fnd_currencies.precision%TYPE;
3636:
3637: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3638: l_batch_start pon_bid_item_prices.line_number%TYPE;
3664: l_userid,
3665: l_rate,
3666: l_price_prec,
3667: l_curr_prec
3668: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu
3669: WHERE bh.bid_number = p_bid_number
3670: AND ah.auction_header_id = bh.auction_header_id
3671: AND cu.currency_code = bh.bid_currency_code;
3672:
3695: -- Since there can only exist a single ACTIVE bid on an amendment for
3696: -- a particular user on a site, we use the rownum = 1 optimisation
3697: SELECT bh.bid_number, 'Y'
3698: INTO l_source_bid_num, x_rebid_flag
3699: FROM pon_bid_headers bh
3700: WHERE bh.auction_header_id = l_auc_header_id
3701: AND bh.trading_partner_id = l_tpid
3702: AND bh.trading_partner_contact_id = l_tpcid
3703: AND bh.vendor_site_id = l_vensid
3771: -- END BATCHING
3772:
3773: -- Populate header level display_price_factors_flag
3774: -- It is 'Y' if any line has the line level flag set
3775: UPDATE pon_bid_headers bh
3776: SET bh.display_price_factors_flag =
3777: nvl((SELECT 'Y'
3778: FROM pon_bid_item_prices bl
3779: WHERE bl.bid_number = bh.bid_number
3786: (l_auc_header_id,
3787: p_bid_number);
3788:
3789: /* once we have finished upgrading the draft, reset the flag to Y */
3790: update pon_bid_headers
3791: set rel12_draft_flag = 'Y'
3792: where bid_number = p_bid_number;
3793:
3794: -- handle_proxy will be called in check_and_load_bid
3807: -- COMMENT: If the bid is not locked by another user, it is locked.
3808: -- ======================================================================
3809: PROCEDURE lock_draft
3810: (
3811: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3812: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3813: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3814: x_return_status OUT NOCOPY NUMBER,
3815: x_return_code OUT NOCOPY VARCHAR2
3808: -- ======================================================================
3809: PROCEDURE lock_draft
3810: (
3811: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3812: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3813: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3814: x_return_status OUT NOCOPY NUMBER,
3815: x_return_code OUT NOCOPY VARCHAR2
3816: ) IS
3809: PROCEDURE lock_draft
3810: (
3811: p_bid_number IN pon_bid_headers.bid_number%TYPE,
3812: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3813: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3814: x_return_status OUT NOCOPY NUMBER,
3815: x_return_code OUT NOCOPY VARCHAR2
3816: ) IS
3817: l_draft_locked pon_bid_headers.draft_locked%TYPE;
3813: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3814: x_return_status OUT NOCOPY NUMBER,
3815: x_return_code OUT NOCOPY VARCHAR2
3816: ) IS
3817: l_draft_locked pon_bid_headers.draft_locked%TYPE;
3818: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3819: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3820: BEGIN
3821:
3814: x_return_status OUT NOCOPY NUMBER,
3815: x_return_code OUT NOCOPY VARCHAR2
3816: ) IS
3817: l_draft_locked pon_bid_headers.draft_locked%TYPE;
3818: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3819: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3820: BEGIN
3821:
3822: -- pull up draft lock info
3815: x_return_code OUT NOCOPY VARCHAR2
3816: ) IS
3817: l_draft_locked pon_bid_headers.draft_locked%TYPE;
3818: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3819: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3820: BEGIN
3821:
3822: -- pull up draft lock info
3823: SELECT draft_locked, draft_locked_by, draft_locked_by_contact_id
3821:
3822: -- pull up draft lock info
3823: SELECT draft_locked, draft_locked_by, draft_locked_by_contact_id
3824: INTO l_draft_locked, l_tpid, l_tpcid
3825: FROM pon_bid_headers
3826: WHERE bid_number = p_bid_number;
3827:
3828: -- If the draft is locked by another user, return an error
3829: IF (l_draft_locked = 'Y' AND (p_tpid <> l_tpid OR p_tpcid <> l_tpcid)) THEN
3834:
3835: -- If the draft is not locked, lock it
3836: ELSIF (l_draft_locked = 'N') THEN
3837:
3838: UPDATE pon_bid_headers
3839: SET draft_locked = 'Y',
3840: draft_locked_by = p_tpid,
3841: draft_locked_by_contact_id = p_tpcid,
3842: draft_locked_date = sysdate
3986: -- ======================================================================
3987: PROCEDURE is_bidding_allowed
3988: (
3989: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3990: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3991: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3992: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3993: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3994: p_buyer_user IN VARCHAR2,
3987: PROCEDURE is_bidding_allowed
3988: (
3989: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3990: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3991: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3992: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3993: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3994: p_buyer_user IN VARCHAR2,
3995: ---------- Supplier Management: Supplier Evaluation ----------
3988: (
3989: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3990: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3991: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3992: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3993: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3994: p_buyer_user IN VARCHAR2,
3995: ---------- Supplier Management: Supplier Evaluation ----------
3996: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
3989: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3990: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3991: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3992: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3993: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3994: p_buyer_user IN VARCHAR2,
3995: ---------- Supplier Management: Supplier Evaluation ----------
3996: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
3997: p_eval_flag IN VARCHAR2,
3992: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3993: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
3994: p_buyer_user IN VARCHAR2,
3995: ---------- Supplier Management: Supplier Evaluation ----------
3996: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
3997: p_eval_flag IN VARCHAR2,
3998: --------------------------------------------------------------
3999: p_action_code IN VARCHAR2,
4000: x_return_status OUT NOCOPY NUMBER,
4015: l_has_surrog_flag VARCHAR2(1);
4016: l_auction_paused VARCHAR2(1);
4017: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
4018: l_supp_end_date TIMESTAMP;
4019: l_eval_flag pon_bid_headers.evaluation_flag%TYPE := nvl(p_eval_flag,'N');
4020:
4021: BEGIN
4022:
4023: ----------------------- Supplier Management: Supplier Evaluation -----------------------
4113: if (p_buyer_user='Y')
4114: then
4115: SELECT bid_number
4116: INTO l_bid_number
4117: FROM pon_bid_headers bh
4118: WHERE bh.auction_header_id = p_auc_header_id
4119: AND bh.trading_partner_id = p_tpid
4120: --AND bh.trading_partner_contact_id = p_tpcid -- Modified for ER: Supplier Management: Supplier Evaluation
4121: AND ((l_eval_flag = 'N' AND bh.trading_partner_contact_id = p_tpcid) OR
4127: AND ROWNUM = 1; -- Multiple Active Offers : Multiple draft offers may exist, just get the first draft offer.
4128: else
4129: SELECT bid_number
4130: INTO l_bid_number
4131: FROM pon_bid_headers bh
4132: WHERE bh.auction_header_id = p_auc_header_id
4133: AND bh.trading_partner_id = p_tpid
4134: --AND bh.trading_partner_contact_id = p_tpcid -- Modified for ER: Supplier Management: Supplier Evaluation
4135: AND ((l_eval_flag = 'N' AND bh.trading_partner_contact_id = p_tpcid) OR
4153: if (p_buyer_user='Y')
4154: then
4155: SELECT nvl(pov.end_date_active, sysdate)
4156: INTO l_supp_end_date
4157: FROM pon_bid_headers bh, po_vendors pov
4158: WHERE bh.auction_header_id = p_auc_header_id
4159: AND bh.trading_partner_id = p_tpid
4160: --AND bh.trading_partner_contact_id = p_tpcid -- Modified for ER: Supplier Management: Supplier Evaluation
4161: AND ((l_eval_flag = 'N' AND bh.trading_partner_contact_id = p_tpcid) OR
4168: AND ROWNUM = 1; -- Multiple Active Offers : Multiple draft offers may exist, just get the first draft offer.
4169: else
4170: SELECT nvl(pov.end_date_active, sysdate)
4171: INTO l_supp_end_date
4172: FROM pon_bid_headers bh, po_vendors pov
4173: WHERE bh.auction_header_id = p_auc_header_id
4174: AND bh.trading_partner_id = p_tpid
4175: --AND bh.trading_partner_contact_id = p_tpcid -- Modified for ER: Supplier Management: Supplier Evaluation
4176: AND ((l_eval_flag = 'N' AND bh.trading_partner_contact_id = p_tpcid) OR
4194: IF (l_supp_end_date IS null) THEN
4195: BEGIN
4196: SELECT sysdate
4197: INTO l_supp_end_date
4198: FROM pon_bid_headers bh, pos_supplier_registrations psr
4199: WHERE bh.auction_header_id = p_auc_header_id
4200: AND bh.trading_partner_id = p_tpid
4201: AND psr.supplier_reg_id = bh.trading_partner_id
4202: AND psr.registration_status in ('RIF_SUPPLIER', 'PENDING_APPROVAL') -- Bug 9037236
4263:
4264: -- Do an existence check
4265: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
4266: INTO l_has_bid_flag
4267: FROM pon_bid_headers
4268: WHERE auction_header_id = p_auc_header_id
4269: AND trading_partner_id = p_tpid
4270: AND vendor_site_id = p_vensid
4271: AND bid_status = 'ACTIVE'
4286: -- time. We will have this check during submit bid anyways
4287:
4288: SELECT decode(count(auction_header_id), 0, 'N', 'Y')
4289: INTO l_has_draft_flag
4290: FROM pon_bid_headers
4291: WHERE auction_header_id = p_auc_header_id
4292: AND trading_partner_id = p_tpid
4293: AND trading_partner_contact_id <> p_tpcid
4294: AND vendor_site_id = p_vensid
4318: -- Check if a buyer/supplier has already placed a bid on the round
4319: -- I.e. check for surrog bid if supplier, or a supplier bid if buyer
4320: SELECT decode(count(bh.auction_header_id), 0, 'N', 'Y')
4321: INTO l_has_surrog_flag
4322: FROM pon_bid_headers bh, pon_auction_headers_all ah
4323: WHERE ah.auction_header_id_orig_amend = l_orig_amend_id
4324: AND bh.auction_header_id = ah.auction_header_id
4325: AND bh.trading_partner_id = p_tpid
4326: AND bh.trading_partner_contact_id = p_tpcid
4373: -- ======================================================================
4374: PROCEDURE get_source_bid
4375: (
4376: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4377: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4378: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4379: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4380: ---------- Supplier Management: Supplier Evaluation ----------
4381: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4374: PROCEDURE get_source_bid
4375: (
4376: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4377: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4378: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4379: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4380: ---------- Supplier Management: Supplier Evaluation ----------
4381: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4382: p_eval_flag IN VARCHAR2,
4375: (
4376: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4377: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4378: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4379: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4380: ---------- Supplier Management: Supplier Evaluation ----------
4381: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4382: p_eval_flag IN VARCHAR2,
4383: --------------------------------------------------------------
4377: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4378: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4379: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4380: ---------- Supplier Management: Supplier Evaluation ----------
4381: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4382: p_eval_flag IN VARCHAR2,
4383: --------------------------------------------------------------
4384: p_action_code IN VARCHAR2,
4385: p_buyer_user IN VARCHAR2,
4384: p_action_code IN VARCHAR2,
4385: p_buyer_user IN VARCHAR2,
4386:
4387: x_rebid_flag OUT NOCOPY VARCHAR2,
4388: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4389: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4390: x_amend_bid_def OUT NOCOPY VARCHAR2,
4391: x_round_bid_def OUT NOCOPY VARCHAR2,
4392: x_prev_bid_disq OUT NOCOPY VARCHAR2,
4385: p_buyer_user IN VARCHAR2,
4386:
4387: x_rebid_flag OUT NOCOPY VARCHAR2,
4388: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4389: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4390: x_amend_bid_def OUT NOCOPY VARCHAR2,
4391: x_round_bid_def OUT NOCOPY VARCHAR2,
4392: x_prev_bid_disq OUT NOCOPY VARCHAR2,
4393: x_prev_bid_wthd OUT NOCOPY VARCHAR2,
4396: x_return_code OUT NOCOPY VARCHAR2
4397: ) IS
4398: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
4399: l_status_order NUMBER;
4400: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
4401:
4402: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
4403: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
4404:
4403: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
4404:
4405: l_terms_cond_apply VARCHAR2(1);
4406:
4407: l_ignored_return pon_bid_headers.bid_number%TYPE;
4408: -- for the bug 13984944
4409: l_org_contract_status pon_contracts.contract_status%TYPE;
4410: l_enabled_flag pon_contracts.enabled_flag%TYPE;
4411: l_org_id pon_auction_headers_all.org_id%TYPE;
4426: decode(bh.bid_status, 'DISQUALIFIED', 'Y', 'N') prev_bid_disq,
4427: nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag,
4428: decode(bh.bid_status,'ARCHIVED',decode(bh.withdraw_reason,null,'N','Y'),'N') prev_bid_wthd,
4429: bh.withdraw_reason
4430: FROM pon_bid_headers bh, pon_auction_headers_all ah
4431: WHERE
4432: -- look at all amendments on the current round
4433: (ah.auction_header_id_orig_amend = l_orig_amend_id
4434: -- look at all amendments on the previous round
4466: nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag,
4467:
4468: decode(bh.bid_status,'ARCHIVED',decode(bh.withdraw_reason,null,'N','Y'),'N') prev_bid_wthd,
4469: bh.withdraw_reason
4470: FROM pon_bid_headers bh, pon_auction_headers_all ah
4471: WHERE
4472: -- look at all amendments on the current round
4473: (ah.auction_header_id_orig_amend = l_orig_amend_id
4474: -- look at all amendments on the previous round
4500: 'ACTIVE', 'SINGLE_BEST_BID'),
4501: decode(bh.bid_status, 'DRAFT', 'OTHER_USERS_DRAFT',
4502: 'ACTIVE', 'OTHER_USERS_ACTIVE')),
4503: 'OTHER_USERS_PREV_ROUND') return_code
4504: FROM pon_bid_headers bh, pon_auction_headers_all ah
4505: WHERE
4506: -- look at the current amendment, remove DRAFT status as part of Offer Enhancement ER
4507: -- Offer Enhancement : We need to consider draft bids
4508: (ah.auction_header_id = p_auc_header_id
4575:
4576: -- draft is on a previous amendment/round
4577: ELSE
4578: -- Need to archive the previous amend/round DRAFT bid
4579: UPDATE pon_bid_headers
4580: SET bid_status = 'ARCHIVED_DRAFT',
4581: last_update_date = sysdate
4582: WHERE bid_number = x_prev_bid_number;
4583:
4612: IF (l_source_header_id = p_auc_header_id) THEN
4613:
4614: -- Update Evaluation flow
4615:
4616: UPDATE pon_bid_headers
4617: SET bid_status = 'DRAFT',
4618: last_update_date = sysdate
4619: WHERE bid_number = x_prev_bid_number;
4620:
4720: -- ======================================================================
4721: PROCEDURE create_defaulted_draft
4722: (
4723: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4724: p_source_bid IN pon_bid_headers.bid_number%TYPE,
4725: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
4726: ) IS
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4721: PROCEDURE create_defaulted_draft
4722: (
4723: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4724: p_source_bid IN pon_bid_headers.bid_number%TYPE,
4725: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
4726: ) IS
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4723: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4724: p_source_bid IN pon_bid_headers.bid_number%TYPE,
4725: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
4726: ) IS
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4724: p_source_bid IN pon_bid_headers.bid_number%TYPE,
4725: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
4726: ) IS
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4725: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
4726: ) IS
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4726: ) IS
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4728: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4729: l_tpname pon_bid_headers.trading_partner_name%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4730: l_tpcname pon_bid_headers.trading_partner_contact_name%TYPE;
4731: l_userid pon_bid_headers.created_by%TYPE;
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4738:
4732: l_venid pon_bid_headers.vendor_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4738:
4739: ---------- Supplier Management: Supplier Evaluation ----------
4740: l_evaluator_id pon_bid_headers.evaluator_id%TYPE;
4733: l_vensid pon_bid_headers.vendor_site_id%TYPE;
4734: l_venscode pon_bid_headers.vendor_site_code%TYPE;
4735: l_buyer_user VARCHAR2(1);
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4738:
4739: ---------- Supplier Management: Supplier Evaluation ----------
4740: l_evaluator_id pon_bid_headers.evaluator_id%TYPE;
4741: l_eval_flag pon_bid_headers.evaluation_flag%TYPE;
4736: l_auctpid pon_bid_headers.surrog_bid_created_tp_id%TYPE;
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4738:
4739: ---------- Supplier Management: Supplier Evaluation ----------
4740: l_evaluator_id pon_bid_headers.evaluator_id%TYPE;
4741: l_eval_flag pon_bid_headers.evaluation_flag%TYPE;
4742: --------------------------------------------------------------
4743:
4744: l_rebid_flag VARCHAR2(1);
4737: l_auctpcid pon_bid_headers.surrog_bid_created_contact_id%TYPE;
4738:
4739: ---------- Supplier Management: Supplier Evaluation ----------
4740: l_evaluator_id pon_bid_headers.evaluator_id%TYPE;
4741: l_eval_flag pon_bid_headers.evaluation_flag%TYPE;
4742: --------------------------------------------------------------
4743:
4744: l_rebid_flag VARCHAR2(1);
4745: l_prev_bid_disq VARCHAR2(1);
4793: ---- Supplier Management: Supplier Evaluation ----
4794: l_evaluator_id,
4795: l_eval_flag
4796: --------------------------------------------------
4797: FROM pon_bid_headers bh
4798: WHERE bh.bid_number = p_source_bid;
4799:
4800: -- Create the new bid
4801: create_new_draft_bid
4826:
4827: -- Update the status of the previous bid
4828: -- NOTE: if this procedure is used for cases other than spreadsheet upload
4829: -- on a DRAFT after an amendment, the status will need to be set correctly
4830: UPDATE pon_bid_headers bh
4831: SET bh.bid_status = decode('DRAFT', 'ARCHIVED_DRAFT', bh.bid_status)
4832: WHERE bh.bid_number = p_source_bid;
4833:
4834: END create_defaulted_draft;
4873: -- ======================================================================
4874: PROCEDURE check_and_load_bid
4875: (
4876: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4877: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4878: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4874: PROCEDURE check_and_load_bid
4875: (
4876: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4877: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4878: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4875: (
4876: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4877: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4878: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4876: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4877: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4878: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4877: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4878: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4878: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4881: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
4882: p_userid IN pon_bid_headers.created_by%TYPE,
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4889:
4883: p_venid IN pon_bid_headers.vendor_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4889:
4890: ----------- Supplier Management: Supplier Evaluation -----------
4891: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4884: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4885: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
4886: p_buyer_user IN VARCHAR2,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4889:
4890: ----------- Supplier Management: Supplier Evaluation -----------
4891: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4892: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
4887: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4889:
4890: ----------- Supplier Management: Supplier Evaluation -----------
4891: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4892: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
4893: ----------------------------------------------------------------
4894:
4895: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4888: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
4889:
4890: ----------- Supplier Management: Supplier Evaluation -----------
4891: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4892: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
4893: ----------------------------------------------------------------
4894:
4895: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4896: x_rebid_flag OUT NOCOPY VARCHAR2,
4891: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
4892: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
4893: ----------------------------------------------------------------
4894:
4895: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4896: x_rebid_flag OUT NOCOPY VARCHAR2,
4897: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4898: x_amend_bid_def OUT NOCOPY VARCHAR2,
4899: x_round_bid_def OUT NOCOPY VARCHAR2,
4893: ----------------------------------------------------------------
4894:
4895: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4896: x_rebid_flag OUT NOCOPY VARCHAR2,
4897: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
4898: x_amend_bid_def OUT NOCOPY VARCHAR2,
4899: x_round_bid_def OUT NOCOPY VARCHAR2,
4900: x_prev_bid_disq OUT NOCOPY VARCHAR2,
4901: x_prev_bid_wthd OUT NOCOPY VARCHAR2,
4905: p_action_code IN VARCHAR2,
4906: x_return_status OUT NOCOPY NUMBER,
4907: x_return_code OUT NOCOPY VARCHAR2
4908: ) IS
4909: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
4910: l_new_round_or_amended VARCHAR2(1);
4911:
4912: l_temp_num NUMBER;
4913: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%type;
4911:
4912: l_temp_num NUMBER;
4913: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%type;
4914: L_SURROGATE_BID_FLAG VARCHAR2(1);
4915: l_eval_flag pon_bid_headers.evaluation_flag%TYPE := nvl(p_eval_flag,'N');
4916: BEGIN
4917:
4918: -- The user indicated that they want to create a fresh bid
4919: IF (p_action_code = 'CREATE_NEW_DRAFT') THEN
4995:
4996: -- If it is a pre-release 12 draft, we need to expand it
4997: SELECT nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag
4998: INTO l_rel12_draft
4999: FROM pon_bid_headers bh
5000: WHERE bh.bid_number = p_draft_number;
5001:
5002: -- If the draft is pre-release 12 we need to fill in the missing lines
5003: IF (l_rel12_draft <> 'Y') THEN
5084:
5085: BEGIN
5086: SELECT SURROG_BID_FLAG INTO L_SURROGATE_BID_FLAG
5087: FROM
5088: PON_BID_HEADERS BH
5089: WHERE
5090: bh.auction_header_id = p_auc_header_id
5091: AND BH.BID_NUMBER = x_bid_number
5092: AND bh.trading_partner_id = p_tpid
5288: FUNCTION get_source_bid_for_spreadsheet
5289: (
5290: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
5291: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
5292: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
5293: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
5295: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
5296: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
5289: (
5290: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
5291: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
5292: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
5293: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
5295: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
5296: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
5297:
5292: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
5293: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
5295: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
5296: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
5297:
5298: ) RETURN NUMBER IS
5299:
5300: CURSOR current_amendment_bids IS
5298: ) RETURN NUMBER IS
5299:
5300: CURSOR current_amendment_bids IS
5301: select bid_number
5302: from pon_bid_headers
5303: where auction_header_id = p_auc_header_id
5304: and trading_partner_id = p_tpid
5305: and trading_partner_contact_id = p_tpcid
5306: and nvl(vendor_site_id, -1) = nvl(p_vensid, -1)
5311:
5312: CURSOR previous_amendments_bids IS
5313: select bh.bid_number
5314: from
5315: pon_bid_headers bh,
5316: pon_auction_headers_all ah
5317: where
5318: bh.auction_header_id = ah.auction_header_id
5319: and ah.auction_header_id_orig_amend = p_auc_header_id_orig_amend
5351: -- try to find an active bid from previous round
5352:
5353: select max(bid_number) prev_round_bid
5354: into x_prev_bid_number
5355: from pon_bid_headers bh,
5356: pon_auction_headers_all ah,
5357: pon_auction_headers_all ah2
5358: where bh.auction_header_id = ah.auction_header_id
5359: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
5530: )
5531: INTO l_auc_pf_unit_price
5532: FROM pon_pf_supplier_formula ppsf,
5533: pon_auction_item_prices_all aip,
5534: pon_bid_headers pbh
5535: WHERE ppsf.auction_header_id = p_auction_header_id
5536: AND ppsf.line_number = p_line_number
5537: AND ppsf.trading_partner_id = pbh.trading_partner_id
5538: AND ppsf.vendor_site_id = pbh.vendor_site_id
5620: p_auction_header_id IN NUMBER,
5621: p_bid_line_number IN NUMBER) IS
5622:
5623: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;
5624: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
5625: l_curr_prec fnd_currencies.precision%TYPE;
5626: l_rate pon_bid_headers.rate%TYPE;
5627: BEGIN
5628: SELECT bh.number_price_decimals,
5622:
5623: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;
5624: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
5625: l_curr_prec fnd_currencies.precision%TYPE;
5626: l_rate pon_bid_headers.rate%TYPE;
5627: BEGIN
5628: SELECT bh.number_price_decimals,
5629: cu.precision,
5630: bh.rate
5630: bh.rate
5631: INTO l_price_prec,
5632: l_curr_prec,
5633: l_rate
5634: FROM pon_bid_headers bh,
5635: fnd_currencies cu
5636: WHERE bh.bid_number = p_bid_number
5637: AND cu.currency_code = bh.bid_currency_code;
5638:
5801:
5802: BEGIN
5803: select auction_header_id
5804: into l_auction_header_id
5805: from pon_bid_headers
5806: where bid_number = p_bid_header_id;
5807:
5808: select contract_type,unit_price,clm_idc_type,cost_constraint,quantity,order_type_lookup_code
5809: into l_contract_type,l_unit_price,l_clm_idc_type,l_cost_constraint,l_quantity,l_order_type_lookup_code
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
6159: FROM pon_bid_headers
6160: WHERE auction_header_id = p_auction_header_id
6161: AND trading_partner_id = p_tp_id
6162: AND bid_status = 'ACTIVE')
6163: AND ROWNUM = 1;