1 PACKAGE PON_AUCTION_PKG AUTHID CURRENT_USER as
2 /* $Header: PONAUCTS.pls 120.28 2011/12/29 09:36:32 nbingi ship $ */
3
4
5 PROCEDURE START_AUCTION(p_auction_header_id_encrypted VARCHAR2, -- 1
6 p_auction_header_id NUMBER, -- 2
7 p_trading_partner_contact_name VARCHAR2, -- 3
8 p_trading_partner_contact_id NUMBER, -- 4
9 p_trading_partner_name VARCHAR2, -- 5
10 p_trading_partner_id NUMBER, -- 6
11 p_open_bidding_date DATE, -- 7
12 p_close_bidding_date DATE, -- 8
13 p_award_by_date DATE, -- 9
14 p_reminder_date DATE, -- 10
15 p_bid_list_type VARCHAR2, -- 11
16 p_note_to_bidders VARCHAR2, -- 12
17 p_number_of_items NUMBER, -- 13
18 p_auction_title VARCHAR2, -- 14
19 p_event_id NUMBER); -- 15
20
21
22
23 PROCEDURE START_BID(p_bid_id NUMBER, -- 1
24 p_auction_header_id NUMBER, -- 2
25 p_bid_tp_contact_name VARCHAR2, -- 3
26 p_auction_tp_name VARCHAR2, -- 4
27 p_auction_open_bidding_date DATE, -- 5
28 p_auction_close_bidding_date DATE, -- 6
29 p_visibility_code VARCHAR2, -- 7
30 p_item_description VARCHAR2, -- 8
31 p_old_price NUMBER, -- 9
32 p_new_price NUMBER, -- 10
33 p_auction_title VARCHAR2, -- 11
34 p_oex_operation VARCHAR2, -- 12
35 p_oex_operation_url VARCHAR2); -- 13
36
37
38 PROCEDURE DISQUALIFY_BID(p_auction_header_id_encrypted VARCHAR2, -- 1
39 p_bid_id NUMBER, -- 2
40 p_auction_header_id NUMBER, -- 3
41 p_bid_tp_contact_name VARCHAR2, -- 4
42 p_auction_tp_name VARCHAR2, -- 5
43 p_auction_title VARCHAR2, -- 6
44 p_disqualify_date DATE, -- 7
45 p_disqualify_reason VARCHAR2 -- 8
46 );
47
48
49 PROCEDURE RETRACT_BID(p_bid_id NUMBER, -- 1
50 p_auction_header_id NUMBER, -- 2
51 p_bid_tp_contact_name VARCHAR2, -- 3
52 p_bid_tp_contact_id NUMBER, -- 4
53 p_auction_tp_contact_name VARCHAR2, -- 5
54 p_auction_tp_contact_id NUMBER, -- 6
55 p_auction_open_bidding_date DATE, -- 7
56 p_auction_close_bidding_date DATE, -- 8
57 p_oex_operation_url VARCHAR2); -- 9
58
59
60
61 PROCEDURE AWARD_BID(p_bid_id NUMBER, -- 1
62 p_auction_header_id NUMBER, -- 2
63 p_bid_tp_contact_name VARCHAR2, -- 3
64 p_auction_tp_name VARCHAR2, -- 4
65 p_auction_title VARCHAR2, -- 5
66 p_auction_header_id_encrypted VARCHAR2 -- 6
67 );
68
69
70
71 PROCEDURE UNREGISTERED_BIDDERS(itemtype in varchar2,
72 itemkey in varchar2,
73 actid in number,
74 uncmode in varchar2,
75 resultout out NOCOPY varchar2);
76
77 PROCEDURE REGISTERED_BIDDER(itemtype in varchar2,
78 itemkey in varchar2,
79 actid in number,
80 uncmode in varchar2,
81 resultout out NOCOPY varchar2);
82
83 PROCEDURE BIDDERS_LIST(itemtype in varchar2,
84 itemkey in varchar2,
85 actid in number,
86 uncmode in varchar2,
87 resultout out NOCOPY varchar2);
88
89
90 PROCEDURE CREATE_LOCAL_ROLES(itemtype IN VARCHAR2,
91 itemkey IN VARCHAR2,
92 actid IN NUMBER,
93 uncmode IN VARCHAR2,
94 resultout OUT NOCOPY VARCHAR2);
95
96 PROCEDURE POPULATE_ROLE_WITH_INVITEES (itemtype IN VARCHAR2,
97 itemkey IN VARCHAR2,
98 actid IN NUMBER,
99 uncmode IN VARCHAR2,
100 resultout OUT NOCOPY VARCHAR2);
101
102 PROCEDURE REACHED_AUCTION_START_DATE(itemtype IN VARCHAR2,
103 itemkey IN VARCHAR2,
104 actid IN NUMBER,
105 uncmode IN VARCHAR2,
106 resultout OUT NOCOPY VARCHAR2);
107
108 PROCEDURE REACHED_AUCTION_END_DATE(itemtype IN VARCHAR2,
109 itemkey IN VARCHAR2,
110 actid IN NUMBER,
111 uncmode IN VARCHAR2,
112 resultout OUT NOCOPY VARCHAR2);
113
114
115 PROCEDURE DOES_BIDDER_LIST_EXIT(itemtype IN VARCHAR2,
116 itemkey IN VARCHAR2,
117 actid IN NUMBER,
118 uncmode in varchar2,
119 resultout out NOCOPY varchar2);
120
121 PROCEDURE NON_BID_LIST_BIDDERS(itemtype in varchar2,
122 itemkey in varchar2,
123 actid in number,
124 uncmode in varchar2,
125 resultout out NOCOPY varchar2);
126
127
128 PROCEDURE NOTIFY_BIDDER_LIST_START(itemtype in varchar2,
129 itemkey in varchar2,
130 actid in number,
131 uncmode in varchar2,
132 resultout out NOCOPY varchar2);
133
134 PROCEDURE NOTIFY_BIDDER_LIST_CANCEL(itemtype in varchar2,
135 itemkey in varchar2,
136 actid in number,
137 uncmode in varchar2,
138 resultout out NOCOPY varchar2);
139
140 PROCEDURE NOTIFY_NON_BIDDER_LIST_CANCEL(itemtype in varchar2,
141 itemkey in varchar2,
142 actid in number,
143 uncmode in varchar2,
144 resultout out NOCOPY varchar2);
145
146 PROCEDURE NOTIFY_BIDDER_LIST_END(itemtype in varchar2,
147 itemkey in varchar2,
148 actid in number,
149 uncmode in varchar2,
150 resultout out NOCOPY varchar2);
151
152 PROCEDURE NOTIFY_NON_BIDDER_LIST_END(itemtype in varchar2,
153 itemkey in varchar2,
154 actid in number,
155 uncmode in varchar2,
156 resultout out NOCOPY varchar2);
157
158 PROCEDURE CHECK_AUCTION_BIDDER
159 (p_trading_partner_contact_id IN NUMBER,
160 p_auction_header_id IN NUMBER,
161 x_return_status OUT NOCOPY NUMBER);
162
163 PROCEDURE SEALED_BIDS(itemtype in varchar2,
164 itemkey in varchar2,
165 actid in number,
166 uncmode in varchar2,
167 resultout out NOCOPY varchar2);
168
169 PROCEDURE BIDDER_IN_LIST(itemtype in varchar2,
170 itemkey in varchar2,
171 actid in number,
172 uncmode in varchar2,
173 resultout out NOCOPY varchar2);
174
175 PROCEDURE CANCEL_AUCTION(p_auction_header_id IN NUMBER);
176
177 PROCEDURE COMPLETE_AUCTION(p_auction_header_id IN NUMBER);
178
179 -- FPK: CPA Function to check if negotiation has lines or not
180 FUNCTION NEG_HAS_LINES (p_auction_number IN NUMBER) RETURN VARCHAR2;
181
182 FUNCTION Get_Oex_Time_Zone return varchar2;
183 FUNCTION Get_Time_Zone(contact_id number) return varchar2;
184 FUNCTION Get_Time_Zone(contact_name varchar2) return varchar2;
185 FUNCTION Get_TimeZone_Description(p_timezone_id varchar2, lang varchar2) return varchar2;
186
187 FUNCTION GET_CLOSE_BIDDING_DATE(p_auction_header_id IN NUMBER) RETURN DATE;
188
189 FUNCTION TIME_REMAINING_ORDER(p_auction_header_id IN NUMBER) RETURN NUMBER;
190
191 FUNCTION TIME_REMAINING_ORDER( p_auction_status IN VARCHAR2,
192 p_creation_date IN DATE,
193 p_close_bidding_date IN DATE,
194 p_is_paused IN VARCHAR2,
195 p_last_pause_date IN DATE,
196 p_auction_header_id_orig_round IN NUMBER,
197 p_auction_round_number IN NUMBER,
198 p_amendment_number IN NUMBER) RETURN NUMBER;
199
200 FUNCTION TIME_REMAINING(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
201
202 FUNCTION TIME_REMAINING(p_auction_header_id IN NUMBER, p_line_number IN NUMBER) RETURN VARCHAR2;
203
204 FUNCTION TIME_REMAINING( p_auction_status IN VARCHAR2,
205 p_open_bidding_date IN DATE,
206 p_close_bidding_date IN DATE,
207 p_is_paused IN VARCHAR2,
208 p_last_pause_date IN DATE,
209 p_staggered_closing_interval IN NUMBER ) RETURN VARCHAR2;
210
211 PROCEDURE AUCTION_OPEN(itemtype IN VARCHAR2,
212 itemkey IN VARCHAR2,
213 actid IN NUMBER,
214 uncmode IN VARCHAR2,
215 resultout OUT NOCOPY VARCHAR2);
216
217 PROCEDURE AUCTION_CLOSED(itemtype IN VARCHAR2,
218 itemkey IN VARCHAR2,
219 actid IN NUMBER,
220 uncmode IN VARCHAR2,
221 resultout OUT NOCOPY VARCHAR2);
222
223 Function getLookupMeaning(lookupType in varchar2,
224 langCode in varchar2,
225 lookupCode in varchar2) return varchar2;
226
227 Function GetPOTotal(p_po_id IN number) return Number;
228
229 Function getNeedByDatesToPrint(auctionID IN number,lineNumber IN number,userDateFormat IN varchar2) return varchar2;
230
231 PROCEDURE AUCTION_PO_SEND (
232 transaction_code IN VARCHAR2,
233 document_id IN NUMBER,
234 party_id IN NUMBER DEFAULT NULL,
235 debug_mode IN PLS_INTEGER DEFAULT 0,
236 trigger_id OUT NOCOPY PLS_INTEGER,
237 retcode OUT NOCOPY PLS_INTEGER,
238 errmsg OUT NOCOPY VARCHAR2
239 );
240
241 PROCEDURE SET_NEW_ITEM_KEY( itemtype in varchar2,
242 itemkey in varchar2,
243 actid in number,
244 funcmode in varchar2,
245 resultout out NOCOPY varchar2 );
246
247
248 PROCEDURE EVENT_AUCTION(itemtype in varchar2,
249 itemkey in varchar2,
250 actid in number,
251 uncmode in varchar2,
252 resultout out NOCOPY varchar2);
253
254 PROCEDURE EVENT_AUCTION_ID(itemtype in varchar2,
255 itemkey in varchar2,
256 actid in number,
257 uncmode in varchar2,
258 resultout out NOCOPY varchar2);
259
260 PROCEDURE EMPTY_CANCEL_REASON(itemtype in varchar2,
261 itemkey in varchar2,
262 actid in number,
263 uncmode in varchar2,
264 resultout out NOCOPY varchar2);
265
266 PROCEDURE EMPTY_DISQUALIFY_REASON(itemtype in varchar2,
267 itemkey in varchar2,
268 actid in number,
269 uncmode in varchar2,
270 resultout out NOCOPY varchar2);
271
272 PROCEDURE EMPTY_CLOSECHANGED_REASON(itemtype in varchar2,
273 itemkey in varchar2,
274 actid in number,
275 uncmode in varchar2,
276 resultout out NOCOPY varchar2);
277
278 FUNCTION getEventTitle (p_auction_number IN NUMBER) RETURN VARCHAR2;
279
280 PROCEDURE NEW_ROUND_BIDDERS_NOT_INVITED( p_itemtype in varchar2,
281 p_itemkey in varchar2,
282 actid in number,
283 uncmode in varchar2,
284 resultout out NOCOPY varchar2);
285
286
287 PROCEDURE CLOSEEARLY_AUCTION (p_auction_header_id IN NUMBER,
288 p_new_close_date IN DATE,
289 p_closeearly_reason IN VARCHAR2);
290
291 PROCEDURE CLOSECHANGED_AUCTION (p_auction_header_id IN NUMBER,
292 p_change_type IN NUMBER,
293 p_new_close_date IN DATE,
294 p_closechanged_reason IN VARCHAR2);
295
296 PROCEDURE NOTIFY_OTHER_BIDDERS_OF_DISQ(itemtype in varchar2,
297 itemkey in varchar2,
298 actid in number,
299 uncmode in varchar2,
300 resultout out NOCOPY varchar2);
301
302 PROCEDURE NOTIFY_BIDDERS_AUC_CHANGED(itemtype in varchar2,
303 itemkey in varchar2,
304 actid in number,
305 uncmode in varchar2,
306 action_code in varchar2);
307
308 PROCEDURE NOTIFY_BIDDERS_OF_CANCEL (itemtype in varchar2,
309 itemkey in varchar2,
310 actid in number,
311 uncmode in varchar2,
312 resultout out NOCOPY varchar2);
313
314 PROCEDURE NOTIFY_BIDDERS_OF_CLOSEEARLY (itemtype in varchar2,
315 itemkey in varchar2,
316 actid in number,
317 uncmode in varchar2,
318 resultout out NOCOPY varchar2);
319
320 PROCEDURE NOTIFY_BIDDERS_OF_CLOSECHANGED (itemtype in varchar2,
321 itemkey in varchar2,
322 actid in number,
323 uncmode in varchar2,
324 resultout out nocopy varchar2);
325
326 PROCEDURE COMPLETE_PREV_ROUND_WF(p_itemtype in varchar2,
327 p_itemkey in varchar2,
328 actid in number,
329 uncmode in varchar2,
330 resultout out NOCOPY varchar2);
331
332 PROCEDURE COMPLETE_PREV_DOC_WF(p_itemtype in varchar2,
333 p_itemkey in varchar2,
334 actid in number,
335 uncmode in varchar2,
336 resultout out NOCOPY varchar2);
337
338 PROCEDURE COMPLETE_PREV_SUPPL_NOTIFS(p_prev_doc_header_id IN NUMBER);
339
340 PROCEDURE POPULATE_ROLE_WITH_SUPPLIERS (itemtype IN VARCHAR2,
341 itemkey IN VARCHAR2,
342 actid IN NUMBER,
343 uncmode IN VARCHAR2,
344 resultout OUT NOCOPY VARCHAR2);
345
346 FUNCTION getMessage (msg VARCHAR2) RETURN VARCHAR2;
347
348 FUNCTION getMessage (msg VARCHAR2, msg_suffix VARCHAR2) RETURN VARCHAR2;
349
350 -- FUNCTION getMessage (msg VARCHAR2, token VARCHAR2, token_value VARCHAR2) RETURN VARCHAR2;
351
352 FUNCTION getMessage (msg VARCHAR2, msg_suffix VARCHAR2, token VARCHAR2, token_value VARCHAR2) RETURN VARCHAR2;
353
354 FUNCTION getMessage (msg VARCHAR2, msg_suffix VARCHAR2, token1 VARCHAR2, token1_value VARCHAR2,
355 token2 VARCHAR2, token2_value VARCHAR2) RETURN VARCHAR2;
356
357 FUNCTION getMessage (msg VARCHAR2, msg_suffix VARCHAR2, token1 VARCHAR2, token1_value VARCHAR2,
358 token2 VARCHAR2, token2_value VARCHAR2,
362 token2 VARCHAR2, token2_value VARCHAR2, token3 VARCHAR2,
359 token3 VARCHAR2, token3_value VARCHAR2) RETURN VARCHAR2;
360
361 FUNCTION getMessage (msg VARCHAR2, msg_suffix VARCHAR2, token1 VARCHAR2, token1_value VARCHAR2,
363 token3_value VARCHAR2, token4 VARCHAR2, token4_value VARCHAR2) RETURN VARCHAR2;
364
365 FUNCTION getMessage (msg VARCHAR2, msg_suffix VARCHAR2, token1 VARCHAR2, token1_value VARCHAR2,
366 token2 VARCHAR2, token2_value VARCHAR2, token3 VARCHAR2,
367 token3_value VARCHAR2, token4 VARCHAR2, token4_value VARCHAR2,
368 token5 VARCHAR2, token5_value VARCHAR2) RETURN VARCHAR2;
369
370 FUNCTION GET_MESSAGE_SUFFIX (x_doctype_group_name VARCHAR2) RETURN VARCHAR2;
371
372 FUNCTION EMPTY_REASON (p_reason IN VARCHAR2) RETURN VARCHAR2;
373
374 PROCEDURE NOTIFY_NEW_INVITEES (p_auction_id NUMBER); -- 1
375
376 PROCEDURE NOTIFY_ADDED_INVITEES( x_itemtype in varchar2,
377 x_itemkey in varchar2,
378 actid in number,
379 uncmode in varchar2,
380 resultout out NOCOPY varchar2);
381
382
383 PROCEDURE NOTIFY_BIDDER_LIST_REMINDER(itemtype in varchar2,
384 itemkey in varchar2,
385 actid in number,
386 uncmode in varchar2,
387 resultout out nocopy varchar2);
388
389 PROCEDURE CLOSEDATE_EARLIER_REMINDERDATE( itemtype in varchar2,
390 itemkey in varchar2,
391 actid in number,
392 uncmode in varchar2,
393 resultout out nocopy varchar2);
394
395 PROCEDURE UPDATE_ACK_TO_YES( itemtype in varchar2,
396 itemkey in varchar2,
397 actid in number,
398 uncmode in varchar2,
399 resultout out nocopy varchar2);
400
401 PROCEDURE UPDATE_ACK_TO_NO( itemtype in varchar2,
402 itemkey in varchar2,
403 actid in number,
404 uncmode in varchar2,
405 resultout out nocopy varchar2);
406
407 PROCEDURE launch_init_notif_proc(itemtype IN VARCHAR2,
408 itemkey IN VARCHAR2,
409 actid IN NUMBER,
410 uncmode IN VARCHAR2,
411 resultout OUT NOCOPY VARCHAR2);
412
413 PROCEDURE launch_init_notif_p_add(itemtype IN VARCHAR2,
414 itemkey IN VARCHAR2,
415 actid IN NUMBER,
416 uncmode IN VARCHAR2,
417 resultout OUT NOCOPY VARCHAR2);
418
419 PROCEDURE launch_added_notif_proc(itemtype IN VARCHAR2,
420 itemkey IN VARCHAR2,
421 actid IN NUMBER,
422 uncmode IN VARCHAR2,
423 resultout OUT NOCOPY VARCHAR2);
424
425 PROCEDURE launch_new_round_notif(itemtype IN VARCHAR2,
426 itemkey IN VARCHAR2,
427 actid IN NUMBER,
428 uncmode IN VARCHAR2,
429 resultout OUT NOCOPY VARCHAR2);
430
431 PROCEDURE launch_new_round_notif_add(itemtype IN VARCHAR2,
432 itemkey IN VARCHAR2,
433 actid IN NUMBER,
434 uncmode IN VARCHAR2,
435 resultout OUT NOCOPY VARCHAR2);
436
437 PROCEDURE SET_INVITATION_LIST_FLAG(p_auction_header_id NUMBER);
438
439 procedure retrieve_user_info(param1 varchar2);
440 function getPhoneNumber(p_user_name varchar2) return varchar2;
441 function getFaxNumber(p_user_name varchar2) return varchar2;
442 function getEMail(p_user_name varchar2) return varchar2;
443
444 function replaceHtmlChars(html_in varchar2) return varchar2;
445
446 /*======================================================================
447 PROCEDURE : DELETE_NEGOTIATION_LINE_REF PUBLIC
448 PARAMETERS:
449 x_negotiation_id in auction header id
450 x_negotiation_line_num in negotiation line number
451 x_org_id in organization id
452 x_error_code out internal code for error
453
454 COMMENT : delete negotiation line references
455 ======================================================================*/
456 PROCEDURE DELETE_NEGOTIATION_LINE_REF(x_negotiation_id in number,
457 x_negotiation_line_num in number,
458 x_org_id in number,
459 x_error_code out NOCOPY varchar2);
460 /*======================================================================
461 PROCEDURE : DELETE_NEGOTIATION_REF PUBLIC
462 PARAMETERS:
463 x_negotiation_id in auction header id
464 x_error_code out internal code for error
465
466 COMMENT : delete negotiation references
467 ======================================================================*/
468 PROCEDURE DELETE_NEGOTIATION_REF(x_negotiation_id in number,
469 x_error_code out NOCOPY varchar2);
470 /*======================================================================
471 PROCEDURE : CANCEL_NEGOTIATION_REF PUBLIC
472 PARAMETERS:
473 x_negotiation_id in auction header id
474 x_error_code out internal code for error
475
476 COMMENT : cancel negotiation references
477 ======================================================================*/
478 PROCEDURE CANCEL_NEGOTIATION_REF(x_negotiation_id in number,
479 x_error_code out NOCOPY varchar2);
483 x_old_negotiation_id in old auction header id
480 /*======================================================================
481 PROCEDURE : UPDATE_NEGOTIATION_REF PUBLIC
482 PARAMETERS:
484 x_old_negotiation_num in old auction display number
485 x_new_negotiation_id in new auction header id
486 x_new_negotiation_num in new auction display number
487 x_error_code out internal code for error
488 x_error_message out error message
489
490 COMMENT : update negotiation references
491 ======================================================================*/
492 PROCEDURE UPDATE_NEGOTIATION_REF(
493 x_old_negotiation_id in number,
494 x_old_negotiation_num in varchar2,
495 x_new_negotiation_id in number,
496 x_new_negotiation_num in varchar2,
497 x_error_code out NOCOPY varchar2,
498 x_error_message out NOCOPY varchar2);
499 /*======================================================================
500 PROCEDURE : COPY_BACKING_REQ PUBLIC
501 PARAMETERS:
502 x_old_negotiation_id in old auction header id
503 x_new_negotiation_id in new auction header id
504 x_error_code out internal code for error
505
506 COMMENT : update negotiation references
507 ======================================================================*/
508 /*======================================================================
509 PROCEDURE : CANCEL_NEGOTIATION_REF_BY_LINE PUBLIC
510 PARAMETERS:
511 x_negotiation_id in auction header id
512 x_negotiation_line_id in line number
513 x_error_code out internal code for error
514
515 COMMENT : cancel negotiation references
516 ======================================================================*/
517 PROCEDURE CANCEL_NEGOTIATION_REF_BY_LINE(x_negotiation_id in number,
518 x_negotiation_line_id in number,
519 x_error_code out NOCOPY varchar2);
520
521 PROCEDURE COPY_BACKING_REQ(x_old_negotiation_id in number,
522 x_new_negotiation_id in number,
523 x_error_code out NOCOPY varchar2);
524
525 PROCEDURE Check_Unique_Wrapper(X_Segment1 In VARCHAR2,
526 X_rowid IN VARCHAR2,
527 X_Type_lookup_code IN VARCHAR2,
528 X_bid_number IN NUMBER,
529 X_Unique OUT NOCOPY VARCHAR2);
530
531 FUNCTION CHECK_UNIQUE_ORDER_NUMBER (p_auction_id IN NUMBER,
532 p_order_number IN VARCHAR2,
533 p_bid_number IN NUMBER)
534 RETURN VARCHAR2;
535
536
537 PROCEDURE ACK_NOTIF_RESPONSE(p_wf_item_key VARCHAR2,
538 p_user_name VARCHAR2,
539 p_supp_ack VARCHAR2,
540 p_ack_note VARCHAR2);
541
542 PROCEDURE ACK_NOTIF_RESPONSE(p_wf_item_key VARCHAR2,
543 p_user_name VARCHAR2,
544 p_supp_ack VARCHAR2,
545 p_ack_note VARCHAR2,
546 x_return_status OUT NOCOPY NUMBER);
547
548 PROCEDURE GET_TIME_REMAINING(p_auction_header_id IN NUMBER, p_time_remaining OUT NOCOPY FLOAT);
549
550 function get_product_install_status ( x_product_name in varchar2) RETURN VARCHAR2;
551
552 SessionLanguage VARCHAR2(255);
553
554 PROCEDURE SET_SESSION_LANGUAGE(p_language VARCHAR2, p_language_code VARCHAR2);
555
556 PROCEDURE UNSET_SESSION_LANGUAGE;
557
558 FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)
559 RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;
560
561 procedure getTriangulationRate(toCurrency varchar2,
562 fromCurrency varchar2,
563 rateDate date,
564 rateType varchar2,
565 rollDays number,
566 rate out nocopy number);
567
568 function getClosestRate(fromCurrency varchar2,toCurrency varchar2, conversionDate date, conversionType varchar2, maxRollDays number) return varchar2;
569
570 PROCEDURE DELETE_NEGOTIATION_AMENDMENTS (
571 x_negotiation_id in number,
572 x_error_code out NOCOPY varchar2);
573
574
575 FUNCTION GET_MOST_RECENT_AMENDMENT(p_auction_header_id IN NUMBER) RETURN NUMBER;
576
577 FUNCTION GET_MEMBER_TYPE(p_auction_header_id IN NUMBER,p_user_id IN NUMBER) RETURN VARCHAR2;
578
579 PROCEDURE get_default_hdr_pb_settings (p_doctype_id IN NUMBER,
580 p_tp_id IN NUMBER,
581 x_price_break_response OUT NOCOPY VARCHAR2);
582
583 PROCEDURE get_default_pb_settings (p_auction_header_id IN NUMBER,
584 x_price_break_type OUT NOCOPY VARCHAR2,
585 x_price_break_neg_flag OUT NOCOPY VARCHAR2);
586
587 FUNCTION getPAOUInstalled (p_orgId IN NUMBER) RETURN VARCHAR2;
588
589 FUNCTION getGMSOUInstalled ( p_orgId IN NUMBER) RETURN VARCHAR2;
590
591 PROCEDURE IS_NEGOTIATION_REQ_BACKED(
592 p_auction_header_id IN NUMBER,
593 x_req_backed OUT NOCOPY VARCHAR2) ;
594
595 /*=======================================================================+
596 -- 12.0 Enhancement
597 -- SEND_TASK_ASSIGN_NOTIF procedure will be responsible to send
601 --
598 -- Notification to the given Collaboration Team Member
599 -- as requested by Negotiation Creator.
600 -- Parameter :
602 -- p_auction_header_id IN NUMBER,
603 -- p_user_id IN NUMBER,
604 -- x_return_status OUT NOCOPY VARCHAR2
605 +=========================================================================*/
606
607 PROCEDURE SEND_TASK_ASSIGN_NOTIF (p_auction_header_id IN NUMBER,
608 p_user_id IN NUMBER,
609 x_return_status OUT NOCOPY VARCHAR2);
610
611 /*=======================================================================+
612 -- 12.0 Enhancement
613 -- SEND_RESP_NOTIF procedure will be responsible for
614 -- sending notification to the Buyer when a Seller
615 -- submits a Response.
616 -- Parameter :
617 -- p_bid_number IN NUMBER,
618 -- x_return_status OUT NOCOPY VARCHAR2
619 --
620 +=========================================================================*/
621
622 PROCEDURE SEND_RESP_NOTIF ( p_bid_number IN NUMBER,
623 x_return_status OUT NOCOPY VARCHAR2);
624
625
626 /*=========================================================================+
627 -- 12.0 Enhancement
628 -- SEND_MSG_SENT_NOTIF procedure will be responsible for
629 -- sending notification to the Buyer when a Seller sends
630 -- a message to Buyer or a Buyer sends an internal message
631 -- to other Collaboration Team Members
632 -- Parameter :
633 -- p_toFirstName IN VARCHAR2
634 -- p_toLastName IN VARCHAR2
635 -- p_toCompanyName IN VARCHAR2
636 -- p_toCompanyId IN NUMBER
637 -- p_fromFirstName IN VARCHAR2
638 -- p_fromLastName IN VARCHAR2
639 -- p_fromCompanyName IN VARCHAR2
640 -- p_fromCompanyId IN NUMBER
641 -- p_creatorCompanyId IN NUMBER
642 -- p_userPartyId IN NUMBER
643 -- p_entryid IN NUMBER
644 -- p_message_type IN VARCHAR2
645 -- x_return_status OUT NOCOPY VARCHAR2
646 --
647 +=========================================================================*/
648
649 PROCEDURE SEND_MSG_SENT_NOTIF(
650 p_toFirstName IN VARCHAR2,
651 p_toLastName IN VARCHAR2,
652 p_toCompanyName IN VARCHAR2,
653 p_toCompanyId IN NUMBER,
654 p_fromFirstName IN VARCHAR2,
655 p_fromLastName IN VARCHAR2,
656 p_fromCompanyName IN VARCHAR2,
657 p_fromCompanyId IN NUMBER,
658 p_creatorCompanyId IN NUMBER,
659 p_userPartyId IN NUMBER,
660 p_entryid IN NUMBER,
661 p_message_type IN VARCHAR2,
662 x_return_status OUT NOCOPY VARCHAR2
663 );
664
665 /*=========================================================================+
666 -- 12.0 Enhancement
667 -- SEND_TASK_COMPL_NOTIF procedure will be responsible
668 -- for sending notification from the Buyer user to the
669 -- Negotiation Creator when the former completes a given
670 -- task for a Collaboration Team Member.
671 -- Parameter :
672 -- p_auction_header_id IN NUMBER,
673 -- p_user_id IN NUMBER,
674 -- x_return_status OUT NOCOPY VARCHAR2)
675 +=========================================================================*/
676
677 PROCEDURE SEND_TASK_COMPL_NOTIF ( p_auction_header_id IN NUMBER,
678 p_user_id IN NUMBER,
679 x_return_status OUT NOCOPY VARCHAR2);
680
681 /*=========================================================================+
682 --
683 -- 12.0 Enhancement
684 -- IS_NOTIF_SUBSCRIBED is a wrapper over the GET_NOTIF_PREFERENCE
685 -- of PON_WF_UTL_PKG. It will call the procedure GET_NOTIF_PREFERENCE with
686 -- appropriate message type and auction header id.
687 --
688 -- Parameter :
689 -- itemtype IN VARCHAR2
690 -- itemkey IN VARCHAR2
691 -- actid IN NUMBER
692 -- funcmode IN VARCHAR2
693 -- resultout OUT NOCOPY VARCHAR2
694 --
695 +=========================================================================*/
696
697
698 PROCEDURE IS_NOTIF_SUBSCRIBED(itemtype in varchar2,
699 itemkey in varchar2,
700 actid in number,
701 funcmode in varchar2,
702 resultout out NOCOPY varchar2);
703
704 /*=========================================================================+
705 --
706 -- 12.0 Enhancement
707 -- GET_MAPPED_IP_CATEGORY takes in a po category id as a parameter and
708 -- returns an ip category if mapping exists else returns -2
709 --
710 --
711 -- Parameter :
712 -- p_po_category_id IN NUMBER
713 --
714 +=========================================================================*/
715
716
717 FUNCTION GET_MAPPED_IP_CATEGORY(p_po_category_id IN NUMBER) return NUMBER;
718
719 /*=========================================================================+
720 --
721 -- 12.0 Enhancement
722 -- GET_MAPPED_PO_CATEGORY takes in an ip category id as a parameter and
723 -- returns a po category if mapping exists else returns -2
724 --
725 --
726 -- Parameter :
727 -- p_ip_category_id IN NUMBER
728 --
729 +=========================================================================*/
730
734
731
732 FUNCTION GET_MAPPED_PO_CATEGORY(p_ip_category_id IN NUMBER) return NUMBER;
733
735
736 PROCEDURE GET_NEGOTIATION_DETAILS( p_auction_header_id NUMBER,
737 p_user_trading_partner_id NUMBER,
738 x_time_left OUT NOCOPY VARCHAR2,
739 x_buyer_display OUT NOCOPY VARCHAR2,
740 x_carrier OUT NOCOPY VARCHAR2,
741 x_unlocked_by_display OUT NOCOPY VARCHAR2,
742 x_unsealed_by_display OUT NOCOPY VARCHAR2,
743 x_has_active_company_bid OUT NOCOPY VARCHAR2,
744 x_is_multi_site OUT NOCOPY VARCHAR2,
745 x_all_site_bid_on OUT NOCOPY VARCHAR2,
746 x_is_paused OUT NOCOPY VARCHAR2,
747 x_outcome_display OUT NOCOPY VARCHAR2,
748 x_advances_flag OUT NOCOPY VARCHAR2,
749 x_retainage_flag OUT NOCOPY VARCHAR2,
750 x_payment_rate_rype_enabled OUT NOCOPY VARCHAR2
751 );
752
753 ---------------------------------------------------------------------------------------
754 -- R12 Rollup1 Enhancement - Countdown Clock Project (adsahay)
755 --
756 -- Start of comments
757 -- API Name: SHOW_COUNTDOWN
758 -- Function: Given an auction id, returns "Y" if the auction is active or paused and
759 -- closing within next 24 hours. Auctions that are in preview mode,
760 -- cancelled or amended, or closing in more than 24 hours return "N".
761 -- Parameters:
762 -- IN: p_auction_header_id IN NUMBER - Auction header id
763 -- OUT: x_return_status OUT NOCOPY VARCHAR2 - Return status
764 -- x_error_code OUT NOCOPY VARCHAR2 - Error code
765 -- x_error_message OUT NOCOPY VARCHAR2 - Error message
766 --
767 -- End of Comments
768 -- Return : l_show_countdown VARCHAR2
769 ----------------------------------------------------------------------------------------
770
771 FUNCTION SHOW_COUNTDOWN(x_result OUT NOCOPY VARCHAR2,
772 x_error_code OUT NOCOPY VARCHAR2,
773 x_error_message OUT NOCOPY VARCHAR2,
774 p_auction_header_id in NUMBER) return VARCHAR2;
775
776 -----------------------------------------------------------------------------------
777 -- R12 Rollup1 Enhancement - Countdown Clock Project (adsahay)
778 --
779 -- Start of comments
780 -- API Name: HAS_DISTINCT_CLOSING_LINES
781 -- Function: Given an auction id, Returns 'Y' if the auction has lines
782 -- closing in different times, else 'N'. This means that either the auction is
783 -- staggered or has "auto extend" feature enabled such that it extends one line
784 -- instead of all lines.
785 --
786 -- Parameters:
787 -- IN: p_auction_header_id IN NUMBER - The auction header id
788 -- OUT: x_return_status OUT NOCOPY VARCHAR2 - Return status
789 -- x_error_code OUT NOCOPY VARCHAR2 - Error code
790 -- x_error_message OUT NOCOPY VARCHAR2 - Error message
791 --
792 -- End of Comments
793 --
794 -- Return : l_flag VARCHAR2
795 ------------------------------------------------------------------------------------
796
797 FUNCTION HAS_DISTINCT_CLOSING_DATES(x_result OUT NOCOPY VARCHAR2,
798 x_error_code OUT NOCOPY VARCHAR2,
799 x_error_message OUT NOCOPY VARCHAR2,
800 p_auction_header_id in NUMBER) return VARCHAR2;
801
802 -------------------------------------------------------------------------------------
803 -- R12 Rollup1 Enhancement - Two Part RFQ project (adsahay)
804 --
805 -- Two global variables two allow caching of the meanings of TECHNICAL
806 -- and COMMERCIAL, along with their getters.
807 -- Three global variables to store supplier attachment category names.
808 -------------------------------------------------------------------------------------
809
810 g_technical_attachment fnd_document_categories.name%TYPE := 'FromSupplierTechnical';
811 g_commercial_attachment fnd_document_categories.name%TYPE := 'FromSupplierCommercial';
812 g_supplier_attachment fnd_document_categories.name%TYPE := 'FromSupplier';
813
814 -- bug 6374353
815 -- create temporary table to store language and meanings of TECHNICAL and COMMERCIAL.
816 type two_part_cache_rec is record(
817 language fnd_lookup_values.language%TYPE,
818 technical_meaning fnd_lookups.meaning%TYPE,
819 commercial_meaning fnd_lookups.meaning%TYPE
820 );
821 type g_tp_cache_type is table of two_part_cache_rec index by BINARY_INTEGER;
822 g_two_part_cache g_tp_cache_type;
823
824 -----------------------------------------------------------------------------------
825 -- R12 Rollup1 Enhancement - Two Part RFQ Project (adsahay)
826 --
827 -- Start of comments
828 -- API Name: GET_TECHNICAL_MEANING
829 -- Function: Returns meaning of 'TECHNICAL' from lookups.
830 --
831 -- Parameters:
832 -- IN:
833 -- OUT:
834 --
835 -- End of Comments
836 --
837 -- Return : g_technical_meaning VARCHAR2
838 ------------------------------------------------------------------------------------
842 -----------------------------------------------------------------------------------
839 FUNCTION get_technical_meaning RETURN VARCHAR2;
840
841
843 -- R12 Rollup1 Enhancement - Two Part RFQ Project (adsahay)
844 --
845 -- Start of comments
846 -- API Name: GET_COMMERCIAL_MEANING
847 -- Function: Returns meaning of 'COMMERCIAL' from lookups.
848 --
849 -- Parameters:
850 -- IN:
851 -- OUT:
852 --
853 -- End of Comments
854 --
855 -- Return : g_commercial_meaning VARCHAR2
856 ------------------------------------------------------------------------------------
857 FUNCTION get_commercial_meaning RETURN VARCHAR2;
858
859 -----------------------------------------------------------------------------------
860 -- R12 Rollup1 Enhancement - Two Part RFQ Project (adsahay)
861 --
862 -- Start of comments
863 -- API Name: NOTIFY_BIDDERS_TECH_COMPLETE
864 -- Procedure: Notify bidders that their bids have/have not been short listed
865 -- in technical evaluation.
866 --
867 -- Parameters:
868 -- IN: p_auction_header_id IN NUMBER - The auction header id.
869 -- OUT: x_return_status OUT NOCOPY VARCHAR2 - Return status
870 -- x_error_code OUT NOCOPY VARCHAR2 - Error code
871 -- x_error_message OUT NOCOPY VARCHAR2 - Error message
872 --
873 -- End of Comments
874 ------------------------------------------------------------------------------------
875 PROCEDURE notify_bidders_tech_complete(x_return_status OUT NOCOPY VARCHAR2,
876 x_error_code OUT NOCOPY VARCHAR2 ,
877 x_error_message OUT NOCOPY VARCHAR2,
878 p_auction_header_id IN NUMBER);
879
880 /*======================================================================
881 FUNCTION : GET_AUCTION_STATUS_DISPLAY PUBLIC
882 PARAMETERS:
883 p_auction_header_id in auction header id
884 p_user_trading_partner_id in trading partner id of the user
885 currently running the application
886 COMMENT : Returns the negotiation status that has to be displayed to the user.
887 This function will be used in the select lists of various VOs that need
888 to query auction status
889 ======================================================================*/
890 FUNCTION GET_AUCTION_STATUS_DISPLAY(
891 p_auction_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,
892 p_user_trading_partner_id IN pon_auction_headers_all.TRADING_PARTNER_ID%TYPE) RETURN VARCHAR2;
893
894 /*======================================================================
895 FUNCTION : GET_MONITOR_IMAGE_AND_STATUS PUBLIC
896 PARAMETERS:
897
898 p_auction_header_id IN header id of teh auction
899 p_doctype_id IN the document type id of the negotiation
900 p_bid_visibility IN bid visibility
901 p_sealed_auction_status IN sealed status of the negotiation
902 p_auctioneer_id IN id of the negotiation creator
903 p_viewer_id IN id of the person view the negotiation
904 p_has_items IN flag to indicate the existence of lines
905 p_doc_type IN document type of the negotiation
906 p_auction_status IN the auction status
907 p_view_by_date IN
908 p_open_bidding_date IN The date on which bidding starts
909 p_has_scoring_teams_flag IN flag to indicate existence of scoring teams
910 p_user_trading_partner_id IN the trading partner id of the user
911 x_buyer_monitor_image OUT the image that should be used for monitor auction icons
912 x_auction_status_display OUT the auction status for display
913
914 COMMENT : This procedure will be used in the getters of the Monitor Image attributs
915 of various VOs. The procedures calls the existing PON_OA_UTIL_PKG.BUYER_MONITOR_IMAGE
916 and GET_AUCTION_STATUS_DISPLAY at one go and returns the image and status together to the middle
917 tier. this is done to improve the efficiency of the code and avoid multiple jdbc calls,
918 one for the image and the other for the auction status.
919 ======================================================================*/
920 PROCEDURE GET_MONITOR_IMAGE_AND_STATUS(
921 p_auction_header_id IN NUMBER,
922 p_doctype_id IN NUMBER,
923 p_bid_visibility IN VARCHAR2,
924 p_sealed_auction_status IN VARCHAR2,
925 p_auctioneer_id IN NUMBER,
926 p_viewer_id IN NUMBER,
927 p_has_items IN VARCHAR2,
928 p_doc_type IN VARCHAR2,
929 p_auction_status IN VARCHAR2,
930 p_view_by_date IN DATE,
931 p_open_bidding_date IN DATE,
932 p_has_scoring_teams_flag IN VARCHAR2,
933 p_user_trading_partner_id IN NUMBER,
934 x_buyer_monitor_image OUT NOCOPY VARCHAR2,
935 x_auction_status_display OUT NOCOPY VARCHAR2);
936
937 --========================================================================
938 -- PROCEDURE : GET_NEGOTIATION_STATUS
939 -- PARAMETERS:
940 -- p_auction_status - The auction_status column
941 -- p_is_paused - is_paused column
942 -- p_view_by_date - view_by_date column
943 -- p_open_bidding_date - open_bidding_date column
944 -- p_close_bidding_date - close_bidding_date column
945 -- p_award_status - award_status column
949 -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
946 -- p_award_approval_status - award_approval_status column
947 -- p_outcome_status - outcome_status column
948 --
950 -- view to get the value for the negotiation_status
951 -- column in the view. Prior to the use of this function the
952 -- same code existed as decodes in the view itself.
953 --========================================================================
954 FUNCTION GET_NEGOTIATION_STATUS (
955 p_auction_status VARCHAR2,
956 p_is_paused VARCHAR2,
957 p_view_by_date DATE,
958 p_open_bidding_date DATE,
959 p_close_bidding_date DATE,
960 p_award_status VARCHAR2,
961 p_award_approval_status VARCHAR2,
962 p_outcome_status VARCHAR2
963 ) RETURN VARCHAR2;
964
965 --========================================================================
966 -- PROCEDURE : GET_SUPPL_NEGOTIATION_STATUS
967 -- PARAMETERS:
968 -- p_auction_status - The auction_status column
969 -- p_is_paused - is_paused column
970 -- p_view_by_date - view_by_date column
971 -- p_open_bidding_date - open_bidding_date column
972 -- p_close_bidding_date - close_bidding_date column
973 --
974 -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
975 -- view to get the value for the suppl_negotiation_status
976 -- column in the view. Prior to the use of this function the
977 -- same code existed as decodes in the view itself.
978 --========================================================================
979 FUNCTION GET_SUPPL_NEGOTIATION_STATUS (
980 p_auction_status IN VARCHAR2,
981 p_is_paused IN VARCHAR2,
982 p_view_by_date IN DATE,
983 p_open_bidding_date IN DATE,
984 p_close_bidding_date IN DATE
985 ) RETURN VARCHAR2;
986
987 /*============================================================================================================*
988 * PROCEDURE : GET_DEFAULT_TIERS_INDICATOR *
989 * PARAMETERS: *
990 * p_contract_type - outcome of the negotiation *
991 * p_price_breaks_enabled - to indicate if price breaks are applicable as per po style *
992 * p_qty_price_tiers_enabled - to indicate if price tiers are applicable as per neg style *
993 * p_doctype_id - document type id of the negotiation *
994 * x_price_tiers_indicator - default price tiers indicator value. *
995 * *
996 * COMMENT : This procedure will be used in getting the default price tier indicator value. *
997 * It's used in plsql routines where new negotiation created from autocreation and renegotiation. *
998 * The logic is same as AuctionHeadersAllEO.getPriceTiersPoplist. Only difference is that we *
999 * don't have to return the poplist here. So few conditions where default values is same can be *
1000 * clubbeb together. *
1001 * ===========================================================================================================*/
1002 PROCEDURE GET_DEFAULT_TIERS_INDICATOR (
1003 p_contract_type IN VARCHAR2,
1004 p_price_breaks_enabled IN VARCHAR2,
1005 p_qty_price_tiers_enabled IN VARCHAR2,
1006 p_doctype_id IN NUMBER,
1007 x_price_tiers_indicator OUT NOCOPY VARCHAR2
1008 ) ;
1009
1010 ------------------------------------------------------------------------------
1011 --Start of Comments
1012 -- Bug Number: 8446265
1013 --Procedure:
1014 -- It returns the tokens replaced FND message to Notification Message Body
1015 --Procedure Usage:
1016 -- It is being used to replace the workflow message Body by FND Message & its tokens
1017 -- Procedures newly introduced:
1018 -- 1. GEN_PON_DSQBID_BODY
1019 -- 2. GEN_PON_ARI_UNINVITED_BODY
1020 -- 3. GEN_AWARD_LINES_BODY
1021 -- 4. GEN_AWARD_NOLINES_BODY
1022 -- 5. GEN_AWARD_EVENT_LINES_BODY
1023 -- 6. GEN_AWARD_EVENT_NOLINES_BODY
1024 -- 7. GEN_AUC_AMEND_BODY
1025 -- 8. GEN_INVITE_REQ_SUPP_RESP_BODY
1026 -- 9. GEN_INVITE_CONT_RESP_BODY
1027 -- 10. GEN_INVITE_ADD_CONT_RESP_BODY
1028 -- 11. GEN_INV_NEWRND_START_BODY
1029 -- 12. GEN_INV_NEWRND_START_AD_BODY
1030 --Parameters:
1031 -- itemtype, itemkey
1032 --IN:
1033 -- itemtype, item key
1034 --OUT:
1035 -- document
1036 --End of Comments
1037 ------------------------------------------------------------------------------
1038 --Bug 8446265 modification starts
1039 PROCEDURE GEN_PON_DSQBID_BODY(p_document_id IN VARCHAR2,
1040 display_type IN VARCHAR2,
1041 document IN OUT NOCOPY CLOB,
1042 document_type IN OUT NOCOPY VARCHAR2);
1043
1044 PROCEDURE GEN_PON_ARI_UNINVITED_BODY(p_document_id IN VARCHAR2,
1045 display_type IN VARCHAR2,
1046 document IN OUT NOCOPY CLOB,
1047 document_type IN OUT NOCOPY VARCHAR2);
1048
1049 PROCEDURE GEN_AWARD_LINES_BODY(p_document_id IN VARCHAR2,
1050 display_type IN VARCHAR2,
1051 document IN OUT NOCOPY CLOB,
1052 document_type IN OUT NOCOPY VARCHAR2);
1053
1054 PROCEDURE GEN_AWARD_NOLINES_BODY(p_document_id IN VARCHAR2,
1055 display_type IN VARCHAR2,
1056 document IN OUT NOCOPY CLOB,
1057 document_type IN OUT NOCOPY VARCHAR2);
1058
1059 PROCEDURE GEN_AWARD_EVENT_LINES_BODY(p_document_id IN VARCHAR2,
1060 display_type IN VARCHAR2,
1061 document IN OUT NOCOPY CLOB,
1062 document_type IN OUT NOCOPY VARCHAR2);
1063
1064 PROCEDURE GEN_AWARD_EVENT_NOLINES_BODY(p_document_id IN VARCHAR2,
1065 display_type IN VARCHAR2,
1066 document IN OUT NOCOPY CLOB,
1067 document_type IN OUT NOCOPY VARCHAR2);
1068
1069 PROCEDURE GEN_AUC_AMEND_BODY(p_document_id IN VARCHAR2,
1070 display_type IN VARCHAR2,
1071 document IN OUT NOCOPY CLOB,
1072 document_type IN OUT NOCOPY VARCHAR2);
1073
1074 PROCEDURE GEN_INVITE_REQ_SUPP_RESP_BODY(p_document_id IN VARCHAR2,
1075 display_type IN VARCHAR2,
1076 document IN OUT NOCOPY CLOB,
1077 document_type IN OUT NOCOPY VARCHAR2);
1078
1079
1080 PROCEDURE GEN_INVITE_CONT_RESP_BODY(p_document_id IN VARCHAR2,
1081 display_type IN VARCHAR2,
1082 document IN OUT NOCOPY CLOB,
1083 document_type IN OUT NOCOPY VARCHAR2);
1084
1085
1086
1087 PROCEDURE GEN_INVITE_ADD_CONT_RESP_BODY(p_document_id IN VARCHAR2,
1088 display_type IN VARCHAR2,
1089 document IN OUT NOCOPY CLOB,
1090 document_type IN OUT NOCOPY VARCHAR2);
1091
1092
1093
1094 PROCEDURE GEN_INV_NEWRND_START_BODY(p_document_id IN VARCHAR2,
1095 display_type IN VARCHAR2,
1096 document IN OUT NOCOPY CLOB,
1097 document_type IN OUT NOCOPY VARCHAR2);
1098
1099
1100
1101 PROCEDURE GEN_INV_NEWRND_START_AD_BODY(p_document_id IN VARCHAR2,
1102 display_type IN VARCHAR2,
1103 document IN OUT NOCOPY CLOB,
1104 document_type IN OUT NOCOPY VARCHAR2);
1105 --Bug 8446265 modification ends
1106
1107 --test FBO project
1108 PROCEDURE NOTIFY_REQUESTOR_PUBLISH( itemtype in varchar2,
1109 itemkey in varchar2,
1110 actid in number,
1111 uncmode in varchar2,
1112 resultout out NOCOPY varchar2);
1113
1114 PROCEDURE EMAIL_REQUESTORS(p_itemtype IN VARCHAR2,
1115 p_itemkey IN VARCHAR2,
1116 p_actid IN NUMBER,
1117 p_message_name IN VARCHAR2,
1118 p_notification_id OUT NOCOPY NUMBER);
1119
1120 FUNCTION get_all_pr_number(p_auction_header_id IN NUMBER)
1121 RETURN VARCHAR2;
1122
1123 -- Begin Supplier Management: Bug 9222914
1124 PROCEDURE SYNC_BID_HEADER_ATTACHMENTS(p_auction_header_id IN NUMBER);
1125 -- END Supplier Management: Bug 9222914
1126
1127 -- Begin Supplier Management: Bug 10378806 / 11071755
1128 PROCEDURE GEN_REQ_SUPP_AUC_AMEND_BODY(p_document_id IN VARCHAR2,
1129 display_type IN VARCHAR2,
1130 document IN OUT NOCOPY CLOB,
1131 document_type IN OUT NOCOPY VARCHAR2);
1132
1133 PROCEDURE GEN_INV_REQ_SUPP_NEWRND_BODY(p_document_id IN VARCHAR2,
1134 display_type IN VARCHAR2,
1135 document IN OUT NOCOPY CLOB,
1136 document_type IN OUT NOCOPY VARCHAR2);
1137
1138 PROCEDURE IS_SM_ENABLED(itemtype IN VARCHAR2,
1139 itemkey IN VARCHAR2,
1140 actid IN NUMBER,
1141 funcmode IN VARCHAR2,
1142 resultout OUT NOCOPY VARCHAR2);
1143 -- End Supplier Management: Bug 10378806 / 11071755
1144
1145 -- Added for the bug#8847938 to remove the space as delimitter in user name
1146
1147 PROCEDURE string_to_userTable(p_UserList in VARCHAR2,
1148 p_UserTable out NOCOPY WF_DIRECTORY.UserTable);
1149
1150 --for populating requisition references in pon_backing_requisitions table
1151 PROCEDURE POPULATE_PON_PR_REFS(p_auction_header_id IN NUMBER,
1152 p_auction_line_number IN PO_TBL_NUMBER,
1153 p_requisition_line_id IN PO_TBL_NUMBER,
1154 x_return_status OUT NOCOPY VARCHAR2,
1155 x_error_msg OUT NOCOPY VARCHAR2,
1156 x_no_of_rows_inserted OUT NOCOPY NUMBER);
1157
1158 g_log_module_name varchar2(30) := 'PON_AUCTION_PKG';
1159
1160 END PON_AUCTION_PKG;