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 359: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

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

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

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

Line 370: l_org_id AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE;

366: *=======================================================================*/
367: PROCEDURE open_auditors_cur_w(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
368: p_auditor_info_cur OUT NOCOPY GenRefCursor)
369: IS
370: l_org_id AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE;
371: BEGIN
372: SELECT ORG_ID INTO l_org_id FROM ap_expense_report_headers_all
373: WHERE report_header_id = p_report_header_id;
374: 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 372: SELECT ORG_ID INTO l_org_id FROM ap_expense_report_headers_all

368: p_auditor_info_cur OUT NOCOPY GenRefCursor)
369: IS
370: l_org_id AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE;
371: BEGIN
372: SELECT ORG_ID INTO l_org_id FROM ap_expense_report_headers_all
373: WHERE report_header_id = p_report_header_id;
374: 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);
375: END open_auditors_cur_w;
376:

Line 390: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

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

Line 391: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

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

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

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

Line 400: p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE,

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

Line 412: ap_expense_report_headers_all exp

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

Line 430: ap_expense_report_headers_all exp

426: SELECT a.auditor_id
427: FROM ap_aud_auditors a,
428: per_security_profiles sec,
429: fnd_user u,
430: ap_expense_report_headers_all exp
431: WHERE a.security_profile_id = sec.security_profile_id
432: AND sec.view_all_organizations_flag = 'Y'
433: AND a.auditor_id <> -1
434: -- making sure auditor does not audit expense report owned by her

Line 457: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE

453: |
454: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
455: |
456: | PARAMETERS
457: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
458: | p_cust_acct_cur IN GenRefCursor
459: |
460: | MODIFICATION HISTORY
461: | Date Author Description of Changes

Line 475: ap_expense_report_headers_all e,

