DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_HEADERS

Line 23: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

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,

Line 24: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

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

Line 25: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

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,

Line 26: p_venscode IN pon_bid_headers.vendor_site_code%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,

Line 29: p_evaluator_id IN pon_bid_headers.evaluator_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,
31: ----------------------------------------------------------------
32: p_action_code IN VARCHAR2,
33: x_return_status OUT NOCOPY NUMBER,

Line 52: p_source_bid IN pon_bid_headers.bid_number%TYPE,

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: -- ======================================================================

Line 53: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE

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

Line 95: p_draft_number IN pon_bid_headers.bid_number%TYPE,

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,

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

Line 97: p_tpcid IN pon_bid_headers.trading_partner_contact_id%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,

Line 98: p_tpname IN pon_bid_headers.trading_partner_name%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,

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

Line 100: p_userid IN pon_bid_headers.created_by%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,

Line 101: p_venid IN pon_bid_headers.vendor_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,
105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,

Line 102: p_vensid IN pon_bid_headers.vendor_site_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,

Line 103: p_venscode IN pon_bid_headers.vendor_site_code%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:

Line 105: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%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:
108: ------------ Supplier Management: Supplier Evaluation ------------
109: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 106: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_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,

Line 109: p_evaluator_id IN pon_bid_headers.evaluator_id%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,

Line 110: p_eval_flag IN pon_bid_headers.evaluation_flag%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,

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

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,

Line 115: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%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,
118: x_prev_bid_disq OUT NOCOPY VARCHAR2,
119: x_prev_bid_wthd OUT NOCOPY VARCHAR2,

Line 149: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

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

Line 150: p_tpcid IN pon_bid_headers.trading_partner_contact_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:

Line 153: p_vensid IN pon_bid_headers.vendor_site_id%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:
155: ) RETURN NUMBER;
156:
157:

Line 307: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,

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,

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

Line 309: p_tpcid IN pon_bid_headers.trading_partner_contact_id%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,

Line 310: p_tpname IN pon_bid_headers.trading_partner_name%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,

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

Line 312: p_userid IN pon_bid_headers.created_by%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,

Line 313: p_venid IN pon_bid_headers.vendor_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,

Line 314: p_vensid IN pon_bid_headers.vendor_site_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,

Line 315: p_venscode IN pon_bid_headers.vendor_site_code%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,
319: ----------- Supplier Management: Supplier Evaluation -----------

Line 316: p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%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 -----------
320: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 317: p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_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,

Line 320: p_evaluator_id IN pon_bid_headers.evaluator_id%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,

Line 321: p_eval_flag IN pon_bid_headers.evaluation_flag%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,
325: p_prev_bid_disq IN VARCHAR2,

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

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:

Line 334: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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

Line 335: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

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: );

Line 336: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

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: