[Home] [Help]
PACKAGE: APPS.PON_OPEN_INTERFACE_PVT
Source
1 PACKAGE pon_open_interface_pvt AUTHID CURRENT_USER AS
2 /* $Header: PON_OPEN_INTERFACE_PVT.pls 120.4.12020000.5 2013/05/22 06:01:59 nrayi noship $ */
3
4 g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5 g_pkg_name CONSTANT VARCHAR2(50) := 'PON_OPEN_INTERFACE_PVT';
6 g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
7 g_interface_type VARCHAR2(20) := 'ITEMUPLOAD';
8 g_auction_pbs_type CONSTANT VARCHAR2(20) := 'AUCTION_PBS';
9 g_null_int CONSTANT NUMBER := -9999;
10 g_user_id NUMBER;
11 g_auction_attrs_type CONSTANT VARCHAR2(20) := 'AUCTION_ATTRS';
12 g_update_action CONSTANT VARCHAR2(20) := '#';
13 g_add_action CONSTANT VARCHAR2(20) := '+';
14 g_curr_lang VARCHAR2(10);
15 g_login_id NUMBER;
16 g_trading_partner_id hz_parties.party_id%TYPE;
17 TYPE ATTRIBUTES_VALUES_VALIDATION
18 IS
19 RECORD
20 (
21 l_BATCH_ID PON_AUC_ATTRIBUTES_INTERFACE.BATCH_ID%TYPE,
22 l_INTERFACE_LINE_ID PON_AUC_ATTRIBUTES_INTERFACE.INTERFACE_LINE_ID%TYPE,
23 l_AUCTION_HEADER_ID PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_HEADER_ID%TYPE,
24 l_AUCTION_LINE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_LINE_NUMBER%TYPE,
25 l_SEQUENCE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.SEQUENCE_NUMBER%TYPE,
26 l_ATTRIBUTE_NAME PON_AUC_ATTRIBUTES_INTERFACE.ATTRIBUTE_NAME%TYPE,
27 l_DATATYPE PON_AUC_ATTRIBUTES_INTERFACE.DATATYPE%TYPE,
28 l_RESPONSE_TYPE PON_AUC_ATTRIBUTES_INTERFACE.RESPONSE_TYPE%TYPE,
29 l_RESPONSE_TYPE_NAME PON_AUC_ATTRIBUTES_INTERFACE.RESPONSE_TYPE_NAME%TYPE,
30 l_MANDATORY_FLAG PON_AUC_ATTRIBUTES_INTERFACE.MANDATORY_FLAG%TYPE,
31 l_DISPLAY_ONLY_FLAG PON_AUC_ATTRIBUTES_INTERFACE.DISPLAY_ONLY_FLAG%TYPE,
32 l_DISPLAY_TARGET_FLAG PON_AUC_ATTRIBUTES_INTERFACE.DISPLAY_TARGET_FLAG%TYPE,
33 l_VALUE PON_AUC_ATTRIBUTES_INTERFACE.VALUE%TYPE,
34 l_GROUP_CODE PON_AUC_ATTRIBUTES_INTERFACE.GROUP_CODE%TYPE,
35 l_GROUP_NAME PON_AUC_ATTRIBUTES_INTERFACE.GROUP_NAME%TYPE,
36 l_SCORING_TYPE PON_AUC_ATTRIBUTES_INTERFACE.SCORING_TYPE%TYPE,
37 l_ATTR_MAX_SCORE PON_AUC_ATTRIBUTES_INTERFACE.ATTR_MAX_SCORE%TYPE,
38 l_WEIGHT PON_AUC_ATTRIBUTES_INTERFACE.WEIGHT%TYPE,
39 l_INTERNAL_ATTR_FLAG PON_AUC_ATTRIBUTES_INTERFACE.INTERNAL_ATTR_FLAG%TYPE,
40 l_SCORING_METHOD PON_AUC_ATTRIBUTES_INTERFACE.SCORING_METHOD%TYPE,
41 l_KNOCKOUT_SCORE PON_AUC_ATTRIBUTES_INTERFACE.KNOCKOUT_SCORE%TYPE,
42 l_ACTION PON_AUC_ATTRIBUTES_INTERFACE.ACTION%TYPE );
43 TYPE ATTRIBUTE_SCORES
44 IS
45 RECORD
46 (
47 l_BATCH_ID PON_ATTRIBUTE_SCORES_INTERFACE.BATCH_ID%TYPE,
48 l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,
49 l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50 l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51 l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52 l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53 l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54 l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55 l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56 l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57 l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58 l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59 l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60 l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,
61 l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,
62 l_interface_line_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_line_id%TYPE);
63
64 TYPE neg_header_record IS RECORD
65 (
66 auction_header_id pon_auction_Headers_all.auction_header_id%TYPE,
67 document_number pon_auction_headers_all.document_number%TYPE,
68 auction_title pon_auction_headers_all.auction_title%TYPE,
69 description pon_auction_headers_all.description%TYPE,
70 auction_status pon_auction_headers_all.auction_status%TYPE,
71 auction_type pon_auction_headers_all.auction_type%TYPE,
72 contract_type pon_auction_headers_all.contract_type%TYPE,
73 trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE,
74 trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE,
75 trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE,
76 bid_visibility_code pon_auction_headers_all.bid_visibility_code%TYPE,
77 creation_date pon_auction_headers_all.creation_date%TYPE,
78 created_by pon_auction_headers_all.created_by%TYPE,
79 last_update_date pon_auction_headers_all.last_update_date%TYPE,
80 last_updated_by pon_auction_headers_all.last_updated_by%TYPE,
81 doctype_id pon_auction_headers_all.doctype_id%TYPE,
82 org_id pon_auction_headers_all.org_id%TYPE,
83 buyer_id pon_auction_headers_all.buyer_id%TYPE,
84 approval_status pon_auction_headers_all.approval_status%TYPE,
85 global_agreement_flag pon_auction_headers_all.global_agreement_flag%TYPE,
86 style_id pon_auction_headers_all.style_id%TYPE,
87 po_style_id pon_auction_headers_all.po_style_id%TYPE,
88 po_style_name pon_auction_headers_interface.po_style_name%TYPE,
89 price_break_response pon_auction_headers_all.price_break_response%TYPE,
90 advance_negotiable_flag pon_auction_headers_all.advance_negotiable_flag%TYPE,
91 recoupment_negotiable_flag pon_auction_headers_all.recoupment_negotiable_flag%TYPE,
92 progress_pymt_negotiable_flag pon_auction_headers_all.progress_pymt_negotiable_flag%TYPE,
93 retainage_negotiable_flag pon_auction_headers_all.retainage_negotiable_flag%TYPE,
94 max_retainage_negotiable_flag pon_auction_headers_all.max_retainage_negotiable_flag%TYPE,
95 supplier_enterable_pymt_flag pon_auction_headers_all.supplier_enterable_pymt_flag%TYPE,
96 progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE,
97 progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE,
98 line_attribute_enabled_flag pon_auction_headers_all.line_attribute_enabled_flag%TYPE,
99 line_mas_enabled_flag pon_auction_headers_all.line_mas_enabled_flag%TYPE,
100 price_element_enabled_flag pon_auction_headers_all.price_element_enabled_flag%TYPE,
101 rfi_line_enabled_flag pon_auction_headers_all.rfi_line_enabled_flag%TYPE,
102 lot_enabled_flag pon_auction_headers_all.lot_enabled_flag%TYPE,
103 group_enabled_flag pon_auction_headers_all.group_enabled_flag%TYPE,
104 large_neg_enabled_flag pon_auction_headers_all.large_neg_enabled_flag%TYPE,
105 hdr_attribute_enabled_flag pon_auction_headers_all.hdr_attribute_enabled_flag%TYPE,
106 neg_team_enabled_flag pon_auction_headers_all.neg_team_enabled_flag%TYPE,
107 proxy_bidding_enabled_flag pon_auction_headers_all.proxy_bidding_enabled_flag%TYPE,
108 power_bidding_enabled_flag pon_auction_headers_all.power_bidding_enabled_flag%TYPE,
109 auto_extend_enabled_flag pon_auction_headers_all.auto_extend_enabled_flag%TYPE,
110 team_scoring_enabled_flag pon_auction_headers_all.team_scoring_enabled_flag%TYPE,
111 price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE,
112 qty_price_tiers_enabled_flag pon_auction_headers_all.qty_price_tiers_enabled_flag%TYPE,
113 ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
114 bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
115 ship_to_location_code pon_auction_headers_interface.ship_to_location_code%TYPE,
116 bill_to_location_code pon_auction_headers_interface.bill_to_location_code%TYPE,
117 payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
118 fob_code pon_auction_headers_all.fob_code%TYPE,
119 freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
120 rate_type pon_auction_headers_all.rate_type%TYPE,
121 currency_code pon_auction_headers_all.currency_code%TYPE,
122 security_level_code pon_auction_headers_all.security_level_code%TYPE,
123 po_start_date pon_auction_headers_all.po_start_date%TYPE,
124 po_end_date pon_auction_headers_all.po_end_date%TYPE,
125 open_auction_now_flag pon_auction_headers_all.open_auction_now_flag%TYPE,
126 open_bidding_date pon_auction_headers_all.open_bidding_date%TYPE,
127 close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE,
128 publish_auction_now_flag pon_auction_headers_all.publish_auction_now_flag%TYPE,
129 auction_published_flag pon_auction_headers_interface.auction_published_flag%TYPE,
130 view_by_date pon_auction_headers_all.view_by_date%TYPE,
131 note_to_bidders pon_auction_headers_all.note_to_bidders%TYPE,
132 show_bidder_notes pon_auction_headers_all.show_bidder_notes%TYPE,
133 bid_scope_code pon_auction_headers_all.bid_scope_code%TYPE,
134 bid_list_type pon_auction_headers_all.bid_list_type%TYPE,
135 bid_frequency_code pon_auction_headers_all.bid_frequency_code%TYPE,
136 bid_ranking pon_auction_headers_all.bid_ranking%TYPE,
137 rank_indicator pon_auction_headers_all.rank_indicator%TYPE,
138 full_quantity_bid_code pon_auction_headers_all.full_quantity_bid_code%TYPE,
139 multiple_rounds_flag pon_auction_headers_all.multiple_rounds_flag%TYPE,
140 manual_close_flag pon_auction_headers_all.manual_close_flag%TYPE,
141 manual_extend_flag pon_auction_headers_all.manual_extend_flag%TYPE,
142 award_approval_flag pon_auction_headers_all.award_approval_flag%TYPE,
143 auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE,
144 pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE,
145 hdr_attr_enable_weights pon_auction_headers_all.hdr_attr_enable_weights%TYPE,
146 trading_partner_contact_name pon_auction_headers_all.trading_partner_contact_name%TYPE,
147 award_by_date pon_auction_headers_all.award_by_date%TYPE,
148 publish_date pon_auction_headers_all.publish_date%TYPE,
149 auto_extend_flag pon_auction_headers_all.auto_extend_flag%TYPE,
150 auto_extend_number pon_auction_headers_all.auto_extend_number%TYPE,
151 min_bid_decrement pon_auction_headers_all.min_bid_decrement%TYPE,
152 min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE,
153 price_driven_auction_flag pon_auction_headers_all.price_driven_auction_flag%TYPE,
154 carrier_code pon_auction_headers_all.carrier_code%TYPE,
155 rate_date pon_auction_headers_all.rate_date%TYPE,
156 auto_extend_all_lines_flag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE,
157 allow_other_bid_currency_flag pon_auction_headers_all.allow_other_bid_currency_flag%TYPE,
158 shipping_terms_code pon_auction_headers_all.shipping_terms_code%TYPE,
159 auto_extend_duration pon_auction_headers_all.auto_extend_duration%TYPE,
160 proxy_bid_allowed_flag pon_auction_headers_all.proxy_bid_allowed_flag%TYPE,
161 publish_rates_to_bidders_flag pon_auction_headers_all.publish_rates_to_bidders_flag%TYPE,
162 event_id pon_auction_headers_all.event_id%TYPE,
163 event_title pon_auction_headers_all.event_title%TYPE,
164 sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE,
165 number_price_decimals pon_auction_headers_all.number_price_decimals%TYPE,
166 auto_extend_type_flag pon_auction_headers_all.auto_extend_type_flag%TYPE,
167 max_responses pon_auction_headers_all.max_responses%TYPE,
168 response_allowed_flag pon_auction_headers_all.response_allowed_flag%TYPE,
169 contract_id pon_auction_headers_all.contract_id%TYPE,
170 contract_version_num pon_auction_headers_all.contract_version_num%TYPE,
171 show_bidder_scores pon_auction_headers_all.show_bidder_scores%TYPE,
172 po_min_rel_amount pon_auction_headers_all.po_min_rel_amount%TYPE,
173 hdr_attr_display_score pon_auction_headers_all.hdr_attr_display_score%TYPE,
174 hdr_attr_maximum_score pon_auction_headers_all.hdr_attr_maximum_score%TYPE,
175 int_attribute_category pon_auction_headers_all.int_attribute_category%TYPE,
176 int_attribute1 pon_auction_headers_all.int_attribute1%TYPE,
177 int_attribute2 pon_auction_headers_all.int_attribute2%TYPE,
178 int_attribute3 pon_auction_headers_all.int_attribute3%TYPE,
179 int_attribute4 pon_auction_headers_all.int_attribute4%TYPE,
180 int_attribute5 pon_auction_headers_all.int_attribute5%TYPE,
181 int_attribute6 pon_auction_headers_all.int_attribute6%TYPE,
182 int_attribute7 pon_auction_headers_all.int_attribute7%TYPE,
183 int_attribute8 pon_auction_headers_all.int_attribute8%TYPE,
184 int_attribute9 pon_auction_headers_all.int_attribute9%TYPE,
185 int_attribute10 pon_auction_headers_all.int_attribute10%TYPE,
186 int_attribute11 pon_auction_headers_all.int_attribute11%TYPE,
187 int_attribute12 pon_auction_headers_all.int_attribute12%TYPE,
188 int_attribute13 pon_auction_headers_all.int_attribute13%TYPE,
189 int_attribute14 pon_auction_headers_all.int_attribute14%TYPE,
190 int_attribute15 pon_auction_headers_all.int_attribute15%TYPE,
191 ext_attribute_category pon_auction_headers_all.ext_attribute_category%TYPE,
192 ext_attribute1 pon_auction_headers_all.ext_attribute1%TYPE,
193 ext_attribute2 pon_auction_headers_all.ext_attribute2%TYPE,
194 ext_attribute3 pon_auction_headers_all.ext_attribute3%TYPE,
195 ext_attribute4 pon_auction_headers_all.ext_attribute4%TYPE,
196 ext_attribute5 pon_auction_headers_all.ext_attribute5%TYPE,
197 ext_attribute6 pon_auction_headers_all.ext_attribute6%TYPE,
198 ext_attribute7 pon_auction_headers_all.ext_attribute7%TYPE,
199 ext_attribute8 pon_auction_headers_all.ext_attribute8%TYPE,
200 ext_attribute9 pon_auction_headers_all.ext_attribute9%TYPE,
201 ext_attribute10 pon_auction_headers_all.ext_attribute10%TYPE,
202 ext_attribute11 pon_auction_headers_all.ext_attribute11%TYPE,
203 ext_attribute12 pon_auction_headers_all.ext_attribute12%TYPE,
204 ext_attribute13 pon_auction_headers_all.ext_attribute13%TYPE,
205 ext_attribute14 pon_auction_headers_all.ext_attribute14%TYPE,
206 ext_attribute15 pon_auction_headers_all.ext_attribute15%TYPE,
207 abstract_details pon_auction_headers_all.abstract_details%TYPE,
208 supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE,
209 project_id pon_auction_headers_all.project_id%TYPE,
210 has_scoring_teams_flag pon_auction_headers_all.has_scoring_teams_flag%TYPE,
211 bid_decrement_method pon_auction_headers_all.bid_decrement_method%TYPE,
212 display_best_price_blind_flag pon_auction_headers_all.display_best_price_blind_flag%TYPE,
213 first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE,
214 staggered_closing_interval pon_auction_headers_all.staggered_closing_interval%TYPE,
215 enforce_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE,
216 auto_extend_min_trigger_rank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE,
217 two_part_flag pon_auction_headers_all.two_part_flag%TYPE,
218 supp_reg_qual_flag pon_auction_headers_all.supp_reg_qual_flag%TYPE,
219 supp_eval_flag pon_auction_headers_all.supp_eval_flag%TYPE,
220 hide_terms_flag pon_auction_headers_all.hide_terms_flag%TYPE,
221 hide_abstract_forms_flag pon_auction_headers_all.hide_abstract_forms_flag%TYPE,
222 hide_attachments_flag pon_auction_headers_all.hide_attachments_flag%TYPE,
223 internal_eval_flag pon_auction_headers_all.internal_eval_flag%TYPE,
224 hdr_supp_attr_enabled_flag pon_auction_headers_all.hdr_supp_attr_enabled_flag%TYPE,
225 intgr_hdr_attr_flag pon_auction_headers_all.intgr_hdr_attr_flag%TYPE,
226 intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%TYPE,
227 line_supp_attr_enabled_flag pon_auction_headers_all.line_supp_attr_enabled_flag%TYPE,
228 item_supp_attr_enabled_flag pon_auction_headers_all.item_supp_attr_enabled_flag%TYPE,
229 intgr_cat_line_attr_flag pon_auction_headers_all.intgr_cat_line_attr_flag%TYPE,
230 intgr_item_line_attr_flag pon_auction_headers_all.intgr_item_line_attr_flag%TYPE,
231 intgr_cat_line_asl_flag pon_auction_headers_all.intgr_cat_line_asl_flag%TYPE,
232 internal_only_flag pon_auction_headers_all.internal_only_flag%TYPE,
233 uda_template_id pon_auction_headers_all.uda_template_id%TYPE,
234 uda_template_date pon_auction_headers_all.uda_template_date%TYPE,
235 standard_form pon_auction_headers_all.standard_form%TYPE,
236 document_format pon_auction_headers_all.document_format%TYPE,
237 amendment_flag pon_auction_Headers_all.amendment_flag%TYPE,
238 amendment_description pon_auction_Headers_all.amendment_description%TYPE,
239 ALLOW_WITHDRAW_FLAG pon_auction_Headers_all.ALLOW_WITHDRAW_FLAG%TYPE,
240 ALLOW_UNSOL_OFFER_LINES pon_auction_Headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE,
241 ALLOW_MULTIPLE_ACTIVE_OFFERS pon_auction_Headers_all.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE, --Defined by Ankit
242 EFFECTIVE_DATE pon_auction_Headers_all.EFFECTIVE_DATE%TYPE,
243 SIGNED_DATE pon_auction_Headers_all.SIGNED_DATE%TYPE,
244 SOLICITATION_TYPE pon_auction_Headers_all.SOLICITATION_TYPE%TYPE,
245 FAIR_OPP_NOTICE_FLAG pon_auction_Headers_all.FAIR_OPP_NOTICE_FLAG%TYPE,
246 FEDERAL_PUBLICATION_EXCEPTION pon_auction_Headers_all.FEDERAL_PUBLICATION_EXCEPTION%TYPE,
247 NO_OF_COPIES pon_auction_Headers_all.NO_OF_COPIES %TYPE,
248 REVISION pon_auction_Headers_all.REVISION%TYPE,
249 UMBRELLA_PROGRAM_ID pon_auction_Headers_all.UMBRELLA_PROGRAM_ID%TYPE,
250 CD_EDITBYUSER_FLAG pon_auction_Headers_all.CD_EDITBYUSER_FLAG%TYPE,
251 CD_GENERATED_DATE pon_auction_Headers_all.CD_GENERATED_DATE%TYPE,
252 CD_GENERATED_FLAG pon_auction_Headers_all.CD_GENERATED_FLAG%TYPE,
253 AMENDUPDATED_AFTERCDGENERATED pon_auction_Headers_all.AMENDUPDATED_AFTERCDGENERATED%TYPE
254 );
255
256 TYPE org_default_data IS RECORD(
257 org_id pon_auction_headers_all.org_id%TYPE,
258 bill_to_location_id pon_auction_headers_all.bill_to_location_id%TYPE,
259 ship_to_location_id pon_auction_headers_all.ship_to_location_id%TYPE,
260 payment_terms_id pon_auction_headers_all.payment_terms_id%TYPE,
261 fob_code pon_auction_headers_all.fob_code%TYPE,
262 freight_terms_code pon_auction_headers_all.freight_terms_code%TYPE,
263 rate_type pon_auction_headers_all.rate_type%TYPE,
264 currency_code pon_auction_headers_all.currency_code%TYPE,
265 security_level_code pon_auction_headers_all.security_level_code%TYPE
266 );
267
268 --g_interface_type VARCHAR2(20) := 'HEADERUPLOAD';
269
270
271 PROCEDURE create_header_attr_inter
272 (
273 p_commit IN VARCHAR2,
274 batchId IN NUMBER,
275 x_return_status IN OUT NOCOPY VARCHAR2);
276
277 PROCEDURE print_log
278 (
279 p_message IN VARCHAR2);
280
281 PROCEDURE acceptance_values_insert
282 (
283 p_interface_attr_rec1 IN ATTRIBUTES_VALUES_VALIDATION,
284 p_sequence_number_attr IN pon_attribute_scores_interface.ATTRIBUTE_SEQUENCE_NUMBER%TYPE,
285 l_status IN OUT NOCOPY VARCHAR2);
286
287 PROCEDURE check_range_overlap
288 (
289 p_attr_score_rec IN ATTRIBUTE_SCORES,
290 p_datatype IN pon_auc_attributes_interface.datatype%type,
291 l_status OUT NOCOPY VARCHAR2 ) ;
292
293 PROCEDURE create_neg_team
294 (
295 p_commit IN VARCHAR2,
296 batchId IN NUMBER,
297 x_return_status IN OUT NOCOPY VARCHAR2 );
298
299 PROCEDURE create_members_in_collteam
300 (
301 batchid IN NUMBER,
302 username IN VARCHAR2,
303 ispreparer IN VARCHAR2, -- 'Y'/'N'
304 menu_name IN VARCHAR2, -- 'PON_SOURCING_EDITNEG'/'PON_SOURCING_VIEWNEG'/'PON_SOURCING_SCORENEG'
305 approver_flag IN VARCHAR2, -- 'Y'/'N'
306 auction_header_id IN NUMBER,
307 task_name IN VARCHAR2,
308 target_date IN DATE,
309 manager_approver_flag IN VARCHAR2,
310 x_return_status IN OUT NOCOPY VARCHAR2 );
311
312 PROCEDURE insert_collabteam_member
313 (
314 auction_header_id IN NUMBER,
315 user_id IN NUMBER,
316 user_name IN VARCHAR2,
317 menu_name IN VARCHAR2,
318 member_type IN VARCHAR2,
319 approver_flag IN VARCHAR2,
320 task_name IN VARCHAR2,
321 target_date IN DATE,
322 creation_date IN DATE,
323 created_by IN NUMBER,
324 last_update_date IN DATE,
325 last_updated_by IN NUMBER);
326
327 FUNCTION check_uniqueness
328 (
329 p_user_id IN NUMBER,
330 p_auction_header_id IN NUMBER,
331 ispreparer IN VARCHAR2)
332 RETURN BOOLEAN;
333
334 PROCEDURE invite_supplier
335 (
336 p_batch_id IN NUMBER,
337 x_return_status IN OUT NOCOPY VARCHAR2
338 );
339
340 PROCEDURE validate_invited_suppliers(p_batch_id IN NUMBER);
341
342 PROCEDURE create_lines_with_children
343 (
344 p_batch_id IN NUMBER,
345 p_auction_Header_id IN NUMBER,
346 x_return_status IN OUT NOCOPY VARCHAR2);
347
348
349 PROCEDURE add_price_breaks
350 (
351 p_batch_id IN NUMBER ,
352 p_auction_header_id IN NUMBER,
353 x_result IN OUT NOCOPY VARCHAR2,
354 x_error_code OUT NOCOPY VARCHAR2,
355 x_error_message OUT NOCOPY VARCHAR2 );
356
357 PROCEDURE VAL_PRICE_BREAKS
358 (
359 p_auction_header_id IN NUMBER,
360 p_close_bidding_date IN DATE,
361 p_request_id IN NUMBER,
362 p_expiration_date IN DATE,
363 p_user_id IN NUMBER,
364 p_login_id IN NUMBER,
365 p_batch_id IN NUMBER,
366 p_precision IN NUMBER,
367 p_po_start_date IN DATE,
368 p_po_end_date IN DATE );
369
370 PROCEDURE VAL_ATTR_SCORES
371 (
372 p_auction_header_id IN NUMBER,
373 p_request_id IN NUMBER,
374 p_expiration_date IN DATE,
375 p_user_id IN NUMBER,
376 p_login_id IN NUMBER,
377 p_batch_id IN NUMBER );
378
379
380 PROCEDURE create_negotiations(
381 p_group_batch_id IN NUMBER,
382 x_return_status IN OUT NOCOPY VARCHAR2,
383 x_msg_count OUT NOCOPY NUMBER,
384 x_msg_data OUT NOCOPY varchar2
385 );
386
387 PROCEDURE create_negotiation(
388 p_batch_id IN NUMBER,
389 x_auction_header_id OUT NOCOPY NUMBER,
390 x_return_status IN OUT NOCOPY VARCHAR2
391 );
392
393
394 PROCEDURE process_uda_attributes(
395 p_batch_id IN NUMBER,
396 p_auction_Header_id IN NUMBER,
397 p_line_number IN NUMBER,
398 p_uda_template_id IN NUMBER,
399 p_level IN VARCHAR2,
400 x_return_status IN OUT NOCOPY VARCHAR2
401 );
402
403 PROCEDURE create_negotiation_header
404 (
405 p_batch_id IN NUMBER,
406 x_return_status IN OUT NOCOPY VARCHAR2
407 );
408
409 PROCEDURE process_negotiation_header(
410 p_batch_id IN NUMBER,
411 p_tp_id IN NUMBER,
412 x_auction_header_id OUT NOCOPY NUMBER,
413 x_return_status IN OUT NOCOPY VARCHAR2
414 );
415
416 PROCEDURE validate_header(
417 --c_inter_cursor_rec IN c_inter_header%ROWTYPE,
418 p_batch_id IN NUMBER,
419 p_tp_id IN NUMBER,
420 p_is_amendment IN VARCHAR2,
421 p_src_auction_header_id IN NUMBER
422 );
423
424 PROCEDURE populate_neg_header_rec(p_batch_id IN NUMBER,
425 p_is_amendment IN VARCHAR2,
426 p_src_auction_header_id IN NUMBER);
427
428 PROCEDURE init_rule_based_header_data(p_is_amendment IN VARCHAR2,
429 p_src_auction_Header_id IN NUMBER);
430
431 PROCEDURE publish_negotiation
432 (
433 p_auction_header_id IN NUMBER,
434 x_return_status IN OUT NOCOPY VARCHAR2);
435
436 PROCEDURE create_amendments(
437 p_group_batch_id IN NUMBER,
438 x_return_status IN OUT NOCOPY VARCHAR2,
439 x_msg_count OUT NOCOPY NUMBER,
440 x_msg_data OUT NOCOPY varchar2
441 );
442
443 PROCEDURE create_amendment( p_batch_id IN NUMBER,
444 x_auction_header_id OUT NOCOPY NUMBER,
445 x_return_status IN OUT NOCOPY VARCHAR2,
446 x_msg_count IN OUT NOCOPY NUMBER,
447 x_msg_data IN OUT NOCOPY varchar2);
448
449 FUNCTION can_create_amendment(
450 p_batch_id IN NUMBER,
451 p_tpc_id IN NUMBER,
452 p_auction_header_id IN NUMBER) RETURN boolean;
453
454 PROCEDURE update_amendment_header(p_auction_header_id IN NUMBER);
455
456 PROCEDURE insert_error (p_error_msg IN VARCHAR2 ,
457 p_batch_id IN NUMBER,
458 p_entity_type IN VARCHAR2,
459 p_auction_header_id IN NUMBER,
460 p_user_id IN NUMBER,
461 p_user_login IN number);
462
463 PROCEDURE line_sanity_validation(p_batch_id IN NUMBER );
464
465 END PON_OPEN_INTERFACE_PVT;