26: |
27: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
28: |
29: | PARAMETERS
30: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
31: |
32: | MODIFICATION HISTORY
33: | Date Author Description of Changes
34: | 04-Sep-2002 Mohammad Shoaib Jamall Created
34: | 04-Sep-2002 Mohammad Shoaib Jamall Created
35: |
36: *=======================================================================*/
37: FUNCTION report_weight(p_report_header_id IN
38: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE) RETURN NUMBER;
39:
40: /*========================================================================
41: | PUBLIC PROCEDURE assign_to_last_auditor
42: |
48: |
49: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
50: |
51: | PARAMETERS
52: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
53: |
54: | MODIFICATION HISTORY
55: | Date Author Description of Changes
56: | 22-Feb-2008 SaiKumar Talasila Created
56: | 22-Feb-2008 SaiKumar Talasila Created
57: |
58: *=======================================================================*/
59: PROCEDURE assign_to_last_auditor(p_report_header_id IN
60: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE);
61:
62: /*========================================================================
63: | PUBLIC PROCEDURE enqueue_for_audit
64: |
69: |
70: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
71: |
72: | PARAMETERS
73: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
74: |
75: | MODIFICATION HISTORY
76: | Date Author Description of Changes
77: | 05-Sep-2002 Mohammad Shoaib Jamall Created
77: | 05-Sep-2002 Mohammad Shoaib Jamall Created
78: |
79: *=======================================================================*/
80: PROCEDURE enqueue_for_audit(p_report_header_id IN
81: AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE);
82:
83: /*========================================================================
84: | PUBLIC PROCEDURE assign_report_to_auditor
85: |
100: |
101: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
102: |
103: | PARAMETERS
104: | p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
105: | p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE
106: |
107: | MODIFICATION HISTORY
108: | Date Author Description of Changes
109: | 05-Sep-2002 Mohammad Shoaib Jamall Created
110: |
111: *=======================================================================*/
112: PROCEDURE assign_report_to_auditor(
113: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
114: p_auditor_id IN AP_AUD_AUDITORS.AUDITOR_ID%TYPE,
115: p_retcode OUT NOCOPY VARCHAR2);
116:
117: /*========================================================================
148: |
149: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
150: |
151: | PARAMETERS
152: | p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE
153: | p_cust_acct_cur IN GenRefCursor
154: |
155: | MODIFICATION HISTORY
156: | Date Author Description of Changes
156: | Date Author Description of Changes
157: | 05-Sep-2002 Mohammad Shoaib Jamall Created
158: |
159: *=======================================================================*/
160: PROCEDURE open_auditors_info_cursor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
161: p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE,
162: p_auditor_info_cur OUT NOCOPY GenRefCursor);
163:
164: /*========================================================================
157: | 05-Sep-2002 Mohammad Shoaib Jamall Created
158: |
159: *=======================================================================*/
160: PROCEDURE open_auditors_info_cursor(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
161: p_org_id IN AP_EXPENSE_REPORT_HEADERS_ALL.ORG_ID%TYPE,
162: p_auditor_info_cur OUT NOCOPY GenRefCursor);
163:
164: /*========================================================================
165: | PUBLIC FUNCTION is_function_on_menu
198: |
199: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
200: |
201: | PARAMETERS
202: | p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE
203: |
204: | MODIFICATION HISTORY
205: | Date Author Description of Changes
206: | 05-Sep-2002 Mohammad Shoaib Jamall Created
206: | 05-Sep-2002 Mohammad Shoaib Jamall Created
207: |
208: *=======================================================================*/
209:
210: FUNCTION report_shortpaid(p_report_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE)
211: RETURN BOOLEAN;
212:
213:
214: /*========================================================================
231: | 16-Oct-2002 Mohammad Shoaib Jamall Created
232: |
233: *=======================================================================*/
234: PROCEDURE remove_from_queue(
235: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE);
236:
237: /*========================================================================
238: | PUBLIC PROCEDURE auditor_for_report
239: |
256: | 16-Oct-2002 Mohammad Shoaib Jamall Created
257: |
258: *=======================================================================*/
259: PROCEDURE auditor_for_report(
260: p_report_header_id IN AP_EXPENSE_REPORT_HEADERS_ALL.REPORT_HEADER_ID%TYPE,
261: p_auditor_id OUT NOCOPY AP_AUD_AUDITORS.AUDITOR_ID%TYPE);
262:
263: /*========================================================================
264: | PUBLIC PROCEDURE reassign_orphaned_reports