APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 13: PROCEDURE open_auditors_cur_w(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,

9:
10: ------------------------------------------------------------------------
11: -- Local Procedure Signature
12: ------------------------------------------------------------------------
13: PROCEDURE open_auditors_cur_w(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
14: p_auditor_info_cur OUT NOCOPY GenRefCursor);
15:
16: PROCEDURE open_load_cur(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
17: p_open_load_cur OUT NOCOPY GenRefCursor);

Line 23: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

19: PROCEDURE validate_auditors;
20:
21: PROCEDURE open_orphaned_reports_cursor(p_expense_report_cur OUT NOCOPY GenRefCursor);
22:
23: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
24: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
25:
26: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
27: RETURN BOOLEAN;

Line 26: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

22:
23: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
24: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
25:
26: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
27: RETURN BOOLEAN;
28:
29: FUNCTION auditor_has_access(
30: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

Line 31: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

27: RETURN BOOLEAN;
28:
29: FUNCTION auditor_has_access(
30: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
31: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
32: RETURN BOOLEAN;
33:
34: PROCEDURE transfer_report(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
35: p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

Line 36: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE);

32: RETURN BOOLEAN;
33:
34: PROCEDURE transfer_report(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
35: p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
36: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE);
37:
38: ------------------------------------------------------------------------
39: -- Procedure Result Codes
40: ------------------------------------------------------------------------

Line 62: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

58: |
59: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
60: |
61: | PARAMETERS
62: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
63: |
64: | MODIFICATION HISTORY
65: | Date Author Description of Changes
66: | 04-Sep-2002 Mohammad Shoaib Jamall Created

Line 70: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE) RETURN NUMBER

66: | 04-Sep-2002 Mohammad Shoaib Jamall Created
67: |
68: *=======================================================================*/
69: FUNCTION report_weight(p_report_header_id IN
70: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE) RETURN NUMBER
71: IS
72: l_report_weight NUMBER := 0;
73: BEGIN
74: SELECT count(1) INTO l_report_weight FROM ap_expense_report_lines_all

Line 102: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

98: |
99: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
100: |
101: | PARAMETERS
102: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
103: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
104: |
105: | MODIFICATION HISTORY
106: | Date Author Description of Changes

Line 111: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,

107: | 05-Sep-2002 Mohammad Shoaib Jamall Created
108: |
109: *=======================================================================*/
110: PROCEDURE assign_report_to_auditor(
111: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
112: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
113: p_retcode OUT NOCOPY VARCHAR2)
114: IS
115: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

Line 129: ap_expense_report_headers_all exp

125: -- is p_auditor_id the creator or employee for p_report_header_id; if yes then we should
126: -- return with INVALID_ASSIGNMENT; else proceed normally.
127: SELECT count(1) INTO l_scratch
128: FROM fnd_user u,
129: ap_expense_report_headers_all exp
130: WHERE u.user_id <> -1
131: AND u.user_id = p_auditor_id
132: -- making sure auditor does not audit expense report owned by her OR filed by her
133: AND exp.report_header_id = p_report_header_id

Line 185: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

181: |
182: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
183: |
184: | PARAMETERS
185: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
186: |
187: | MODIFICATION HISTORY
188: | Date Author Description of Changes
189: | 22-Feb-2008 SaiKumar Talasila Created

Line 193: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

189: | 22-Feb-2008 SaiKumar Talasila Created
190: |
191: *=======================================================================*/
192: PROCEDURE assign_to_last_auditor(p_report_header_id IN
193: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
194: IS
195: l_assignee NUMBER;
196: l_retcode VARCHAR2(200);
197: invalid_assig_to_audit_q EXCEPTION;

Line 204: FROM AP_EXPENSE_REPORT_HEADERS_ALL h

200:
201: l_assignee := NULL;
202: IF report_last_audited(p_report_id => p_report_header_id) THEN
203: SELECT h.last_audited_by INTO l_assignee
204: FROM AP_EXPENSE_REPORT_HEADERS_ALL h
205: WHERE h.report_header_id = p_report_header_id;
206:
207: IF( nvl(l_assignee,-1) <> -1 AND
208: auditor_has_access(p_auditor_id => l_assignee,

Line 233: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

229: |
230: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
231: |
232: | PARAMETERS
233: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
234: |
235: | MODIFICATION HISTORY
236: | Date Author Description of Changes
237: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 241: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

237: | 05-Sep-2002 Mohammad Shoaib Jamall Created
238: |
239: *=======================================================================*/
240: PROCEDURE enqueue_for_audit(p_report_header_id IN
241: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
242: IS
243: l_assignee NUMBER;
244: l_retcode VARCHAR2(200);
245: invalid_assig_to_audit_q EXCEPTION;

Line 356: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

352: |
353: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
354: |
355: | PARAMETERS
356: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
357: | p_cust_acct_cur IN GenRefCursor
358: |
359: | MODIFICATION HISTORY
360: | Date Author Description of Changes

Line 364: PROCEDURE open_auditors_cur_w(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,

360: | Date Author Description of Changes
361: | 05-Sep-2002 Mohammad Shoaib Jamall Created
362: |
363: *=======================================================================*/
364: PROCEDURE open_auditors_cur_w(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
365: p_auditor_info_cur OUT NOCOPY GenRefCursor)
366: IS
367: l_org_id AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE;
368: BEGIN

Line 367: l_org_id AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE;

363: *=======================================================================*/
364: PROCEDURE open_auditors_cur_w(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
365: p_auditor_info_cur OUT NOCOPY GenRefCursor)
366: IS
367: l_org_id AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE;
368: BEGIN
369: SELECT ORG_ID INTO l_org_id FROM ap_expense_report_headers_all
370: WHERE report_header_id = p_report_header_id;
371: open_auditors_info_cursor(p_report_header_id => p_report_header_id, p_org_id => l_org_id, p_auditor_info_cur => p_auditor_info_cur);

Line 369: SELECT ORG_ID INTO l_org_id FROM ap_expense_report_headers_all

365: p_auditor_info_cur OUT NOCOPY GenRefCursor)
366: IS
367: l_org_id AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE;
368: BEGIN
369: SELECT ORG_ID INTO l_org_id FROM ap_expense_report_headers_all
370: WHERE report_header_id = p_report_header_id;
371: open_auditors_info_cursor(p_report_header_id => p_report_header_id, p_org_id => l_org_id, p_auditor_info_cur => p_auditor_info_cur);
372: END open_auditors_cur_w;
373:

Line 387: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

383: |
384: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
385: |
386: | PARAMETERS
387: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
388: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
389: | p_cust_acct_cur IN GenRefCursor
390: |
391: | MODIFICATION HISTORY

Line 388: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

384: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
385: |
386: | PARAMETERS
387: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
388: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
389: | p_cust_acct_cur IN GenRefCursor
390: |
391: | MODIFICATION HISTORY
392: | Date Author Description of Changes

Line 396: PROCEDURE open_auditors_info_cursor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,

392: | Date Author Description of Changes
393: | 05-Sep-2002 Mohammad Shoaib Jamall Created
394: |
395: *=======================================================================*/
396: PROCEDURE open_auditors_info_cursor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
397: p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE,
398: p_auditor_info_cur OUT NOCOPY GenRefCursor)
399: IS
400:

Line 397: p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE,

393: | 05-Sep-2002 Mohammad Shoaib Jamall Created
394: |
395: *=======================================================================*/
396: PROCEDURE open_auditors_info_cursor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
397: p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE,
398: p_auditor_info_cur OUT NOCOPY GenRefCursor)
399: IS
400:
401: BEGIN

Line 409: ap_expense_report_headers_all exp

405: FROM ap_aud_auditors a,
406: per_organization_list per,
407: hr_organization_information oi,
408: fnd_user u,
409: ap_expense_report_headers_all exp
410: WHERE a.security_profile_id = per.security_profile_id
411: AND a.auditor_id <> -1
412: AND per.organization_id = oi.organization_id
413: AND oi.org_information_context = 'CLASS'

Line 439: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

435: |
436: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
437: |
438: | PARAMETERS
439: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
440: | p_cust_acct_cur IN GenRefCursor
441: |
442: | MODIFICATION HISTORY
443: | Date Author Description of Changes

Line 457: ap_expense_report_headers_all e,

453: FROM ap_aud_queues WHERE
454: expense_report_id NOT IN
455: ( SELECT q.expense_report_id
456: FROM ap_aud_queues q,
457: ap_expense_report_headers_all e,
458: ap_aud_auditors a,
459: per_organization_list per,
460: hr_organization_information oi
461: WHERE q.auditor_id = a.auditor_id

Line 482: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

478: |
479: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
480: |
481: | PARAMETERS
482: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
483: |
484: | MODIFICATION HISTORY
485: | Date Author Description of Changes
486: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 489: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

485: | Date Author Description of Changes
486: | 05-Sep-2002 Mohammad Shoaib Jamall Created
487: |
488: *=======================================================================*/
489: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
490: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
491: IS
492: -- preseeded auditor with no association with FND_USER
493: l_assignee NUMBER := -1;

Line 515: FROM AP_EXPENSE_REPORT_HEADERS_ALL h

511: -- auditor of parent isn't 0 workload and auditor still has access to the org for this auditor,
512: -- then assign to that auditor; else assign to fallback auditor
513: IF report_last_audited(p_report_id => p_report_header_id) THEN
514: SELECT h.last_audited_by INTO l_parent_auditor_id
515: FROM AP_EXPENSE_REPORT_HEADERS_ALL h
516: WHERE h.report_header_id = p_report_header_id;
517: IF l_parent_auditor_id IS NOT NULL THEN
518: open_load_cur(p_auditor_id => l_parent_auditor_id,
519: p_open_load_cur => l_open_load_cur);

Line 589: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

585: |
586: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
587: |
588: | PARAMETERS
589: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
590: |
591: | MODIFICATION HISTORY
592: | Date Author Description of Changes
593: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 596: FUNCTION report_shortpaid(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

592: | Date Author Description of Changes
593: | 05-Sep-2002 Mohammad Shoaib Jamall Created
594: |
595: *=======================================================================*/
596: FUNCTION report_shortpaid(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
597: RETURN BOOLEAN IS
598: l_shortpay_id AP_EXPENSE_REPORT_HEADERS_ALL.SHORTPAY_PARENT_ID%TYPE := NULL;
599: BEGIN
600: SELECT shortpay_parent_id

Line 598: l_shortpay_id AP_EXPENSE_REPORT_HEADERS_ALL.SHORTPAY_PARENT_ID%TYPE := NULL;

594: |
595: *=======================================================================*/
596: FUNCTION report_shortpaid(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
597: RETURN BOOLEAN IS
598: l_shortpay_id AP_EXPENSE_REPORT_HEADERS_ALL.SHORTPAY_PARENT_ID%TYPE := NULL;
599: BEGIN
600: SELECT shortpay_parent_id
601: INTO l_shortpay_id
602: FROM ap_expense_report_headers_all

Line 602: FROM ap_expense_report_headers_all

598: l_shortpay_id AP_EXPENSE_REPORT_HEADERS_ALL.SHORTPAY_PARENT_ID%TYPE := NULL;
599: BEGIN
600: SELECT shortpay_parent_id
601: INTO l_shortpay_id
602: FROM ap_expense_report_headers_all
603: WHERE report_header_id = p_report_id;
604: IF (l_shortpay_id IS NULL) THEN
605: return FALSE;
606: ELSE

Line 622: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

618: |
619: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
620: |
621: | PARAMETERS
622: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
623: |
624: | MODIFICATION HISTORY
625: | Date Author Description of Changes
626: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 629: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

625: | Date Author Description of Changes
626: | 05-Sep-2002 Mohammad Shoaib Jamall Created
627: |
628: *=======================================================================*/
629: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
630: RETURN BOOLEAN IS
631: l_last_audited_by AP_EXPENSE_REPORT_HEADERS_ALL.LAST_AUDITED_BY%TYPE := NULL;
632: BEGIN
633: SELECT last_audited_by

Line 631: l_last_audited_by AP_EXPENSE_REPORT_HEADERS_ALL.LAST_AUDITED_BY%TYPE := NULL;

627: |
628: *=======================================================================*/
629: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
630: RETURN BOOLEAN IS
631: l_last_audited_by AP_EXPENSE_REPORT_HEADERS_ALL.LAST_AUDITED_BY%TYPE := NULL;
632: BEGIN
633: SELECT last_audited_by
634: INTO l_last_audited_by
635: FROM ap_expense_report_headers_all

Line 635: FROM ap_expense_report_headers_all

631: l_last_audited_by AP_EXPENSE_REPORT_HEADERS_ALL.LAST_AUDITED_BY%TYPE := NULL;
632: BEGIN
633: SELECT last_audited_by
634: INTO l_last_audited_by
635: FROM ap_expense_report_headers_all
636: WHERE report_header_id = p_report_id;
637: IF (l_last_audited_by IS NULL) THEN
638: return FALSE;
639: ELSE

Line 656: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

652: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
653: |
654: | PARAMETERS
655: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
656: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
657: |
658: | MODIFICATION HISTORY
659: | Date Author Description of Changes
660: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 665: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

661: |
662: *=======================================================================*/
663: FUNCTION auditor_has_access(
664: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
665: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
666: RETURN BOOLEAN
667: IS
668: l_ret_val BOOLEAN := FALSE;
669: l_auditor_info_cur GenRefCursor;

Line 703: | p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

699: |
700: | PARAMETERS
701: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
702: | p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
703: | p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
704: |
705: | MODIFICATION HISTORY
706: | Date Author Description of Changes
707: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 712: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

708: |
709: *=======================================================================*/
710: PROCEDURE transfer_report(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
711: p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
712: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
713: IS
714: PRAGMA AUTONOMOUS_TRANSACTION;
715:
716: BEGIN

Line 802: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

798: | 16-Oct-2002 Mohammad Shoaib Jamall Created
799: |
800: *=======================================================================*/
801: PROCEDURE remove_from_queue(
802: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
803: IS
804: BEGIN
805: DELETE FROM ap_aud_queues WHERE expense_report_id = p_report_header_id;
806: END remove_from_queue;

Line 831: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,

827: | 16-Oct-2002 Mohammad Shoaib Jamall Created
828: |
829: *=======================================================================*/
830: PROCEDURE auditor_for_report(
831: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
832: p_auditor_id OUT NOCOPY AP_AUD_AUDITORS.AUDITOR_ID%TYPE)
833: IS
834: BEGIN
835: p_auditor_id := null;