1 PACKAGE AP_WEB_AUDIT_PROCESS AUTHID CURRENT_USER AS
2 /* $Header: apwaudps.pls 120.3 2006/01/10 18:36:06 qle noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 /*========================================================================
9 | PUBLIC FUNCTION process_expense_report
10 |
11 | DESCRIPTION
12 | This function does audit processing for a given expense report.
13 |
14 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
15 | Called from BC4J.
16 |
17 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
18 |
19 | RETURNS
20 | Tag containing auditing information as VARCHAR2.
21 |
22 | PARAMETERS
23 | p_report_header_id IN Expense Report identifier
24 |
25 | MODIFICATION HISTORY
26 | Date Author Description of Changes
27 | 13-Oct-2002 J Rautiainen Created
28 |
29 *=======================================================================*/
30 FUNCTION process_expense_report(p_report_header_id IN NUMBER) RETURN VARCHAR2;
31
32 /*========================================================================
33 | PUBLIC PROCEDURE add_to_audit_list
34 |
35 | DESCRIPTION
36 | This procedure inserts given employee to audit list.
37 |
38 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
39 | Called from BC4J.
40 |
41 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
42 |
43 | RETURNS
44 |
45 | PARAMETERS
46 | p_employee_id IN Employee identifier
47 | p_reason_code IN Reason code
48 | p_duration IN Duration
49 |
50 | MODIFICATION HISTORY
51 | Date Author Description of Changes
52 | 13-Oct-2002 J Rautiainen Created
53 |
54 *=======================================================================*/
55 PROCEDURE add_to_audit_list(p_employee_id IN NUMBER,
56 p_duration IN NUMBER,
57 p_reason_code IN VARCHAR2);
58
59 /**
60 * jrautiai ADJ Fix Start
61 */
62 /*========================================================================
63 | PUBLIC PROCEDURE process_audit_actions
64 |
65 | DESCRIPTION
66 | This procedure deals with auditor adjustments. This logic is called
67 | when audit is completed and it deals with adjustments in reimbursable
68 | amount and shortpayments.
69 |
70 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
71 | Called from expense report form and HTML UI when auditor
72 | completes audit.
73 |
74 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
75 |
76 | RETURNS
77 | None
78 |
79 | PARAMETERS
80 | p_report_header_id IN Expense report to processed
81 |
82 | MODIFICATION HISTORY
83 | Date Author Description of Changes
84 | 15-Jul-2003 J Rautiainen Created
85 |
86 *=======================================================================*/
87 PROCEDURE process_audit_actions(p_report_header_id IN NUMBER);
88
89 /*========================================================================
90 | PUBLIC PROCEDURE update_cc_transaction
91 |
92 | DESCRIPTION
93 | This procedure updates the CC transaction amounts to match the
94 | amounts on the expense line.
95 |
96 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
97 | process_audit_actions
98 |
99 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
100 |
101 | RETURNS
102 | None
103 | PARAMETERS
104 | Expense line record containing the data on the modified expense line
105 |
106 | MODIFICATION HISTORY
107 | Date Author Description of Changes
108 | 21-Jul-2003 J Rautiainen Created
109 |
110 *=======================================================================*/
111 PROCEDURE update_cc_transaction(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE);
112
113
114 /*========================================================================
115 | PUBLIC PROCEDURE process_shortpays
116 |
117 | DESCRIPTION
118 | This procedure processes shortpayments on a line, namely if one of
119 | itemized lines is shortpaid, then all the itemized lines are
120 | shortpaid as well.
121 |
122 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
123 | process_audit_actions
124 |
125 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
126 |
127 | RETURNS
128 | None
129 | PARAMETERS
130 | Expense line record containing the data on the modified expense line
131 |
132 | MODIFICATION HISTORY
133 | Date Author Description of Changes
134 | 21-Jul-2003 J Rautiainen Created
135 |
136 *=======================================================================*/
137 PROCEDURE process_shortpays(expense_line_rec IN AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE);
138
139
140 /*========================================================================
141 | PUBLIC PROCEDURE process_rate_rounding
142 |
143 | DESCRIPTION
144 | This procedure calculates and creates any rounding lines needed due
145 | to rounding issues.
146 |
147 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
148 | process_audit_actions
149 |
150 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
151 |
152 | RETURNS
153 | None
154 |
155 | PARAMETERS
156 | Expense report header identifier to be processed
157 |
158 | MODIFICATION HISTORY
159 | Date Author Description of Changes
160 | 21-Jul-2003 J Rautiainen Created
161 |
162 *=======================================================================*/
163 PROCEDURE process_rate_rounding(p_report_header_id IN NUMBER);
164
165 /*========================================================================
166 | PUBLIC FUNCTION bothpay_personal_cc_only
167 |
168 | DESCRIPTION
169 | This function checks if the report has only bothpay personal credit card expenses
170 |
171 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
172 | Called from function process_expense_report(p_report_header_id IN NUMBER
173 |
174 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
175 |
176 | RETURNS
177 | TRUE in case the report has only bothpay personal credit card expenses,
178 | otherwise FALSE
179 |
180 | PARAMETERS
181 | p_report_header_id IN Expense Report identifier
182 |
183 | MODIFICATION HISTORY
184 | Date Author Description of Changes
185 | 28-Feb-2005 Maulik Vadera Created
186 |
187 *=======================================================================*/
188
189 FUNCTION bothpay_personal_cc_only(p_report_header_id IN NUMBER) RETURN BOOLEAN;
190
191 /**
192 * jrautiai ADJ Fix end
193 */
194 END AP_WEB_AUDIT_PROCESS;