1 PACKAGE JL_BR_AR_BANK_ACCT_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlbrslas.pls 120.11.12010000.1 2008/07/31 04:23:37 appldev ship $ */
3
4 /*========================================================================
5 | PUBLIC PROCEDURE Create_Event_Dists
6 |
7 | DESCRIPTION
8 | Main routine which creates SLA Event and distributions for
9 | JLBR AR Bank Transfer accounting. It returns EVENT_ID value
10 |
11 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
12 |
13 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
14 | a) Create_SLA_Event
15 | b) Create_Distribution
16 | c) Cancel_Reject_Distributions
17 |
18 | PARAMETERS
19 |
20 | KNOWN ISSUES
21 |
22 | NOTES
23 |
24 | MODIFICATION HISTORY
25 | Date Author Description of Changes
26 *=======================================================================*/
27
28 TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
29
30 TYPE VARCHAR2_TBL_TYPE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
31
32 TYPE r_dist is Record
33 (
34 rev_dist_id NUMBER_TBL_TYPE,
35 dist_id NUMBER_TBL_TYPE
36 );
37
38 TYPE r_event is Record
39 (
40 row_id VARCHAR2_TBL_TYPE,
41 EVENT_TYPE_CODE VARCHAR2_TBL_TYPE,
42 EVENT_ID NUMBER_TBL_TYPE,
43 CANCEL_EVENT_ID NUMBER_TBL_TYPE
44 );
45
46 trx_dist r_dist;
47
48 trx_events r_event;
49
50 PROCEDURE Create_Event_Dists (p_event_type_code IN VARCHAR2,
51 p_event_date IN DATE,
52 p_document_id IN NUMBER,
53 p_gl_date IN DATE,
54 p_occurrence_id IN NUMBER,
55 p_bank_occurrence_type IN VARCHAR2,
56 p_bank_occurrence_code IN VARCHAR2,
57 p_std_occurrence_code IN VARCHAR2,
58 p_bordero_type IN VARCHAR2,
59 p_endorsement_amt IN NUMBER,
60 p_bank_charges_amt IN NUMBER,
61 p_factoring_charges_amt IN NUMBER,
62 p_event_id OUT NOCOPY NUMBER);
63
64 /*========================================================================
65 | PUBLIC PROCEDURE Upgrade_Occurrences
66 |
67 | DESCRIPTION
68 | Upgrades Occurrences during downtime and on-demand upgrade
69 |
70 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
71 |
72 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
73 |
74 | PARAMETERS
75 |
76 | KNOWN ISSUES
77 |
78 | NOTES
79 |
80 | MODIFICATION HISTORY
81 | Date Author Description of Changes
82 *=======================================================================*/
83
84 -- Called by Downtime Upgrade script
85 -- Internally calls the other version
86
87 PROCEDURE UPGRADE_OCCURRENCES(
88 l_table_owner IN VARCHAR2,
89 l_table_name IN VARCHAR2,
90 l_script_name IN VARCHAR2,
91 l_worker_id IN VARCHAR2,
92 l_num_workers IN VARCHAR2,
93 l_batch_size IN VARCHAR2,
94 l_batch_id IN NUMBER,
95 l_action_flag IN VARCHAR2);
96
97 -- Main Upgrade Procedure
98 PROCEDURE UPGRADE_OCCURRENCES(
99 l_table_owner IN VARCHAR2,
100 l_table_name IN VARCHAR2,
101 l_script_name IN VARCHAR2,
102 l_worker_id IN VARCHAR2,
103 l_num_workers IN VARCHAR2,
104 l_batch_size IN VARCHAR2,
105 l_batch_id IN NUMBER,
106 l_action_flag IN VARCHAR2,
107 x_return_status OUT NOCOPY VARCHAR2);
108
109 /*========================================================================
110 | PUBLIC PROCEDURE Update_Distributions
111 |
112 | DESCRIPTION
113 | Upgrades Occurrences during downtime and on-demand upgrade
114 |
115 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
116 |
117 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
118 |
119 | PARAMETERS
120 |
121 | KNOWN ISSUES
122 |
123 | NOTES
124 |
125 | MODIFICATION HISTORY
126 | Date Author Description of Changes
127 *=======================================================================*/
128
129 -- Main Upgrade Procedure
130 PROCEDURE UPDATE_OCCURRENCES(
131 l_table_owner IN VARCHAR2,
132 l_table_name IN VARCHAR2,
133 l_script_name IN VARCHAR2,
134 l_worker_id IN VARCHAR2,
135 l_num_workers IN VARCHAR2,
136 l_batch_size IN VARCHAR2,
137 l_batch_id IN NUMBER,
138 l_action_flag IN VARCHAR2,
139 x_return_status OUT NOCOPY VARCHAR2);
140
141 /*========================================================================
142 | PUBLIC PROCEDURE Upgrade_Distributions
143 |
144 | DESCRIPTION
145 | Upgrades Distributions during downtime and on-demand upgrade
146 |
147 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
148 |
149 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
150 |
151 | PARAMETERS
152 |
153 | KNOWN ISSUES
154 |
155 | NOTES
156 |
157 | MODIFICATION HISTORY
158 | Date Author Description of Changes
159 *=======================================================================*/
160
161 PROCEDURE UPGRADE_DISTRIBUTIONS(
162 l_start_id IN NUMBER,
163 l_end_id IN NUMBER);
164
165 /*========================================================================
166 | PUBLIC PROCEDURE Update_distributions
167 |
168 | DESCRIPTION
169 | Updates Distributions during downtime and on-demand upgrade
170 |
171 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
172 |
173 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
174 |
175 | PARAMETERS
176 |
177 | KNOWN ISSUES
178 |
179 | NOTES
180 |
181 | MODIFICATION HISTORY
182 | Date Author Description of Changes
183 *=======================================================================*/
184
185 /*
186 PROCEDURE UPDATE_DISTRIBUTIONS(
187 l_start_rowid IN rowid,
188 l_end_rowid IN rowid);
189
190 */
191 /*========================================================================
192 | PUBLIC PROCEDURE Load_Occurrences_Header_Data
193 |
194 | DESCRIPTION
195 | Inserts into AR_XLA_LINES_EXTRACT to get AR Sources for SLA Events
196 | of Collection Document Occurrences
197 |
198 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
199 |
200 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
201 |
202 | PARAMETERS
203 |
204 | KNOWN ISSUES
205 |
206 | NOTES
207 |
208 | MODIFICATION HISTORY
209 | Date Author Description of Changes
210 *=======================================================================*/
211
212 PROCEDURE load_occurrences_header_data(p_application_id IN NUMBER);
213
214 /*========================================================================
215 | PUBLIC FUNCTION Check_If_Upgrade_Occs
216 |
217 | DESCRIPTION
218 | To be used only by the on-demand SLA upgrade program of AR to check
219 | if Brazilian Occurrences Upgrade is to be executed or not
220 |
221 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
222 |
223 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
224 |
225 | PARAMETERS
226 |
227 | KNOWN ISSUES
228 |
229 | NOTES
230 |
231 | MODIFICATION HISTORY
232 | Date Author Description of Changes
233 *=======================================================================*/
234
235 FUNCTION check_if_upgrade_occs RETURN BOOLEAN;
236
237 /*============================================================================+
238 |
239 | PUBLIC PROCEDURE Check_If_Upgrade_Occs
240 |
241 | DESCRIPTION
242 | Upgrades JL MRC records to SLA Archetecture
243 |
244 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
245 |
246 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
247 |
248 | PARAMETERS
249 |
250 | KNOWN ISSUES
251 |
252 | NOTES
253 |
254 | MODIFICATION HISTORY
255 | Date Author Description of Changes
256 | 21-SEP-2005 JVARKEY Created
257 *============================================================================*/
258
259 -- Called by Downtime Upgrade script
260 -- Internally calls the other version
261
262 PROCEDURE UPGRADE_MC_OCCURRENCES(
263 l_table_owner IN VARCHAR2,
264 l_table_name IN VARCHAR2,
265 l_script_name IN VARCHAR2,
266 l_worker_id IN VARCHAR2,
267 l_num_workers IN VARCHAR2,
268 l_batch_size IN VARCHAR2,
269 l_batch_id IN NUMBER,
270 l_action_flag IN VARCHAR2);
271
272 -- Main Upgrade Procedure
273
274 PROCEDURE UPGRADE_MC_OCCURRENCES(
275 l_table_owner IN VARCHAR2,
276 l_table_name IN VARCHAR2,
277 l_script_name IN VARCHAR2,
278 l_worker_id IN VARCHAR2,
279 l_num_workers IN VARCHAR2,
280 l_batch_size IN VARCHAR2,
281 l_batch_id IN NUMBER,
282 l_action_flag IN VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2);
284
285 END JL_BR_AR_BANK_ACCT_PKG;