DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_QUEUE_UTILS dependencies on AP_AUD_AUDITORS

Line 16: PROCEDURE open_load_cur(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

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);
18:
19: PROCEDURE validate_auditors;
20:

Line 24: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

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;
28:

Line 30: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

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,
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,

Line 34: PROCEDURE transfer_report(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

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,
36: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE);
37:
38: ------------------------------------------------------------------------

Line 35: p_next_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,
36: p_expense_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE);
37:
38: ------------------------------------------------------------------------
39: -- Procedure Result Codes

Line 103: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE

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
107: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 112: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

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;
116: l_aud_queue_cur GenRefCursor;

Line 115: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

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;
116: l_aud_queue_cur GenRefCursor;
117: l_scratch NUMBER := 0;
118: BEGIN
119: AP_WEB_UTILITIES_PKG.LogProcedure(G_PKG_NAME, 'start assign_report_to_auditor');

Line 268: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE

264: |
265: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
266: |
267: | PARAMETERS
268: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
269: |
270: | MODIFICATION HISTORY
271: | Date Author Description of Changes
272: | 05-Sep-2002 Mohammad Shoaib Jamall Created

Line 276: AP_AUD_AUDITORS.AUDITOR_ID%TYPE)

272: | 05-Sep-2002 Mohammad Shoaib Jamall Created
273: |
274: *=======================================================================*/
275: PROCEDURE rebalance_queue(p_auditor_id IN
276: AP_AUD_AUDITORS.AUDITOR_ID%TYPE)
277: IS
278: l_next_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
279: l_expense_report_id NUMBER;
280: CURSOR c1 IS SELECT expense_report_id

Line 278: l_next_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

274: *=======================================================================*/
275: PROCEDURE rebalance_queue(p_auditor_id IN
276: AP_AUD_AUDITORS.AUDITOR_ID%TYPE)
277: IS
278: l_next_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
279: l_expense_report_id NUMBER;
280: CURSOR c1 IS SELECT expense_report_id
281: FROM ap_aud_queues
282: WHERE auditor_id = p_auditor_id order by last_update_date desc;

Line 314: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE

310: |
311: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
312: |
313: | PARAMETERS
314: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
315: | p_open_load_cur IN GenRefCursor
316: |
317: | MODIFICATION HISTORY
318: | Date Author Description of Changes