471: FROM ap_aud_queues WHERE
472: expense_report_id NOT IN
473: ( SELECT q.expense_report_id
474: FROM ap_aud_queues q,
475: ap_expense_report_headers_all e,
476: ap_aud_auditors a,
477: per_organization_list per,
478: hr_organization_information oi
479: WHERE q.auditor_id = a.auditor_id

Line 500: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

496: |
497: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
498: |
499: | PARAMETERS
500: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
501: |
502: | MODIFICATION HISTORY
503: | Date Author Description of Changes
504: | 05-Sep-2002 Mohammad Shoaib Jamall Created

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

503: | Date Author Description of Changes
504: | 05-Sep-2002 Mohammad Shoaib Jamall Created
505: |
506: *=======================================================================*/
507: FUNCTION find_enqueue_auditor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
508: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
509: IS
510: -- preseeded auditor with no association with FND_USER
511: l_assignee NUMBER := -1;

Line 533: FROM AP_EXPENSE_REPORT_HEADERS_ALL h

529: -- auditor of parent isn't 0 workload and auditor still has access to the org for this auditor,
530: -- then assign to that auditor; else assign to fallback auditor
531: IF report_last_audited(p_report_id => p_report_header_id) THEN
532: SELECT h.last_audited_by INTO l_parent_auditor_id
533: FROM AP_EXPENSE_REPORT_HEADERS_ALL h
534: WHERE h.report_header_id = p_report_header_id;
535: IF l_parent_auditor_id IS NOT NULL THEN
536: open_load_cur(p_auditor_id => l_parent_auditor_id,
537: p_open_load_cur => l_open_load_cur);

Line 606: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

602: |
603: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
604: |
605: | PARAMETERS
606: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
607: |
608: | MODIFICATION HISTORY
609: | Date Author Description of Changes
610: | 05-Sep-2002 Mohammad Shoaib Jamall Created

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

609: | Date Author Description of Changes
610: | 05-Sep-2002 Mohammad Shoaib Jamall Created
611: |
612: *=======================================================================*/
613: FUNCTION report_shortpaid(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
614: RETURN BOOLEAN IS
615: l_shortpay_id AP_EXPENSE_REPORT_HEADERS_ALL.SHORTPAY_PARENT_ID%TYPE := NULL;
616: BEGIN
617: SELECT shortpay_parent_id

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

611: |
612: *=======================================================================*/
613: FUNCTION report_shortpaid(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
614: RETURN BOOLEAN IS
615: l_shortpay_id AP_EXPENSE_REPORT_HEADERS_ALL.SHORTPAY_PARENT_ID%TYPE := NULL;
616: BEGIN
617: SELECT shortpay_parent_id
618: INTO l_shortpay_id
619: FROM ap_expense_report_headers_all

Line 619: FROM ap_expense_report_headers_all

615: l_shortpay_id AP_EXPENSE_REPORT_HEADERS_ALL.SHORTPAY_PARENT_ID%TYPE := NULL;
616: BEGIN
617: SELECT shortpay_parent_id
618: INTO l_shortpay_id
619: FROM ap_expense_report_headers_all
620: WHERE report_header_id = p_report_id;
621: IF (l_shortpay_id IS NULL) THEN
622: return FALSE;
623: ELSE

Line 639: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

635: |
636: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
637: |
638: | PARAMETERS
639: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
640: |
641: | MODIFICATION HISTORY
642: | Date Author Description of Changes
643: | 05-Sep-2002 Mohammad Shoaib Jamall Created

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

642: | Date Author Description of Changes
643: | 05-Sep-2002 Mohammad Shoaib Jamall Created
644: |
645: *=======================================================================*/
646: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
647: RETURN BOOLEAN IS
648: l_last_audited_by AP_EXPENSE_REPORT_HEADERS_ALL.LAST_AUDITED_BY%TYPE := NULL;
649: BEGIN
650: SELECT last_audited_by

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

644: |
645: *=======================================================================*/
646: FUNCTION report_last_audited(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
647: RETURN BOOLEAN IS
648: l_last_audited_by AP_EXPENSE_REPORT_HEADERS_ALL.LAST_AUDITED_BY%TYPE := NULL;
649: BEGIN
650: SELECT last_audited_by
651: INTO l_last_audited_by
652: FROM ap_expense_report_headers_all

Line 652: FROM ap_expense_report_headers_all

648: l_last_audited_by AP_EXPENSE_REPORT_HEADERS_ALL.LAST_AUDITED_BY%TYPE := NULL;
649: BEGIN
650: SELECT last_audited_by
651: INTO l_last_audited_by
652: FROM ap_expense_report_headers_all
653: WHERE report_header_id = p_report_id;
654: IF (l_last_audited_by IS NULL) THEN
655: return FALSE;
656: ELSE

Line 673: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

669: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
670: |
671: | PARAMETERS
672: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
673: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
674: |
675: | MODIFICATION HISTORY
676: | Date Author Description of Changes
677: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 682: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

678: |
679: *=======================================================================*/
680: FUNCTION auditor_has_access(
681: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
682: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
683: RETURN BOOLEAN
684: IS
685: l_ret_val BOOLEAN := FALSE;
686: l_auditor_info_cur GenRefCursor;

Line 720: | p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE

716: |
717: | PARAMETERS
718: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
719: | p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
720: | p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
721: |
722: | MODIFICATION HISTORY
723: | Date Author Description of Changes
724: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 729: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

725: |
726: *=======================================================================*/
727: PROCEDURE transfer_report(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
728: p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
729: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
730: IS
731: PRAGMA AUTONOMOUS_TRANSACTION;
732:
733: BEGIN

Line 819: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)

815: | 16-Oct-2002 Mohammad Shoaib Jamall Created
816: |
817: *=======================================================================*/
818: PROCEDURE remove_from_queue(
819: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
820: IS
821: BEGIN
822: DELETE FROM ap_aud_queues WHERE expense_report_id = p_report_header_id;
823: END remove_from_queue;

Line 848: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,

844: | 16-Oct-2002 Mohammad Shoaib Jamall Created
845: |
846: *=======================================================================*/
847: PROCEDURE auditor_for_report(
848: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
849: p_auditor_id OUT NOCOPY AP_AUD_AUDITORS.AUDITOR_ID%TYPE)
850: IS
851: BEGIN
852: p_auditor_id := null;