19: -- ======================================================================
20: PROCEDURE is_bidding_allowed
21: (
22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
20: PROCEDURE is_bidding_allowed
21: (
22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
28: ----------- Supplier Management: Supplier Evaluation -----------
21: (
22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
28: ----------- Supplier Management: Supplier Evaluation -----------
29: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
22: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
28: ----------- Supplier Management: Supplier Evaluation -----------
29: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
30: p_eval_flag IN VARCHAR2,
25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
26: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
27: p_buyer_user IN VARCHAR2,
28: ----------- Supplier Management: Supplier Evaluation -----------
29: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
30: p_eval_flag IN VARCHAR2,
31: ----------------------------------------------------------------
32: p_action_code IN VARCHAR2,
33: x_return_status OUT NOCOPY NUMBER,
48: -- ======================================================================
49: PROCEDURE create_defaulted_draft
50: (
51: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
52: p_source_bid IN pon_bid_headers.bid_number%TYPE,
53: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
54: );
55:
56: -- ======================================================================
49: PROCEDURE create_defaulted_draft
50: (
51: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
52: p_source_bid IN pon_bid_headers.bid_number%TYPE,
53: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
54: );
55:
56: -- ======================================================================
57: -- PROCEDURE: CHECK_AND_LOAD_BID PUBLIC
91: -- ======================================================================
92: PROCEDURE check_and_load_bid
93: (
94: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
95: p_draft_number IN pon_bid_headers.bid_number%TYPE,
96: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
92: PROCEDURE check_and_load_bid
93: (
94: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
95: p_draft_number IN pon_bid_headers.bid_number%TYPE,
96: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
93: (
94: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
95: p_draft_number IN pon_bid_headers.bid_number%TYPE,
96: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
94: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
95: p_draft_number IN pon_bid_headers.bid_number%TYPE,
96: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
95: p_draft_number IN pon_bid_headers.bid_number%TYPE,
96: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
103: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
96: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
103: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
104: p_buyer_user IN VARCHAR2,
97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
103: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
104: p_buyer_user IN VARCHAR2,
105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
98: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
103: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
104: p_buyer_user IN VARCHAR2,
105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
106: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
99: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
100: p_userid IN pon_bid_headers.created_by%TYPE,
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
103: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
104: p_buyer_user IN VARCHAR2,
105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
106: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
107:
101: p_venid IN pon_bid_headers.vendor_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
103: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
104: p_buyer_user IN VARCHAR2,
105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
106: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
107:
108: ------------ Supplier Management: Supplier Evaluation ------------
109: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
102: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
103: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
104: p_buyer_user IN VARCHAR2,
105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
106: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
107:
108: ------------ Supplier Management: Supplier Evaluation ------------
109: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
110: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
106: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
107:
108: ------------ Supplier Management: Supplier Evaluation ------------
109: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
110: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
111: ------------------------------------------------------------------
112:
113: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
106: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
107:
108: ------------ Supplier Management: Supplier Evaluation ------------
109: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
110: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
111: ------------------------------------------------------------------
112:
113: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
114: x_rebid_flag OUT NOCOPY VARCHAR2,
109: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
110: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
111: ------------------------------------------------------------------
112:
113: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
114: x_rebid_flag OUT NOCOPY VARCHAR2,
115: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
116: x_amend_bid_def OUT NOCOPY VARCHAR2,
117: x_round_bid_def OUT NOCOPY VARCHAR2,
111: ------------------------------------------------------------------
112:
113: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
114: x_rebid_flag OUT NOCOPY VARCHAR2,
115: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
116: x_amend_bid_def OUT NOCOPY VARCHAR2,
117: x_round_bid_def OUT NOCOPY VARCHAR2,
118: x_prev_bid_disq OUT NOCOPY VARCHAR2,
119: x_prev_bid_wthd OUT NOCOPY VARCHAR2,
145: FUNCTION get_source_bid_for_spreadsheet
146: (
147: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
148: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
150: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
152: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
153: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
146: (
147: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
148: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
150: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
152: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
153: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
154:
149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
150: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
151: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
152: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
153: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
154:
155: ) RETURN NUMBER;
156:
157:
303: -- ======================================================================
304: PROCEDURE create_new_draft_bid
305: (
306: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
307: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
308: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
304: PROCEDURE create_new_draft_bid
305: (
306: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
307: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
308: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
305: (
306: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
307: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
308: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
306: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
307: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
308: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
307: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
308: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
315: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
308: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
315: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
315: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
310: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
315: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
318: p_buyer_user IN VARCHAR2,
311: p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
315: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
318: p_buyer_user IN VARCHAR2,
319: ----------- Supplier Management: Supplier Evaluation -----------
312: p_userid IN pon_bid_headers.created_by%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
315: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
318: p_buyer_user IN VARCHAR2,
319: ----------- Supplier Management: Supplier Evaluation -----------
320: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
313: p_venid IN pon_bid_headers.vendor_id%TYPE,
314: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
315: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
318: p_buyer_user IN VARCHAR2,
319: ----------- Supplier Management: Supplier Evaluation -----------
320: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
321: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
318: p_buyer_user IN VARCHAR2,
319: ----------- Supplier Management: Supplier Evaluation -----------
320: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
321: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
322: ----------------------------------------------------------------
323: p_new_round_or_amended IN VARCHAR2,
324: p_rebid_flag IN VARCHAR2,
317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
318: p_buyer_user IN VARCHAR2,
319: ----------- Supplier Management: Supplier Evaluation -----------
320: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
321: p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
322: ----------------------------------------------------------------
323: p_new_round_or_amended IN VARCHAR2,
324: p_rebid_flag IN VARCHAR2,
325: p_prev_bid_disq IN VARCHAR2,
323: p_new_round_or_amended IN VARCHAR2,
324: p_rebid_flag IN VARCHAR2,
325: p_prev_bid_disq IN VARCHAR2,
326: p_prev_bid_wthd IN VARCHAR2,
327: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
328: x_return_status OUT NOCOPY NUMBER,
329: x_return_code OUT NOCOPY VARCHAR2
330: );
331:
330: );
331:
332: PROCEDURE lock_draft
333: (
334: p_bid_number IN pon_bid_headers.bid_number%TYPE,
335: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
336: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
337: x_return_status OUT NOCOPY NUMBER,
338: x_return_code OUT NOCOPY VARCHAR2
331:
332: PROCEDURE lock_draft
333: (
334: p_bid_number IN pon_bid_headers.bid_number%TYPE,
335: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
336: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
337: x_return_status OUT NOCOPY NUMBER,
338: x_return_code OUT NOCOPY VARCHAR2
339: );
332: PROCEDURE lock_draft
333: (
334: p_bid_number IN pon_bid_headers.bid_number%TYPE,
335: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
336: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
337: x_return_status OUT NOCOPY NUMBER,
338: x_return_code OUT NOCOPY VARCHAR2
339: );
340: