1 PACKAGE PON_OA_UTIL_PKG AUTHID CURRENT_USER as
2 /* $Header: PONOAUTS.pls 120.6 2007/05/24 09:20:48 mshujath ship $ */
3
4
5 /*======================================================================
6 FUNCTION : MONITOR PUBLIC
7 PARAMETERS:
8 p_doctype_id IN document type id
9 p_bid_visibility IN bid visibility
10 p_sealed_auction_status IN sealed auction status
11 p_auctioneer_id IN auctioneer trading partner id
12 p_viewer_id IN viewer trading partner id
13 p_startdate IN auction start date
14 p_has_items IN has Items Flag for negotiation
15
16 COMMENT : check if monitor icon should be active or not
17 ======================================================================*/
18
19 FUNCTION MONITOR (p_doctype_id IN NUMBER,
20 p_bid_visibility IN VARCHAR2,
21 p_sealed_auction_status IN VARCHAR2,
22 p_auctioneer_id IN NUMBER,
23 p_viewer_id IN NUMBER,
24 p_startdate IN DATE DEFAULT NULL,
25 p_has_items IN VARCHAR2) RETURN VARCHAR2;
26
27 /*======================================================================
28 FUNCTION : BUYER_MONITOR PUBLIC
29 PARAMETERS:
30 p_doctype_id IN document type id
31 p_bid_visibility IN bid visibility
32 p_sealed_auction_status IN sealed auction status
33 p_auctioneer_id IN auctioneer trading partner id
34 p_viewer_id IN viewer trading partner id
35 p_has_items IN has Items Flag for negotiation
36 p_doc_type IN Type of the negotiation(RFI,RFQ,AUCTION)
37 p_auction_status IN Status of the auction
38 p_view_by_date IN Preview date of the auction
39 p_open_bidding_date IN Open bidding date of the negotiation
40 p_auction_header_id IN Auction Header Id
41 p_has_scoring_teams_flag IN If auction has scoring teams
42
43 COMMENT : check if monitor icon should be active or not for buyer homepage and search page
44 ======================================================================*/
45 FUNCTION BUYER_MONITOR (p_doctype_id IN NUMBER,
46 p_bid_visibility IN VARCHAR2,
47 p_sealed_auction_status IN VARCHAR2,
48 p_auctioneer_id IN NUMBER,
49 p_viewer_id IN NUMBER,
50 p_has_items IN VARCHAR2,
51 p_doc_type IN VARCHAR2,
52 p_auction_status IN VARCHAR2,
53 p_view_by_date IN DATE,
54 p_open_bidding_date IN DATE,
55 p_auction_header_id IN NUMBER,
56 p_has_scoring_teams_flag IN VARCHAR2) RETURN VARCHAR2;
57
58 /*======================================================================
59 FUNCTION : MONITOR_IMAGE PUBLIC
60 PARAMETERS:
61 p_doctype_id IN document type id
62 p_bid_visibility IN bid visibility
63 p_sealed_auction_status IN sealed auction status
64 p_auctioneer_id IN auctioneer trading partner id
65 p_viewer_id IN viewer trading partner id
66 p_startdate IN auction start date
67 p_has_items IN has Items Flag for negotiation
68
69
70 COMMENT : return the monitor image name, either 'MonitorActive'
71 or 'MonitorInactive'
72 ======================================================================*/
73
74 FUNCTION MONITOR_IMAGE (p_doctype_id IN NUMBER,
75 p_bid_visibility IN VARCHAR2,
76 p_sealed_auction_status IN VARCHAR2,
77 p_auctioneer_id IN NUMBER,
78 p_viewer_id IN NUMBER,
79 p_startdate IN DATE DEFAULT NULL,
80 p_has_items IN VARCHAR2) RETURN VARCHAR2;
81
82 /*======================================================================
83 FUNCTION : BUYER_MONITOR_IMAGE PUBLIC
84 PARAMETERS:
85 p_doctype_id IN document type id
86 p_bid_visibility IN bid visibility
87 p_sealed_auction_status IN sealed auction status
88 p_auctioneer_id IN auctioneer trading partner id
89 p_viewer_id IN viewer trading partner id
90 p_has_items IN has Items Flag for negotiation
91 p_doc_type IN Type of the negotiation(RFI,RFQ,AUCTION)
92 p_auction_status IN Status of the auction
93 p_view_by_date IN Preview date of the auction
94 p_open_bidding_date IN Open bidding date of the negotiation
95 p_auction_header_id IN Auction Header Id
96 p_has_scoring_teams_flag IN If auction has scoring teams
97
98 COMMENT : return the monitor image name, either 'MonitorActive'
99 or 'MonitorInactive'
100 In OA 5.6, we use switcher bean to implement monitor column.
101 In OA 5.7, we can just use a simple region item.
102 ======================================================================*/
103 FUNCTION BUYER_MONITOR_IMAGE (p_doctype_id IN NUMBER,
104 p_bid_visibility IN VARCHAR2,
105 p_sealed_auction_status IN VARCHAR2,
106 p_auctioneer_id IN NUMBER,
107 p_viewer_id IN NUMBER,
108 p_has_items IN VARCHAR2,
109 p_doc_type IN VARCHAR2,
110 p_auction_status IN VARCHAR2,
111 p_view_by_date IN DATE,
112 p_open_bidding_date IN DATE,
113 p_auction_header_id IN NUMBER,
114 p_has_scoring_teams_flag IN VARCHAR2) RETURN VARCHAR2;
115 /*======================================================================
116 FUNCTION : DICUSSION_URL PUBLIC
117 PARAMETERS:
118 p_auction_id IN auction header id
119 p_viewer_party_id IN viewer's trading partner id
120 p_app IN app name
121 p_subtab_pos IN subtab position
122
123 COMMENT : returns javascript for discussion icon
124 ======================================================================*/
125
126 FUNCTION DISCUSSION_URL (p_auction_id IN NUMBER,
127 p_viewer_party_id IN NUMBER,
128 p_app IN VARCHAR2,
129 p_subtab_pos IN VARCHAR2) RETURN VARCHAR2;
130
131
132 /*======================================================================
133 FUNCTION : TIME_REMAINING_CLOSE_DATE PUBLIC
134 PARAMETERS:
135 p_startdate IN auction start date
136 p_enddate IN auction end date
137 p_client_timezone_id IN client (viewer) time zone id
138 p_server_timezone_id IN server time zone id
139 p_date_format IN date format
140
141 COMMENT : returns html formatted string of time remaining and close date
142 ======================================================================*/
143 /*
144 FUNCTION TIME_REMAINING_CLOSE_DATE(p_startdate IN DATE DEFAULT NULL,
145 p_enddate IN DATE DEFAULT NULL,
146 p_client_timezone_id IN VARCHAR2,
147 p_server_timezone_id IN VARCHAR2,
148 p_date_format IN VARCHAR2) RETURN VARCHAR2;
149 */
150 /*======================================================================
151 FUNCTION : TIME_REMAINING_CLOSE_DATE_NOTZ PUBLIC
152 PARAMETERS:
153 p_startdate IN auction start date
154 p_enddate IN auction end date
155 p_client_timezone_id IN client (viewer) time zone id
156 p_server_timezone_id IN server time zone id
157 p_date_format IN date format
158
159
160 COMMENT : returns html formatted string of time remaining and close date
161 without timezone at end
162 ======================================================================*/
163 /*
164 FUNCTION TIME_REMAINING_CLOSE_DATE_NOTZ(p_startdate IN DATE DEFAULT NULL,
165 p_enddate IN DATE DEFAULT NULL,
166 p_client_timezone_id IN VARCHAR2,
167 p_server_timezone_id IN VARCHAR2,
168 p_date_format IN VARCHAR2) RETURN VARCHAR2;
169 */
170
171 /*======================================================================
172 FUNCTION : GET_TIMEZONE_DISP PUBLIC
173 PARAMETERS:
174 p_client_timezone_id IN client (viewer) time zone id
175 p_server_timezone_id IN server time zone id
176
177
178 COMMENT : returns timezone to display
179 ======================================================================*/
180
181 FUNCTION GET_TIMEZONE_DISP(p_client_timezone_id IN VARCHAR2,
182 p_server_timezone_id IN VARCHAR2) RETURN VARCHAR2;
183
184
185
186 /*======================================================================
187 FUNCTION : TIME_REMAINING_SLASH_CLOSE PUBLIC
188 PARAMETERS:
189 p_startdate IN auction start date
190 p_enddate IN auction end date
191 p_client_timezone_id IN client (viewer) time zone id
192 p_server_timezone_id IN server time zone id
193 p_date_format IN date format
194 p_days_string IN translated 'PON_AUCTION_DAYS'
195 p_day_string IN translated 'PON_AUCTION_DAY'
196 p_hours_string IN translated 'PON_AUCTION_HOURS'
197 p_hour_string IN translated 'PON_AUCTION_HOUR'
198 p_minutes_string IN translated 'PON_AUCTION_MINUTES'
199 p_minute_string IN translated 'PON_AUCTION_MINUTE'
200
201 COMMENT : returns html formatted string of time remaining and close date
202 ======================================================================*/
203 /*
204 FUNCTION TIME_REMAINING_SLASH_CLOSE(
205 p_startdate IN DATE DEFAULT NULL,
206 p_enddate IN DATE DEFAULT NULL,
207 p_client_timezone_id IN VARCHAR2,
208 p_server_timezone_id IN VARCHAR2,
209 p_date_format IN VARCHAR2,
210 p_days_string IN VARCHAR2,
211 p_day_string IN VARCHAR2,
212 p_hours_string IN VARCHAR2,
213 p_hour_string IN VARCHAR2,
214 p_minutes_string IN VARCHAR2,
215 p_minute_string IN VARCHAR2) RETURN VARCHAR2;
216 */
217 /*======================================================================
218 FUNCTION : TIME_REMAINING_SLASH_CLOSE PUBLIC
219 PARAMETERS:
220 p_startdate IN auction start date
221 p_enddate IN auction end date
222 p_client_timezone_id IN client (viewer) time zone id
223 p_server_timezone_id IN server time zone id
224 p_date_format IN date format
225
226 COMMENT : returns html formatted string of time remaining and close date
227 ======================================================================*/
228 /*
229 FUNCTION TIME_REMAINING_SLASH_CLOSE(
230 p_startdate IN DATE DEFAULT NULL,
231 p_enddate IN DATE DEFAULT NULL,
232 p_client_timezone_id IN VARCHAR2,
233 p_server_timezone_id IN VARCHAR2,
234 p_date_format IN VARCHAR2) RETURN VARCHAR2;
235 */
236 /*======================================================================
237 FUNCTION : DISPLAY_DATE_TIME PUBLIC
238 PARAMETERS:
239 p_date IN a date value
240 p_client_timezone_id IN client (viewer) time zone id
241 p_server_timezone_id IN server time zone id
242 p_date_format IN date format
243 p_display_timzezone IN whether to display time zone
244
245 COMMENT : returns date and time converted to client time zone
246 assumes the passed in date is in server time zone
247 ======================================================================*/
248
249 FUNCTION DISPLAY_DATE_TIME(p_date IN DATE DEFAULT NULL,
250 p_client_timezone_id IN VARCHAR2,
251 p_server_timezone_id IN VARCHAR2,
252 p_date_format IN VARCHAR2,
253 p_display_timezone IN VARCHAR2 DEFAULT 'Y') RETURN VARCHAR2;
254
255 /*======================================================================
256 FUNCTION : RESPONSE_VIEWMORENEGS PUBLIC
257 PARAMETERS:
258 p_auctioneer_id IN auctioneer trading partner id
259 p_viewer_tp_id IN viewer trading partner id,
260 p_query_type IN query type
261 p_number_of_bids IN number of bids
262 p_bid_visibility IN bid visibility code
263 p_sealed_auction_status IN sealed auction status
264
265 COMMENT : calculates value for response column in view more negotiations
266 page
267 ======================================================================*/
268
269 FUNCTION RESPONSE_VIEWMORENEGS (p_auctioneer_id IN NUMBER,
270 p_viewer_tp_id IN NUMBER,
271 p_query_type IN VARCHAR2,
272 p_number_of_bids IN NUMBER,
273 p_bid_visibility IN VARCHAR2,
274 p_sealed_auction_status IN VARCHAR2) RETURN VARCHAR2;
275
276
277 /*======================================================================
278 FUNCTION : RESPONSE_VIEWAUCTIONS PUBLIC
279 PARAMETERS:
280 p_auctioneer_id IN auctioneer trading partner id
281 p_viewer_tp_id IN viewer trading partner id,
282 p_number_of_bids IN number of bids
283 p_bid_visibility IN bid visibility code
284 p_sealed_auction_status IN sealed auction status
285
286 COMMENT : calculates value for response column in view auctions page
287 ======================================================================*/
288
289 FUNCTION RESPONSE_VIEWAUCTIONS (p_auctioneer_id IN NUMBER,
290 p_viewer_tp_id IN NUMBER,
291 p_number_of_bids IN NUMBER,
292 p_bid_visibility IN VARCHAR2,
293 p_sealed_auction_status IN VARCHAR2) RETURN VARCHAR2;
294
295
296 /*======================================================================
297 FUNCTION : RESPONSE_VIEWACTIVEBIDS PUBLIC
298 PARAMETERS:
299 p_auction_id IN auction header id
300 p_auction_status IN auction status
301 p_auctioneer_id IN auctioneer trading partner id
302 p_viewer_tp_id IN viewer trading partner id,
303 p_viewer_tpc_id IN viewer trading partner contact id,
304 p_bid_visibility IN bid visibility code
305 p_sealed_auction_status IN sealed auction status
306 p_bidStatus IN bid status
307 p_bidder_tpc_id IN bidder trading partner contact id
308
309 COMMENT : calculates value for number of bids column in the ViewActiveBids page
310 ======================================================================*/
311
312 FUNCTION RESPONSE_VIEWACTIVEBIDS (p_auction_id IN NUMBER,
313 p_auction_status IN VARCHAR2,
314 p_auctioneer_id IN NUMBER,
315 p_viewer_tp_id IN NUMBER,
316 p_viewer_tpc_id IN NUMBER,
317 p_bid_visibility IN VARCHAR2,
318 p_sealed_auction_status IN VARCHAR2,
319 p_bidStatus IN VARCHAR2,
320 p_bidder_tpc_id IN NUMBER) RETURN VARCHAR2;
321
322
323 /*======================================================================
324 FUNCTION : NUMBIDS_VIEWACTIVEBIDS PUBLIC
325 PARAMETERS:
326 p_number_of_bids IN number of bids
327 p_bid_visibility IN bid visibility code
328 p_sealed_auction_status IN sealed auction status
329
330 COMMENT : calculates value for number of bids column in the ViewActiveBids page
331 ======================================================================*/
332
333 FUNCTION NUMBIDS_VIEWACTIVEBIDS (p_number_of_bids IN NUMBER,
334 p_bid_visibility IN VARCHAR2,
335 p_sealed_auction_status IN VARCHAR2) RETURN VARCHAR2;
336
337
338 /*======================================================================
342
339 FUNCTION : TRUNCATE PUBLIC
340 PARAMETERS:
341 p_string IN input string
343 COMMENT : Truncate a large string to 30 chars appended by ...
344 ======================================================================*/
345
346
347
348 FUNCTION TRUNCATE (p_string IN VARCHAR2) RETURN VARCHAR2;
349
350 /*======================================================================
351 FUNCTION : TRUNCATE PUBLIC
352 PARAMETERS:
353 p_string IN input string
354 p_length IN truncation length
355
356 COMMENT : Truncate a large string appended by ...
357 ======================================================================*/
358 FUNCTION TRUNCATE (p_string IN VARCHAR2,
359 p_length IN NUMBER) RETURN VARCHAR2;
360
361
362 /*======================================================================
363 FUNCTION : TRUNCATE_DISPLAY_STRING PUBLIC
364 PARAMETERS:
365 p_string IN input string
366
367 COMMENT : Truncate a large string to 240 chars (default) appended by ...
368 This is equivalent to AuctionUtil.truncateDisplayString
369 ======================================================================*/
370
371 FUNCTION TRUNCATE_DISPLAY_STRING (p_string IN VARCHAR2) RETURN VARCHAR2;
372
373
374 /*======================================================================
375 FUNCTION : HTML_FORMATTED_HR_ADDRESS PUBLIC
376 PARAMETERS:
377 p_location_id IN location id for the address
378 p_language IN language
379 COMMENT : Returns aN html formatted address for the given location
380 ======================================================================*/
381 FUNCTION HTML_FORMATTED_HR_ADDRESS(p_location_id IN NUMBER,
382 p_language IN VARCHAR2) RETURN VARCHAR2;
383
384
385 /*======================================================================
386 FUNCTION : HTML_FORMATTED_EMAIL_STRING PUBLIC
387 PARAMETERS:
388 p_email1 IN input string
389 p_email2 IN input string
390
391 COMMENT : returns html formatted string of up to 2 email address.
392 If both emails are specified, they are separated by a slash.
393 This is currently used in ViewBiddersList to display
394 contact and additional contact emails.
395 ======================================================================*/
396
397
398
399 FUNCTION HTML_FORMATTED_EMAIL_STRING (p_email1 IN VARCHAR2,
400 p_email2 IN VARCHAR2) RETURN VARCHAR2;
401
402
403 /*======================================================================
404 FUNCTION : GET_HTML_FORMATTED_BID_STRING PUBLIC
405 PARAMETERS:
406 p_doctype_id IN doc type id
407 p_auction_header_id IN auction id
408 p_trading_partner_id IN supplier trading partner id
409 p_app_name IN application name
410
411 COMMENT : returns html formatted string of all active responses placed by
412 a supplier on a negotiation.
413 This is currently used in ViewBiddersList to display
414 the response column.
415 ======================================================================*/
416
417 FUNCTION GET_HTML_FORMATTED_BID_STRING (p_doctype_id IN NUMBER,
418 p_auction_header_id IN NUMBER,
419 p_trading_partner_id IN NUMBER,
420 p_app_name IN VARCHAR2) RETURN VARCHAR2;
421
422
423 /*======================================================================
424 FUNCTION : RESPONSE_VIEWBIDDERSLIST PUBLIC
425 PARAMETERS:
426 p_doc_type_id IN doc type id
427 p_auction_header_id IN auction id
428 p_auctioneer_id IN auctioneer trading partner id
429 p_viewer_tp_id IN viewer trading partner id,
430 p_trading_partner_id IN supplier trading partner id
431 p_bid_visibility IN bid visibility code
432 p_sealed_auction_status IN sealed auction status
433
434 COMMENT : calculates value for response column in view invitation list page
435 ======================================================================*/
436
437 FUNCTION RESPONSE_VIEWBIDDERSLIST (p_doctype_id IN NUMBER,
438 p_auction_header_id IN NUMBER,
439 p_auctioneer_id IN NUMBER,
440 p_viewer_tp_id IN NUMBER,
441 p_trading_partner_id IN NUMBER,
442 p_bid_visibility IN VARCHAR2,
443 p_sealed_auction_status IN VARCHAR2) RETURN VARCHAR2;
444
445
446 TYPE bizrules is TABLE OF pon_auc_doctype_rules.validity_flag%TYPE
447 INDEX BY BINARY_INTEGER;
448
449 /*======================================================================
450 FUNCTION : DISPLAY_DATE PUBLIC
451 PARAMETERS:
452 p_date IN a date value
453 p_client_timezone_id IN client (viewer) time zone id
454 p_server_timezone_id IN server time zone id
455 p_date_format IN date format
456 p_display_timzezone IN whether to display time zone
457
458 COMMENT : returns date converted to client time zone
459 assumes the passed in date is in server time zone
460 ======================================================================*/
461
465 p_date_format IN VARCHAR2,
462 FUNCTION DISPLAY_DATE(p_date IN DATE DEFAULT NULL,
463 p_client_timezone_id IN VARCHAR2,
464 p_server_timezone_id IN VARCHAR2,
466 p_display_timezone IN VARCHAR2 DEFAULT 'Y') RETURN VARCHAR2;
467
468 /*======================================================================
469 FUNCTION : CONVERT_DATE PUBLIC
470 PARAMETERS:
471 p_date IN a date value
472 p_client_timezone_id IN client (viewer) time zone id
473 p_server_timezone_id IN server time zone id
474
475 COMMENT : returns date converted to client's time zone
476 assumes the passed in date is in server time zone
477 ======================================================================*/
478
479 FUNCTION CONVERT_DATE(p_date IN DATE DEFAULT NULL,
480 p_client_timezone_id IN VARCHAR2,
481 p_server_timezone_id IN VARCHAR2) RETURN DATE;
482
483 /*======================================================================
484 FUNCTION : GET_ACTIVE_BID_COUNT PUBLIC
485 PARAMETERS:
486 p_auction_header_id IN auction id
487 p_line_number IN line number
488
489 COMMENT : Returns the number of active bids for the given auction's line
490 number.
491 ======================================================================*/
492
493 FUNCTION GET_ACTIVE_BID_COUNT (p_auction_header_id IN NUMBER,
494 p_line_number IN NUMBER)
495 RETURN NUMBER;
496
497 /*======================================================================
498 FUNCTION : TIME_REMAINING_ONLY_NOTZ PUBLIC
499 PARAMETERS:
500 p_startdate IN auction start date
501 p_enddate IN auction end date
502 p_client_timezone_id IN client (viewer) time zone id
503 p_server_timezone_id IN server time zone id
504 p_date_format IN date format
505
506 COMMENT : returns the time remaining if the close date is more than
507 31 days after today; else returns the actual close date
508 ======================================================================*/
509 /*
510 FUNCTION TIME_REMAINING_ONLY_NOTZ(p_startdate IN DATE DEFAULT NULL,
511 p_enddate IN DATE DEFAULT NULL,
512 p_client_timezone_id IN VARCHAR2,
513 p_server_timezone_id IN VARCHAR2,
514 p_date_format IN VARCHAR2) RETURN VARCHAR2;
515 */
516
517 FUNCTION BID_NUMBER_SORT (p_auction_id NUMBER,
518 p_auction_status IN VARCHAR2,
519 p_auctioneer_id IN NUMBER,
520 p_viewer_tp_id IN NUMBER,
521 p_viewer_tpc_id IN NUMBER,
522 p_bid_visibility IN VARCHAR2,
523 p_sealed_auction_status IN VARCHAR2,
524 p_bidStatus IN VARCHAR2,
525 p_bidder_tpc_id IN NUMBER,
526 p_bid_number IN NUMBER) RETURN NUMBER;
527
528 /*======================================================================
529 PROCEDURE: GET_DATABASE_VERSION PUBLIC
530 PARAMETERS:
531 p_version OUT A string which represents the internal software version
532 of the database (e.g., 7.1.0.0.0).
533 p_compatibility OUT The compatibility setting of the database determined
534 by the "compatible" init.ora parameter.
535
536 COMMENT : Returns the database version and compatibility setting
537 ======================================================================*/
538 procedure GET_DATABASE_VERSION (p_version OUT NOCOPY VARCHAR2,
539 p_compatibility OUT NOCOPY VARCHAR2);
540
541
542 /*======================================================================
543 PROCEDURE: CREATE_URL_ATTACHMENT PUBLIC
544 PARAMETERS:
545 COMMENT : This procedure is used to create url attachments
546 during spreadsheet upload
547 ======================================================================*/
548
549 PROCEDURE create_url_attachment(
550 p_seq_num in NUMBER,
551 p_category_name in VARCHAR2,
552 p_document_description in VARCHAR2,
553 p_datatype_id in NUMBER,
554 p_url in VARCHAR2,
555 p_entity_name in VARCHAR2,
556 p_pk1_value in VARCHAR2,
557 p_pk2_value in VARCHAR2,
558 p_pk3_value in VARCHAR2,
559 p_pk4_value in VARCHAR2,
560 p_pk5_value in VARCHAR2
561 );
562
563 /*=========================================================================+
564 --
565 -- 12.0 ECO 4749273 - SEND TO LIST BEHAVIOR CHANGE IN ONLINE DISCUSSION
566 --
567 -- GET_TEAM_MEMBER_CNT takes AUCTION_HEADER_ID,DISCUSSION_ID,
568 -- USER_ID and TRADING_PARTNER_CONTACT_ID as parameters and
569 --
570 --
571 -- Returns number of team members for given negotiation.
572 --
573 --
574 -- Parameter :
575 -- p_auction_header_id IN NUMBER
576 -- p_discussion_id IN NUMBER
577 -- p_user_id IN NUMBER,
578 -- p_trading_partner_contact_id IN NUMBER
579 --
580 +=========================================================================*/
581
582 FUNCTION GET_TEAM_MEMBER_CNT(p_auction_header_id IN NUMBER,
583 p_discussion_id IN NUMBER,
584 p_user_id IN NUMBER,
585 p_trading_partner_contact_id IN NUMBER)
586 return NUMBER;
587
588
589 /*======================================================================
590 FUNCTION : APPROVAL_CONDITION PUBLIC
591 PARAMETERS:
592 p_user_id IN User Id of the Buyer
593
594 COMMENT : Returns whether the Negotiation requires approval from
595 the manager of the buyer if present
596 ======================================================================*/
597 FUNCTION APPROVAL_CONDITION (p_user_id IN NUMBER) RETURN VARCHAR2;
598
599
600 END PON_OA_UTIL_PKG;