1 PACKAGE AP_WEB_AUDIT_UTILS AUTHID CURRENT_USER AS
2 /* $Header: apwaudus.pls 120.19 2006/08/14 22:02:38 qle noship $ */
3 /*=======================================================================+
4 | Declare PUBLIC Data Types and Variables
5 +=======================================================================*/
6
7 G_EXC_ERROR EXCEPTION;
8 G_EXC_UNEXPECTED_ERROR EXCEPTION;
9
10 /*========================================================================
11 | PUBLIC FUNCTION get_employee_info
12 |
13 | DESCRIPTION
14 | This function returns the employee info for a employee.
15 |
19 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
16 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
17 | Called from BC4J.
18 |
20 |
21 | RETURNS
22 | Employee info for the given user as VARCHAR2.
23 |
24 | PARAMETERS
25 | p_employee_id IN Employee identifier
26 | p_column IN Column from which the data is retrieved
27 | p_data_type IN Data type of the column from which the data is retrieved.
28 | Supported values: NUMBER, VARCHAR2, DATE
29 |
30 | MODIFICATION HISTORY
31 | Date Author Description of Changes
32 | 16-Aug-2002 J Rautiainen Created
33 |
34 *=======================================================================*/
35 FUNCTION get_employee_info(p_employee_id IN NUMBER,
36 p_column IN VARCHAR2,
37 p_data_type IN VARCHAR2) RETURN VARCHAR2;
38
39 /*========================================================================
40 | PUBLIC FUNCTION get_task_info
41 |
42 | DESCRIPTION
43 | This function returns the task info for a given task.
44 |
45 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
46 | Called from BC4J.
47 |
48 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
49 |
50 | RETURNS
51 | Task info as VARCHAR2.
52 |
53 | PARAMETERS
54 | p_task_id IN Task identifier
55 | p_column IN Column from which the data is retrieved
56 | p_data_type IN Data type of the column from which the data is retrieved.
57 | Supported values: NUMBER, VARCHAR2, DATE
58 |
59 | MODIFICATION HISTORY
60 | Date Author Description of Changes
61 | 22-Aug-2002 J Rautiainen Created
62 |
63 *=======================================================================*/
64 FUNCTION get_task_info(p_task_id IN NUMBER,
65 p_column IN VARCHAR2,
66 p_data_type IN VARCHAR2) RETURN VARCHAR2;
67
68 /*========================================================================
69 | PUBLIC FUNCTION get_project_info
70 |
71 | DESCRIPTION
72 | This function returns the project info for a given project.
73 |
74 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
75 | Called from BC4J.
76 |
77 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
78 |
79 | RETURNS
80 | Project info as VARCHAR2.
81 |
82 | PARAMETERS
83 | p_project_id IN Project identifier
84 | p_column IN Column from which the data is retrieved
85 | p_data_type IN Data type of the column from which the data is retrieved.
86 | Supported values: NUMBER, VARCHAR2, DATE
87 |
88 | MODIFICATION HISTORY
89 | Date Author Description of Changes
90 | 22-Aug-2002 J Rautiainen Created
91 |
92 *=======================================================================*/
93 FUNCTION get_project_info(p_project_id IN NUMBER,
94 p_column IN VARCHAR2,
95 p_data_type IN VARCHAR2) RETURN VARCHAR2;
96
97 /*========================================================================
98 | PUBLIC FUNCTION get_award_info
99 |
100 | DESCRIPTION
101 | This function returns the award info for a given award.
102 |
103 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
104 | Called from BC4J.
105 |
106 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
107 |
108 | RETURNS
109 | Project info as VARCHAR2.
110 |
111 | PARAMETERS
112 | p_award_id IN Award identifier
113 | p_column IN Column from which the data is retrieved
114 | p_data_type IN Data type of the column from which the data is retrieved.
115 | Supported values: NUMBER, VARCHAR2, DATE
116 |
117 | MODIFICATION HISTORY
118 | Date Author Description of Changes
119 | 22-Aug-2002 J Rautiainen Created
120 |
121 *=======================================================================*/
122 FUNCTION get_award_info(p_award_id IN NUMBER,
123 p_column IN VARCHAR2,
124 p_data_type IN VARCHAR2) RETURN VARCHAR2;
125
126 /*========================================================================
127 | PUBLIC FUNCTION get_awt_group_info
128 |
129 | DESCRIPTION
130 | This function returns the awt group info for a given awt group.
131 |
132 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
133 | Called from BC4J.
134 |
135 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
136 |
137 | RETURNS
138 | Awt Group info as VARCHAR2.
139 |
140 | PARAMETERS
141 | p_awt_group_id IN Awt group identifier
142 | p_column IN Column from which the data is retrieved
143 | p_data_type IN Data type of the column from which the data is retrieved.
144 | Supported values: NUMBER, VARCHAR2, DATE
145 |
146 | MODIFICATION HISTORY
147 | Date Author Description of Changes
148 | 22-Aug-2002 J Rautiainen Created
149 |
150 *=======================================================================*/
151 FUNCTION get_awt_group_info(p_awt_group_id IN NUMBER,
152 p_column IN VARCHAR2,
156 | PUBLIC FUNCTION get_tax_code_info
153 p_data_type IN VARCHAR2) RETURN VARCHAR2;
154
155 /*========================================================================
157 |
158 | DESCRIPTION
159 | This function returns the tax code info for a given tax code based.
160 | on either tax code id or tax code name.
161 |
162 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
163 | Called from BC4J.
164 |
165 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
166 |
167 | RETURNS
168 | Tax code info as VARCHAR2.
169 |
170 | PARAMETERS
171 | p_tax_id IN Tax code identifier
172 | p_name IN Tax code name
173 | p_column IN Column from which the data is retrieved
174 | p_data_type IN Data type of the column from which the data is retrieved.
175 | Supported values: NUMBER, VARCHAR2, DATE
176 |
177 | MODIFICATION HISTORY
178 | Date Author Description of Changes
179 | 22-Aug-2002 J Rautiainen Created
180 |
181 *=======================================================================*/
182 FUNCTION get_tax_code_info(p_tax_id IN NUMBER,
183 p_name IN VARCHAR2,
184 p_column IN VARCHAR2,
185 p_data_type IN VARCHAR2) RETURN VARCHAR2;
186
187 /*========================================================================
188 | PUBLIC FUNCTION get_line_status
189 |
190 | DESCRIPTION
191 | This function returns the expense report line status for auditor. Line
192 | status consists either of "OK" or of the list of policy violations if
193 | violations exist.
194 |
195 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
196 | Called from BC4J.
197 |
198 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
199 |
200 | RETURNS
201 | Expense line status as VARCHAR2.
202 |
203 | PARAMETERS
204 | p_report_header_id IN Expense report header identifier
205 | p_distribution_line_number IN Expense report line identifier
206 |
207 | MODIFICATION HISTORY
208 | Date Author Description of Changes
209 | 22-Aug-2002 J Rautiainen Created
210 |
211 *=======================================================================*/
212 FUNCTION get_line_status(p_report_header_id IN NUMBER,
213 p_distribution_line_number IN NUMBER) RETURN VARCHAR2;
214
215 /*========================================================================
216 | PUBLIC FUNCTION get_expense_type
217 |
218 | DESCRIPTION
219 | This function returns the expense line type.
220 |
221 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
222 | Called from BC4J.
223 |
224 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
225 |
226 | RETURNS
227 | Expense line type as VARCHAR2.
228 |
229 | PARAMETERS
230 | p_parameter_id IN Expense type identifier
231 |
232 | MODIFICATION HISTORY
233 | Date Author Description of Changes
234 | 22-Aug-2002 J Rautiainen Created
235 |
236 *=======================================================================*/
240 | PUBLIC FUNCTION get_allowable_amount
237 FUNCTION get_expense_type(p_parameter_id IN NUMBER) RETURN VARCHAR2;
238
239 /*========================================================================
241 |
242 | DESCRIPTION
243 | This function returns the allowable amount on an line with policy violation.
244 |
245 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
246 | Called from BC4J.
247 |
248 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
249 |
250 | RETURNS
251 | Expense line allowable amount as NUMBER.
252 |
253 | PARAMETERS
254 | p_report_header_id IN Expense report header identifier
255 | p_distribution_line_number IN Expense report line identifier
256 |
257 | MODIFICATION HISTORY
258 | Date Author Description of Changes
259 | 22-Aug-2002 J Rautiainen Created
260 |
261 *=======================================================================*/
262 FUNCTION get_allowable_amount(p_report_header_id IN NUMBER,
263 p_distribution_line_number IN NUMBER) RETURN NUMBER;
264
265 /*========================================================================
266 | PUBLIC FUNCTION get_allowable_cc_amount
267 |
268 | DESCRIPTION
269 | This function returns the allowable credit card amount on a line with credit card violation.
270 |
271 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
272 | Called from BC4J.
273 |
274 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
275 |
276 | RETURNS
277 | Expense line credit card allowable amount as NUMBER.
278 |
279 | PARAMETERS
280 | p_report_header_id IN Expense report header identifier
281 | p_distribution_line_number IN Expense report line identifier
282 |
283 | MODIFICATION HISTORY
284 | Date Author Description of Changes
285 | 28-Jul-2004 R Langi Copied
286 |
287 *=======================================================================*/
288 FUNCTION get_allowable_cc_amount(p_report_header_id IN NUMBER,
289 p_distribution_line_number IN NUMBER) RETURN NUMBER;
290
291 /*========================================================================
292 | PUBLIC FUNCTION get_allowable_daily_sum
293 |
294 | DESCRIPTION
295 | This function returns the allowable daily sum on an line with policy violation.
296 |
297 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
298 | Called from BC4J.
299 |
300 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
301 |
302 | RETURNS
303 | Expense line allowable daily sum as NUMBER.
304 |
305 | PARAMETERS
306 | p_report_header_id IN Expense report header identifier
307 | p_distribution_line_number IN Expense report line identifier
308 |
309 | MODIFICATION HISTORY
310 | Date Author Description of Changes
311 | 04-Apr-2003 J Rautiainen Created
312 |
313 *=======================================================================*/
314 FUNCTION get_allowable_daily_sum(p_report_header_id IN NUMBER,
315 p_distribution_line_number IN NUMBER) RETURN NUMBER;
316
320 | DESCRIPTION
317 /*========================================================================
318 | PUBLIC FUNCTION get_allowable_rate
319 |
321 | This function returns the allowable rate on an line with policy violation.
322 |
323 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
324 | Called from BC4J.
325 |
326 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
327 |
328 | RETURNS
329 | Expense line allowable amount as NUMBER.
330 |
331 | PARAMETERS
332 | p_report_header_id IN Expense report header identifier
333 | p_distribution_line_number IN Expense report line identifier
334 |
335 | MODIFICATION HISTORY
336 | Date Author Description of Changes
337 | 22-Aug-2002 J Rautiainen Created
338 |
339 *=======================================================================*/
340 FUNCTION get_allowable_rate(p_report_header_id IN NUMBER,
341 p_distribution_line_number IN NUMBER) RETURN NUMBER;
342
343 FUNCTION get_object_info(p_key IN VARCHAR2,
344 p_column IN VARCHAR2,
345 p_result_type IN VARCHAR2,
346 p_table IN VARCHAR2,
347 p_key_column IN VARCHAR2,
348 p_order_by_clause IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
349
350 /*========================================================================
351 | PUBLIC FUNCTION get_concat_desc_flex
352 |
353 | DESCRIPTION
354 | This function returns the descriptive flexfield definition related to a row.
355 |
356 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
357 | Called from BC4J.
358 |
359 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
360 |
361 | RETURNS
362 | CCID.
363 |
364 | PARAMETERS
365 | p_report_header_id IN Expense report header identifier
366 | p_distribution_line_number IN Expense report line identifier
367 |
368 | MODIFICATION HISTORY
369 | Date Author Description of Changes
370 | 22-Aug-2002 J Rautiainen Created
371 |
372 *=======================================================================*/
373 FUNCTION get_concat_desc_flex(p_report_header_id IN NUMBER,
374 p_distribution_line_number IN NUMBER) RETURN VARCHAR2;
375
376 /*========================================================================
377 | PUBLIC FUNCTION get_flex_structure_code
378 |
379 | DESCRIPTION
380 | This function returns the flex structure code for a given org.
381 |
382 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
383 | Called from BC4J.
384 |
385 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
386 |
387 | RETURNS
388 | Flex structure code.
389 |
390 | PARAMETERS
391 | p_org_id IN Organization identifier
392 |
393 | MODIFICATION HISTORY
394 | Date Author Description of Changes
395 | 26-Aug-2002 J Rautiainen Created
396 |
397 *=======================================================================*/
398 FUNCTION get_flex_structure_code(p_org_id IN NUMBER) RETURN VARCHAR2;
399
400 /*========================================================================
401 | PUBLIC PROCEDURE set_show_audit_header_flag
402 |
403 | DESCRIPTION
404 | This procedure auto sets the preference controlling whether the header
405 | information is shown or not on the audit page.
406 |
407 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
408 | Called from BC4J.
409 |
410 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
411 |
412 | RETURNS
413 |
414 | PARAMETERS
415 | p_show_header IN Whether the header should be shown
416 |
417 | MODIFICATION HISTORY
418 | Date Author Description of Changes
419 | 30-Aug-2002 J Rautiainen Created
423
420 |
421 *=======================================================================*/
422 PROCEDURE set_show_audit_header_flag(p_show_header IN VARCHAR2);
424 /*========================================================================
425 | PUBLIC FUNCTION get_show_audit_header_flag
426 |
427 | DESCRIPTION
428 | This function gets the preference controlling whether the header
429 | information is shown or not on the audit page.
430 |
431 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
432 | Called from BC4J.
433 |
434 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
435 |
436 | RETURNS
437 | Y / N depending whether the header should be shown
438 |
439 | PARAMETERS
440 |
441 | MODIFICATION HISTORY
442 | Date Author Description of Changes
443 | 30-Aug-2002 J Rautiainen Created
444 |
445 *=======================================================================*/
446 FUNCTION get_show_audit_header_flag RETURN VARCHAR2;
447
448 /*========================================================================
449 | PUBLIC FUNCTION get_rule_set_assignment_exists
450 |
451 | DESCRIPTION
452 | This function checks whether assignments exist for a given audit rule set.
453 |
454 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
455 | Called from BC4J.
456 |
457 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
458 |
459 | RETURNS
460 | Y / N depending whether assignment exists for the rule set
461 |
462 | PARAMETERS
463 | p_rule_set_id IN Rule Set Id
464 |
465 | MODIFICATION HISTORY
466 | Date Author Description of Changes
467 | 30-Aug-2002 J Rautiainen Created
468 |
469 *=======================================================================*/
470 FUNCTION get_rule_set_assignment_exists(p_rule_set_id IN NUMBER) RETURN VARCHAR2;
471
472 /*========================================================================
473 | PUBLIC FUNCTION get_workload_info
474 |
475 | DESCRIPTION
476 | This function returns the user workload info.
477 |
478 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
479 | Called from BC4J.
480 |
481 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
482 |
483 | RETURNS
484 | User queue info
485 |
486 | PARAMETERS
487 | p_user_id IN User Id
488 | p_column IN Column from which the data is retrieved
489 | p_data_type IN Data type of the column from which the data is retrieved.
490 | Supported values: NUMBER, VARCHAR2, DATE
491 |
492 | MODIFICATION HISTORY
493 | Date Author Description of Changes
494 | 11-Sep-2002 J Rautiainen Created
495 |
496 *=======================================================================*/
497 FUNCTION get_workload_info(p_user_id IN NUMBER,
498 p_column IN VARCHAR2,
499 p_data_type IN VARCHAR2) RETURN VARCHAR2;
500
501 /*========================================================================
502 | PUBLIC FUNCTION get_user_queue_info
503 |
504 | DESCRIPTION
505 | This function returns the user queue info.
506 |
507 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
508 | Called from BC4J.
509 |
510 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
511 |
512 | RETURNS
513 | User queue info
514 |
515 | PARAMETERS
516 | p_user_id IN User Id
517 | p_column IN Column from which the data is retrieved
518 | p_data_type IN Data type of the column from which the data is retrieved.
519 | Supported values: NUMBER, VARCHAR2, DATE
520 |
521 | MODIFICATION HISTORY
522 | Date Author Description of Changes
523 | 11-Sep-2002 J Rautiainen Created
524 |
525 *=======================================================================*/
526 FUNCTION get_user_queue_info(p_user_id IN NUMBER,
527 p_column IN VARCHAR2,
528 p_data_type IN VARCHAR2) RETURN VARCHAR2;
529
530 /*========================================================================
531 | PUBLIC FUNCTION get_audit_reason
532 |
533 | DESCRIPTION
534 | This function returns the reason(s) why expense report line status
535 | is audited .
536 |
537 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
538 | Called from BC4J.
539 |
540 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
541 |
542 | RETURNS
543 | Expense report audit reason as VARCHAR2.
544 |
545 | PARAMETERS
546 | p_report_header_id IN Expense report header identifier
547 |
548 | MODIFICATION HISTORY
549 | Date Author Description of Changes
550 | 22-Aug-2002 J Rautiainen Created
551 |
552 *=======================================================================*/
553 FUNCTION get_audit_reason(p_report_header_id IN NUMBER) RETURN VARCHAR2;
554
555 /*========================================================================
556 | PUBLIC FUNCTION get_person_org_id
557 |
558 | DESCRIPTION
559 | This function returns the organization id associated to a person.
560 |
561 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
562 | Called from BC4J.
563 |
564 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
565 |
566 | RETURNS
567 | Organization Id as NUMBER.
568 |
569 | PARAMETERS
573 | Date Author Description of Changes
570 | p_person_id IN Person identifier
571 |
572 | MODIFICATION HISTORY
574 | 22-Aug-2002 J Rautiainen Created
575 |
576 *=======================================================================*/
577 FUNCTION get_person_org_id(p_person_id IN NUMBER) RETURN NUMBER;
578
579 /*========================================================================
580 | PUBLIC PROCEDURE set_audit_list_member
581 |
582 | DESCRIPTION
583 | This procedure auto sets the given user to the audit list.
584 |
585 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
586 | Called from BC4J.
587 |
588 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
589 |
590 | RETURNS
591 |
592 | PARAMETERS
593 | p_report_header_id IN Expense report identier
594 | p_reason_code IN Reason person is being added to the list
595 |
596 | MODIFICATION HISTORY
597 | Date Author Description of Changes
598 | 18-Oct-2002 J Rautiainen Created
599 |
600 *=======================================================================*/
601 PROCEDURE set_audit_list_member(p_report_header_id IN NUMBER, p_reason_code IN VARCHAR2);
602
603 /*========================================================================
604 | PUBLIC FUNCTION get_audit_list_member
605 |
606 | DESCRIPTION
607 | This procedure returns whether user is on audit list.
608 |
609 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
610 | Called from BC4J.
611 |
612 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
613 |
614 | RETURNS
615 | Y / N depending whether user is on audit list
616 |
617 | PARAMETERS
618 |
619 | MODIFICATION HISTORY
620 | Date Author Description of Changes
621 | 18-Oct-2002 J Rautiainen Created
622 |
623 *=======================================================================*/
624 FUNCTION get_audit_list_member(p_employee_id IN NUMBER) RETURN VARCHAR2;
625
626
627 /*========================================================================
628 | PUBLIC FUNCTION get_auditor_name
629 |
630 | DESCRIPTION
631 | This function returns the auditor name for a auditor.
632 |
633 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
634 | Called from BC4J.
635 |
636 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
637 |
638 | RETURNS
639 | Auditor name for the given auditor as VARCHAR2.
640 |
641 | PARAMETERS
642 | p_auditor_id IN Auditor identifier
643 |
644 | MODIFICATION HISTORY
645 | Date Author Description of Changes
646 | 19-Oct-2002 J Rautiainen Created
647 |
648 *=======================================================================*/
649 FUNCTION get_auditor_name(p_auditor_id IN NUMBER) RETURN VARCHAR2;
650
651
652 /*========================================================================
653 | PUBLIC FUNCTION get_audit_rule_info
654 |
655 | DESCRIPTION
656 | This function returns the audit rule info.
657 |
658 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
659 | Called from BC4J.
660 |
661 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
662 |
663 | RETURNS
664 | Audit rule info
665 |
666 | PARAMETERS
667 | p_org_id IN Organization Id
668 | p_rule_type IN Rule Set type
669 | p_column IN Column from which the data is retrieved
670 | p_data_type IN Data type of the column from which the data is retrieved.
671 | Supported values: NUMBER, VARCHAR2, DATE
672 |
673 | MODIFICATION HISTORY
674 | Date Author Description of Changes
675 | 02-Oct-2002 J Rautiainen Created
676 |
677 *=======================================================================*/
678 FUNCTION get_audit_rule_info(p_org_id IN NUMBER,
679 p_rule_type IN VARCHAR2,
680 p_column IN VARCHAR2,
681 p_data_type IN VARCHAR2) RETURN VARCHAR2;
682
683 /*========================================================================
684 | PUBLIC FUNCTION get_security_profile_info
685 |
686 | DESCRIPTION
687 | This function returns the security profile info.
688 |
689 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
690 | Called from BC4J.
691 |
692 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
693 |
694 | RETURNS
695 | Security Profile info
696 |
697 | PARAMETERS
698 | p_security_profile_id IN Security Profile Id
699 | p_column IN Column from which the data is retrieved
700 | p_data_type IN Data type of the column from which the data is retrieved.
701 | Supported values: NUMBER, VARCHAR2, DATE
702 |
703 | MODIFICATION HISTORY
704 | Date Author Description of Changes
705 | 02-Oct-2002 J Rautiainen Created
706 |
707 *=======================================================================*/
708 FUNCTION get_security_profile_info(p_security_profile_id IN NUMBER,
709 p_column IN VARCHAR2,
710 p_data_type IN VARCHAR2) RETURN VARCHAR2;
711
712 /*========================================================================
713 | PUBLIC FUNCTION get_security_profile_org_list
714 |
715 | DESCRIPTION
719 | Called from BC4J.
716 | This function returns the security profile organization list.
717 |
718 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
720 |
721 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
722 |
723 | RETURNS
724 | Security Profile organization list
725 |
726 | PARAMETERS
727 | p_security_profile_id IN Security Profile Id
728 |
729 | MODIFICATION HISTORY
730 | Date Author Description of Changes
731 | 02-Oct-2002 J Rautiainen Created
732 |
733 *=======================================================================*/
734 FUNCTION get_security_profile_org_list(p_security_profile_id IN NUMBER) RETURN VARCHAR2;
735
736 /*========================================================================
737 | PUBLIC FUNCTION get_default_security_profile
738 |
739 | DESCRIPTION
740 | This function returns the default security profile for user.
741 |
742 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
743 | Called from BC4J.
744 |
745 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
746 |
747 | RETURNS
748 | Default Security Profile
749 |
750 | PARAMETERS
751 | p_user_id IN User Id
752 |
753 | MODIFICATION HISTORY
754 | Date Author Description of Changes
755 | 02-Oct-2002 J Rautiainen Created
756 |
757 *=======================================================================*/
758 FUNCTION get_default_security_profile(p_user_id IN NUMBER) RETURN NUMBER;
759
760
761 /*========================================================================
762 | PUBLIC FUNCTION get_advance_exists
763 |
764 | DESCRIPTION
765 | This function returns whether advance exists for a given employee.
766 |
767 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
768 | Called from BC4J.
769 |
770 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
771 |
772 | RETURNS
773 | Y / N whether advance exists
774 |
775 | PARAMETERS
776 | p_report_header_id IN Expense report header Id
777 |
778 | MODIFICATION HISTORY
779 | Date Author Description of Changes
780 | 15-Oct-2002 J Rautiainen Created
781 |
782 *=======================================================================*/
783 FUNCTION get_advance_exists(p_report_header_id IN NUMBER) RETURN VARCHAR2;
784
785 /*========================================================================
786 | PUBLIC PROCEDURE is_gl_date_valid
787 |
788 | DESCRIPTION
789 | This procedure returns whether give date is a valid GL date in AP periods.
790 | Note this is not generic validation, since we have specific requirement
791 | of only "Never Opened" and null to be flagged as invalid.
792 |
793 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
794 | Called from BC4J.
795 |
796 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
797 |
798 | RETURNS
799 | p_date_valid IN Y / N
800 | p_default_date IN if given date is invalid, try to find default GL date
801 |
802 | PARAMETERS
803 | p_gl_date IN GL Date
804 | p_set_of_books_id IN Set of books identifier
805 |
806 | MODIFICATION HISTORY
807 | Date Author Description of Changes
808 | 16-Oct-2002 J Rautiainen Created
809 |
810 *=======================================================================*/
811 PROCEDURE is_gl_date_valid(p_gl_date IN DATE,
812 p_set_of_books_id IN NUMBER,
813 p_date_valid OUT NOCOPY VARCHAR2,
814 p_default_date OUT NOCOPY DATE);
815
816 /*========================================================================
817 | PUBLIC FUNCTION get_expense_item_info
818 |
819 | DESCRIPTION
820 | This function returns the expense item info.
821 |
822 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
823 | Called from BC4J.
824 |
825 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
826 |
827 | RETURNS
828 | Expense item info
829 |
830 | PARAMETERS
831 | p_parameter_id IN Expense item Id
832 | p_column IN Column from which the data is retrieved
833 | p_data_type IN Data type of the column from which the data is retrieved.
834 | Supported values: NUMBER, VARCHAR2, DATE
835 |
836 | MODIFICATION HISTORY
837 | Date Author Description of Changes
838 | 16-Sep-2002 J Rautiainen Created
839 |
840 *=======================================================================*/
841 FUNCTION get_expense_item_info(p_parameter_id IN NUMBER,
842 p_column IN VARCHAR2,
843 p_data_type IN VARCHAR2) RETURN VARCHAR2;
844
845 /*========================================================================
846 | PUBLIC FUNCTION is_employee_active
847 |
848 | DESCRIPTION
849 | This function returns whether the employee is active for a given org.
850 |
851 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
852 | Called from BC4J.
853 |
854 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
855 |
856 | RETURNS
857 | Y / N depending whether employee is active
858 |
859 | PARAMETERS
860 | p_employee_id IN Employee identifier
861 | p_org_id IN Organization Id
862 |
863 | MODIFICATION HISTORY
867 *=======================================================================*/
864 | Date Author Description of Changes
865 | 20-Nov-2002 J Rautiainen Created
866 |
868 FUNCTION is_employee_active(p_employee_id IN NUMBER,
869 p_org_id IN NUMBER) RETURN VARCHAR2;
870
871
872 /*========================================================================
873 | PUBLIC FUNCTION is_personal_expense
874 |
875 | DESCRIPTION
876 | This function returns whether given expense is a personal expense or not.
877 |
878 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
879 | Called from BC4J.
880 |
881 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
882 |
883 | RETURNS
884 | Y / N Depending whether expense is personal or not
885 |
886 | PARAMETERS
887 | p_parameter_id IN Expense type to check for personal expense
888 |
889 | MODIFICATION HISTORY
890 | Date Author Description of Changes
891 | 04-Feb-2003 J Rautiainen Created
892 |
893 *=======================================================================*/
894 FUNCTION is_personal_expense(p_parameter_id IN NUMBER) RETURN VARCHAR2;
895
896 /**
897 * jrautiai ADJ Fix start
898 */
899 /*========================================================================
900 | PUBLIC FUNCTION is_rounding_line
901 |
902 | DESCRIPTION
903 | This function returns whether given line is a rounding line or not.
904 |
905 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
906 | Called from BC4J.
907 |
908 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
909 |
910 | RETURNS
911 | Y / N Depending whether line is a rounding line.
912 |
913 | PARAMETERS
914 | p_parameter_id IN Expense type to check for rounding
915 |
916 | MODIFICATION HISTORY
917 | Date Author Description of Changes
918 | 04-Feb-2003 J Rautiainen Created
919 |
920 *=======================================================================*/
921 FUNCTION is_rounding_line(p_parameter_id IN NUMBER) RETURN VARCHAR2;
922
923 /*========================================================================
924 | PUBLIC FUNCTION is_cc_expense_adjusted
925 |
926 | DESCRIPTION
927 | This function returns whether CC expense has been adjusted.
928 |
929 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
930 | Called from BC4J.
931 |
932 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
933 |
934 | RETURNS
935 | Y / N Depending whether CC expense has been adjusted
936 |
937 | PARAMETERS
938 | p_report_header_id IN Expense report to be checked
939 |
940 | MODIFICATION HISTORY
941 | Date Author Description of Changes
942 | 15-Jul-2003 J Rautiainen Created
943 |
944 *=======================================================================*/
945 FUNCTION is_cc_expense_adjusted(p_report_header_id IN NUMBER) RETURN VARCHAR2;
946
947 /*========================================================================
948 | PUBLIC FUNCTION is_itemized_expense_shortpaid
949 |
950 | DESCRIPTION
951 | This function returns whether itemized expense has been shortpaid.
952 |
953 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
954 | Called from BC4J.
955 |
956 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
957 |
958 | RETURNS
959 | Y / N Depending whether itemized expense has been shortpaid
960 |
961 | PARAMETERS
962 | p_report_header_id IN Expense report to be checked
963 |
964 | MODIFICATION HISTORY
965 | Date Author Description of Changes
966 | 15-Jul-2003 J Rautiainen Created
967 |
968 *=======================================================================*/
969 FUNCTION is_itemized_expense_shortpaid(p_report_header_id IN NUMBER) RETURN VARCHAR2;
970
971
972 /*========================================================================
973 | PUBLIC FUNCTION get_personal_expense_id
974 |
975 | DESCRIPTION
976 | This function returns personal expense parameter id.
977 |
978 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
979 | process_audit_actions
980 |
981 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
982 |
983 | RETURNS
984 | Expense type parameter if for a personal expense
985 |
986 | PARAMETERS
987 | None
988 | MODIFICATION HISTORY
989 | Date Author Description of Changes
990 | 21-Jul-2003 J Rautiainen Created
991 |
992 *=======================================================================*/
993 FUNCTION get_personal_expense_id
994 RETURN NUMBER;
995
996 /*========================================================================
997 | PUBLIC FUNCTION get_expense_clearing_ccid
998 |
999 | DESCRIPTION
1000 | This function returns the expense clearing account for a given transaction.
1001 |
1002 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1003 | process_audit_actions
1004 |
1005 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1006 |
1007 | RETURNS
1008 | Expense clearing account for a given transaction
1009 |
1010 | PARAMETERS
1011 | Transaction id to fetch the expense clearing account for.
1012 |
1016 |
1013 | MODIFICATION HISTORY
1014 | Date Author Description of Changes
1015 | 21-Jul-2003 J Rautiainen Created
1017 *=======================================================================*/
1018 FUNCTION get_expense_clearing_ccid(p_trx_id IN NUMBER) RETURN NUMBER;
1019
1020 /*========================================================================
1021 | PUBLIC FUNCTION get_payment_due_from
1022 |
1023 | DESCRIPTION
1024 | This function returns the payment due from for a given transaction.
1025 | If the payment due from column is not populated on the cc transaction,
1026 | then the value of the related profile option is returned.
1027 |
1028 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1029 | process_audit_actions
1030 |
1031 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1032 |
1033 | RETURNS
1034 | Payment due from for a given transaction
1035 |
1036 | PARAMETERS
1037 | Transaction id for which to fetch the payment due from.
1038 |
1039 | MODIFICATION HISTORY
1040 | Date Author Description of Changes
1041 | 21-Jul-2003 J Rautiainen Created
1042 |
1043 *=======================================================================*/
1044 FUNCTION get_payment_due_from(p_trx_id IN NUMBER) RETURN VARCHAR2;
1045
1046 /*========================================================================
1047 | PUBLIC FUNCTION get_seeded_expense_id
1048 |
1049 | DESCRIPTION
1050 | This function returns a seeded expense type id. It is used to get the ID
1051 | for personal and rounding expense types.
1052 |
1053 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1054 |
1055 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1056 |
1057 | RETURNS
1058 | Expense type parameter id for the seeded expense
1059 |
1060 | PARAMETERS
1061 | Expense type code for the seeded expense type.
1062 | MODIFICATION HISTORY
1063 | Date Author Description of Changes
1064 | 21-Jul-2003 J Rautiainen Created
1065 |
1066 *=======================================================================*/
1067 FUNCTION get_seeded_expense_id(p_expense_type_code IN VARCHAR2) RETURN NUMBER;
1068
1069 /*========================================================================
1070 | PUBLIC FUNCTION get_next_distribution_line_id
1071 |
1072 | DESCRIPTION
1073 | This function returns a the next distribution number for the report.
1074 |
1075 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1076 |
1077 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1078 |
1079 | RETURNS
1080 | The next distribution line number for the expense report.
1081 |
1082 | PARAMETERS
1083 | Expense report identifier.
1084 | MODIFICATION HISTORY
1085 | Date Author Description of Changes
1086 | 21-Jul-2003 J Rautiainen Created
1087 |
1088 *=======================================================================*/
1089 FUNCTION get_next_distribution_line_id(p_report_header_id IN NUMBER) RETURN NUMBER;
1090
1091 /*========================================================================
1092 | PUBLIC FUNCTION get_rounding_error_ccid
1093 |
1094 | DESCRIPTION
1095 | This function returns the rounding error account for a given org.
1096 |
1097 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1098 | process_audit_actions
1099 |
1100 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1101 |
1102 | RETURNS
1103 | Rounding error account for a given org
1104 |
1105 | PARAMETERS
1106 | Organization id to fetch the rounding error account for.
1107 |
1108 | MODIFICATION HISTORY
1109 | Date Author Description of Changes
1110 | 21-Jul-2003 J Rautiainen Created
1111 |
1112 *=======================================================================*/
1113 FUNCTION get_rounding_error_ccid(p_org_id IN NUMBER) RETURN NUMBER;
1114 /**
1115 * jrautiai ADJ Fix end
1116 */
1117
1118 /*========================================================================
1119 | PUBLIC FUNCTION get_user_name
1120 |
1121 | DESCRIPTION
1122 | This function returns the name for a given FND user.
1123 |
1124 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1125 |
1126 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1127 |
1128 | RETURNS
1129 | Name for a given FND user
1130 |
1131 | PARAMETERS
1132 | FND user ID.
1133 |
1134 | MODIFICATION HISTORY
1135 | Date Author Description of Changes
1136 | 18-Aug-2003 J Rautiainen Created
1137 |
1138 *=======================================================================*/
1139 FUNCTION get_user_name(p_user_id IN NUMBER) RETURN VARCHAR2;
1140
1141 /*========================================================================
1142 | PUBLIC FUNCTION get_lookup_description
1143 |
1144 | DESCRIPTION
1145 | This function returns the description of a lookup code.
1146 |
1147 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1148 |
1149 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1150 |
1151 | RETURNS
1152 | Description of a lookup code
1153 |
1154 | PARAMETERS
1155 | Lookup type and lookup code
1156 |
1157 | MODIFICATION HISTORY
1158 | Date Author Description of Changes
1159 | 24-Oct-2003 J Rautiainen Created
1160 |
1161 *=======================================================================*/
1165 | PUBLIC FUNCTION get_non_project_ccid
1162 FUNCTION get_lookup_description(p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2) RETURN VARCHAR2;
1163
1164 /*========================================================================
1166 |
1167 | DESCRIPTION
1168 | This function returns a CCID with segments overridden by the expense
1169 | type definitions.
1170 |
1171 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1172 |
1173 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1174 |
1175 | RETURNS
1176 | CCID with segments overridden by the expense type definitions
1177 |
1178 | PARAMETERS
1179 |
1180 | MODIFICATION HISTORY
1181 | Date Author Description of Changes
1182 | 07-Nov-2003 J Rautiainen Created
1183 |
1184 *=======================================================================*/
1185 FUNCTION get_non_project_ccid(p_report_header_id IN NUMBER,
1186 p_report_distribution_id IN NUMBER,
1187 p_parameter_id IN NUMBER,
1188 p_ccid IN NUMBER) RETURN NUMBER;
1189
1190 /*========================================================================
1191 | PUBLIC FUNCTION get_report_profile_value
1192 |
1193 | DESCRIPTION
1194 | This function returns profile option value for a submitted report.
1195 |
1196 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1197 |
1198 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1199 |
1200 | RETURNS
1201 | Profile option value.
1202 |
1203 | PARAMETERS
1204 |
1205 | MODIFICATION HISTORY
1206 | Date Author Description of Changes
1207 | 09-Dec-2003 J Rautiainen Created
1208 |
1209 *=======================================================================*/
1210 FUNCTION get_report_profile_value(p_report_header_id IN NUMBER,
1211 p_profile_name IN VARCHAR2) RETURN VARCHAR2;
1212
1213 /*========================================================================
1214 | PUBLIC FUNCTION get_average_pdm_rate
1215 |
1216 | DESCRIPTION
1217 | This function returns the average pdm rate on an line.
1218 |
1219 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1220 | Called from BC4J.
1221 |
1222 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1223 |
1224 | RETURNS
1225 | Average PDM rate as NUMBER.
1226 |
1227 | PARAMETERS
1228 | p_report_header_id IN Expense report header identifier
1229 | p_distribution_line_number IN Expense report line identifier
1230 |
1231 | MODIFICATION HISTORY
1232 | Date Author Description of Changes
1233 | 13-Jan-2004 J Rautiainen Created
1234 |
1235 *=======================================================================*/
1236 FUNCTION get_average_pdm_rate(p_report_header_id IN NUMBER,
1237 p_distribution_line_number IN NUMBER) RETURN NUMBER;
1238
1239 /*========================================================================
1240 | PUBLIC FUNCTION get_audit_indicator
1241 |
1242 | DESCRIPTION
1243 | This function returns audit indicator displayed on the confirmation page.
1244 |
1245 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1246 | Called from BC4J.
1247 |
1248 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1249 |
1250 | RETURNS
1251 | Audit indicator as VARCHAR2.
1252 |
1253 | PARAMETERS
1254 | p_report_header_id IN Expense report header identifier
1255 |
1256 | MODIFICATION HISTORY
1257 | Date Author Description of Changes
1258 | 26-Apr-2004 J Rautiainen Created
1259 |
1260 *=======================================================================*/
1261 FUNCTION get_audit_indicator(p_report_header_id IN NUMBER) RETURN VARCHAR2;
1262
1263 /*========================================================================
1264 | PUBLIC FUNCTION get_report_status_code
1265 |
1266 | DESCRIPTION
1267 | This function returns expense report status code.
1268 |
1269 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1270 | Called from BC4J.
1271 |
1272 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1273 |
1274 | RETURNS
1275 | Expense report status code as VARCHAR2.
1276 |
1277 | PARAMETERS
1278 | p_report_header_id IN Expense report header identifier
1279 |
1280 | MODIFICATION HISTORY
1281 | Date Author Description of Changes
1282 | 13-May-2004 J Rautiainen Created
1283 |
1284 *=======================================================================*/
1285 FUNCTION get_report_status_code(p_report_header_id IN NUMBER,
1286 p_invoice_id IN NUMBER DEFAULT NULL,
1287 p_cache IN VARCHAR2 DEFAULT 'N' ) RETURN VARCHAR2;
1288
1289 FUNCTION get_prepay_amount_remaining (P_invoice_id IN NUMBER) RETURN NUMBER;
1290 FUNCTION get_available_prepays(l_vendor_id IN NUMBER) RETURN NUMBER;
1291
1292 /*========================================================================
1293 | PUBLIC PROCEDURE get_rule
1294 |
1295 | DESCRIPTION
1296 | This procedures finds a audit rule matching the criteria provided.
1297 |
1298 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1299 | Called from WF.
1300 |
1301 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1302 |
1303 | RETURNS
1304 | None
1305 |
1306 | PARAMETERS
1307 | p_org_id IN organization identifier
1311 | MODIFICATION HISTORY
1308 | p_date IN date that the rule is effective
1309 | p_rule_type IN rule type; 'RULE', 'AUDIT_LIST, 'NOTIFY' or 'HOLD'
1310 |
1312 | Date Author Description of Changes
1313 | 11-Oct-2004 J Rautiainen Created
1314 |
1315 *=======================================================================*/
1316 PROCEDURE get_rule(p_org_id IN NUMBER, p_date IN DATE, p_rule_type IN VARCHAR2, p_rule OUT NOCOPY AP_AUD_RULE_SETS%ROWTYPE);
1317
1318
1319 /*========================================================================
1320 | PUBLIC FUNCTION has_default_cc_itemization
1321 |
1322 | DESCRIPTION
1323 | This function finds if the credit card transaction has level3 data
1324 | from the card provider.
1325 |
1326 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1327 | Called from AuditReportLinesVO.xml.
1328 |
1329 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1330 |
1331 | RETURNS
1332 | VARCHAR2 (Y/N)
1333 |
1334 | PARAMETERS
1335 | p_cc_trx_id IN credit card transaction id
1336 |
1337 | MODIFICATION HISTORY
1338 | Date Author Description of Changes
1339 | 02-Dec-2004 Krish Menon Created
1340 |
1341 *=======================================================================*/
1342 FUNCTION has_default_cc_itemization(p_cc_trx_id IN NUMBER) RETURN VARCHAR2;
1343
1344
1345 /*========================================================================
1346 |
1347 | DESCRIPTION
1348 | This function returns 'Y' if there is capture rule and 'N' otherwise.
1349 |
1350 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1351 | Called from BC4J.
1352 |
1353 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1354 |
1355 | RETURNS
1356 | 'Y' or 'N' as VARCHAR2.
1357 |
1358 | PARAMETERS
1359 | p_reportLineId IN report line identifier
1360 |
1361 | MODIFICATION HISTORY
1362 | Date Author Description of Changes
1363 | 31-01-2005 Quan Le Created
1364 |
1365 *=======================================================================*/
1366 FUNCTION isAttendeeAvailable(p_reportLineId IN NUMBER) RETURN VARCHAR2;
1367
1368 /*========================================================================
1369 |
1370 | DESCRIPTION
1371 | This function returns attendee type from lookup code
1372 |
1373 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1374 | Called from BC4J.
1375 |
1376 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1377 |
1378 | RETURNS
1379 | Attendee type as VARCHAR2.
1380 |
1381 | PARAMETERS
1382 | p_attendeeCode IN attendee type code
1383 |
1384 | MODIFICATION HISTORY
1385 | Date Author Description of Changes
1386 | 31-01-2005 Quan Le Created
1387 |
1388 *=======================================================================*/
1389 FUNCTION getAttendeeType(p_attendeeCode IN VARCHAR2) RETURN VARCHAR2;
1390
1391 /*========================================================================
1392 | PUBLIC PROCEDURE clear_audit_reason_codes
1393 |
1394 | DESCRIPTION
1395 | This procedures clears the data from AP_AUD_AUDIT_REASONS table
1396 | for specified expense report.
1397 |
1398 | RETURNS
1399 |
1400 | PARAMETERS
1401 | p_report_header_id : report header id of the expense report
1402 |
1403 | MODIFICATION HISTORY
1404 |
1405 *=======================================================================*/
1406 PROCEDURE clear_audit_reason_codes(p_report_header_id IN NUMBER);
1407
1408
1409 /*========================================================================
1410 | PUBLIC PROCEDURE get_dist_project_ccid
1411 |
1412 | DESCRIPTION
1413 | This function returns a CCID generated by projects accounting from distribution.
1414 |
1415 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1416 |
1417 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1418 |
1419 | RETURNS
1420 | CCID generated by projects accounting
1421 |
1422 | PARAMETERS
1423 |
1424 | MODIFICATION HISTORY
1425 | Date Author Description of Changes
1426 | 07-Nov-2003 J Rautiainen Created
1427 |
1428 *=======================================================================*/
1429 PROCEDURE get_dist_project_ccid(p_parameter_id IN NUMBER,
1430 p_report_distribution_id IN NUMBER,
1431 p_new_ccid OUT NOCOPY NUMBER,
1432 p_return_status OUT NOCOPY VARCHAR2);
1433
1434
1435 /*========================================================================
1436 | PUBLIC PROCEDURE GetDefaultAcctgSegValues
1437 |
1438 | DESCRIPTION
1439 | This procedure returns the defaulted CCID and segments based on expense type (parameter_id).
1440 |
1441 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1442 |
1443 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1444 |
1445 | RETURNS
1446 | CCID generated by projects accounting
1447 |
1448 | PARAMETERS
1449 |
1450 | MODIFICATION HISTORY
1451 | Date Author Description of Changes
1452 | 14-Aug-2006 Quan Le Created
1453 |
1454 *=======================================================================*/
1455 PROCEDURE GetDefaultAcctgSegValues(
1456 P_REPORT_HEADER_ID IN NUMBER,
1457 P_REPORT_LINE_ID IN NUMBER,
1458 P_EMPLOYEE_ID IN NUMBER,
1459 P_HEADER_COST_CENTER IN AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE,
1460 P_PARAMETER_ID IN NUMBER,
1461 P_SEGMENTS IN AP_OIE_KFF_SEGMENTS_T,
1462 X_SEGMENTS OUT NOCOPY AP_OIE_KFF_SEGMENTS_T,
1463 x_combination_id OUT NOCOPY HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE,
1464 X_MSG_COUNT OUT NOCOPY NUMBER,
1465 X_MSG_DATA OUT NOCOPY VARCHAR2,
1466 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
1467
1468 END AP_WEB_AUDIT_UTILS;