Line 322: PROCEDURE open_load_cur(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

318: | Date Author Description of Changes
319: | 05-Sep-2002 Mohammad Shoaib Jamall Created
320: |
321: *=======================================================================*/
322: PROCEDURE open_load_cur(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
323: p_open_load_cur OUT NOCOPY GenRefCursor)
324: IS
325:
326: BEGIN

Line 332: ap_aud_auditors a,

328: OPEN p_open_load_cur FOR
329: SELECT s.current_total_workload,
330: w.workload_percent
331: FROM
332: ap_aud_auditors a,
333: ap_aud_queue_summaries_v s,
334: ap_aud_workloads w
335: WHERE a.auditor_id = p_auditor_id
336: AND a.auditor_id = s.auditor_id(+)

Line 405: FROM ap_aud_auditors a,

401: BEGIN
402: AP_WEB_UTILITIES_PKG.LogProcedure(G_PKG_NAME, 'start open_auditors_info_cursor:' || p_report_header_id || ' p_org_id:' || p_org_id);
403: OPEN p_auditor_info_cur FOR
404: SELECT a.auditor_id
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

Line 458: ap_aud_auditors a,

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
462: AND q.expense_report_id = e.report_header_id

Line 490: RETURN AP_AUD_AUDITORS.AUDITOR_ID%TYPE

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;
494: -- an extremely large number

Line 499: l_current_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

495: l_assignee_adjusted_workload NUMBER := 10E124;
496: l_auditor_info_cur GenRefCursor;
497: l_open_load_cur GenRefCursor;
498:
499: l_current_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
500: l_current_workload NUMBER;
501: l_current_adjusted_workload NUMBER;
502: l_current_workload_percent AP_AUD_WORKLOADS.WORKLOAD_PERCENT%TYPE;
503: -- temporary scratchpad variable

Line 655: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE

651: |
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

Line 664: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

660: | 05-Sep-2002 Mohammad Shoaib Jamall Created
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;

Line 670: l_current_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

666: RETURN BOOLEAN
667: IS
668: l_ret_val BOOLEAN := FALSE;
669: l_auditor_info_cur GenRefCursor;
670: l_current_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
671: BEGIN
672: AP_WEB_UTILITIES_PKG.LogProcedure(G_PKG_NAME, 'start auditor_has_access');
673: open_auditors_cur_w( p_report_header_id => p_report_header_id,
674: p_auditor_info_cur => l_auditor_info_cur);

Line 701: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

697: |
698: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
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

Line 702: | p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

698: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
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

Line 710: PROCEDURE transfer_report(p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

706: | Date Author Description of Changes
707: | 05-Sep-2002 Mohammad Shoaib Jamall Created
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;

Line 711: p_next_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,

707: | 05-Sep-2002 Mohammad Shoaib Jamall Created
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:

Line 832: p_auditor_id OUT NOCOPY AP_AUD_AUDITORS.AUDITOR_ID%TYPE)

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;
836: SELECT auditor_id INTO p_auditor_id FROM ap_aud_queues WHERE expense_report_id = p_report_header_id;

Line 871: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

867: retcode OUT NOCOPY VARCHAR2)
868: IS
869: l_expense_report_cur GenRefCursor;
870: l_expense_report_id NUMBER;
871: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
872: l_next_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
873:
874: l_sqlerrm VARCHAR2(2000);
875: l_subject VARCHAR2(200);

Line 872: l_next_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

868: IS
869: l_expense_report_cur GenRefCursor;
870: l_expense_report_id NUMBER;
871: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
872: l_next_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
873:
874: l_sqlerrm VARCHAR2(2000);
875: l_subject VARCHAR2(200);
876: BEGIN

Line 907: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;

903:
904: END reassign_orphaned_reports;
905:
906: PROCEDURE validate_auditors IS
907: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
908: l_security_profile_id AP_AUD_AUDITORS.SECURITY_PROFILE_ID%TYPE;
909: -- scratch variable
910: l_num NUMBER;
911: CURSOR c1 IS SELECT auditor_id, security_profile_id

Line 908: l_security_profile_id AP_AUD_AUDITORS.SECURITY_PROFILE_ID%TYPE;

904: END reassign_orphaned_reports;
905:
906: PROCEDURE validate_auditors IS
907: l_auditor_id AP_AUD_AUDITORS.AUDITOR_ID%TYPE;
908: l_security_profile_id AP_AUD_AUDITORS.SECURITY_PROFILE_ID%TYPE;
909: -- scratch variable
910: l_num NUMBER;
911: CURSOR c1 IS SELECT auditor_id, security_profile_id
912: FROM ap_aud_auditors

Line 912: FROM ap_aud_auditors

908: l_security_profile_id AP_AUD_AUDITORS.SECURITY_PROFILE_ID%TYPE;
909: -- scratch variable
910: l_num NUMBER;
911: CURSOR c1 IS SELECT auditor_id, security_profile_id
912: FROM ap_aud_auditors
913: WHERE auditor_id <> -1 AND security_profile_id IS NOT NULL;
914: BEGIN
915:
916: FOR rec IN c1 LOOP

Line 938: UPDATE ap_aud_auditors SET security_profile_id = null WHERE auditor_id = l_auditor_id;

934: AND f.function_name = 'OIE_AUD_AUDIT') sp
935: WHERE sp.security_profile_id = l_security_profile_id;
936:
937: IF (l_num = 0) THEN
938: UPDATE ap_aud_auditors SET security_profile_id = null WHERE auditor_id = l_auditor_id;
939: END IF;
940:
941: END LOOP;
942: