[Home] [Help]
PACKAGE: APPS.XTR_STREAMLINE_P
Source
1 PACKAGE XTR_STREAMLINE_P as
2 /* $Header: xtrstrms.pls 120.4 2005/11/24 09:28:42 badiredd ship $ */
3 -------------------------------------------------------------------------------------------------------------
4
5 -----------------------------------------------------------------------------------
6 -- Constants --
7 -----------------------------------------------------------------------------------
8 C_AUTH_YES constant VARCHAR2(1) := 'Y';
9
10
11 -- Event Codes --------------------------------------------------------------
12 C_RATES constant VARCHAR2(10) := 'RATES';
13 C_REVAL constant VARCHAR2(10) := 'REVAL';
14 C_RETROET constant VARCHAR2(10) := 'RETROET'; -- 3378028 FAS
15 C_ACCRUAL constant VARCHAR2(10) := 'ACCRUAL';
16 C_JOURNAL constant VARCHAR2(10) := 'JRNLGN';
17 C_GENERATE constant VARCHAR2(10) := 'GENERATE';
18 C_TRANSFER constant VARCHAR2(10) := 'TRANSFER';
19
20
21 -- Company Parameters --------------------------------------------------------
22 C_REVAL_PARAM constant VARCHAR2(15) := 'ACCNT_BPSTP';
23 C_RETRO_PARAM constant VARCHAR2(15) := 'ACCNT_BTEST'; -- 3378028 FAS
24
25
26 -- Process Options --------------------------------------------------------------
27 -- 3378028 FAS - Obsolete Options
28 -- C_PROCESS_REVAL constant VARCHAR2(30) := '1REVAL';
29 -- C_PROCESS_ACCRUAL constant VARCHAR2(30) := '2ACCRUAL';
30 -- C_PROCESS_JOURNAL constant VARCHAR2(30) := '3JRNLGEN';
31 -- C_PROCESS_TRANSFER constant VARCHAR2(30) := '4JRNLXFER';
32 -- 3378028 FAS - New Options
33 C_PROCESS_REVAL constant VARCHAR2(30) := '10REVAL';
34 C_PROCESS_RETROET constant VARCHAR2(30) := '20RETROET';
35 C_PROCESS_ACCRUAL constant VARCHAR2(30) := '30ACCRUAL';
36 C_PROCESS_JOURNAL constant VARCHAR2(30) := '40JRNLGEN';
37 C_PROCESS_TRANSFER constant VARCHAR2(30) := '50JRNLXFER';
38
39
40 -- Error Messages ---------------------------------------------------------------
41 C_INCOMPLETE_REVAL constant VARCHAR2(30) := 'XTR_INCOMPLETE_REVAL'; -- 1
42 C_NO_REVAL_DATA constant VARCHAR2(30) := 'XTR_NO_REVAL_DATA'; -- 2
43 C_NO_ACCRUAL_DATA constant VARCHAR2(30) := 'XTR_NO_ACCRUAL_DATA'; -- 3
44 C_NO_JOURNAL_DATA constant VARCHAR2(30) := 'XTR_NO_JOURNAL_DATA'; -- 4
45 C_LOCKED_REVAL constant VARCHAR2(30) := 'XTR_LOCKED_REVAL'; -- 5
46 C_LOCKED_ACCRUAL constant VARCHAR2(30) := 'XTR_LOCKED_ACCRUAL'; -- 6
47 C_LOCKED_JOURNAL constant VARCHAR2(30) := 'XTR_LOCKED_JOURNAL'; -- 7
48 C_LOCKED_BATCH constant VARCHAR2(30) := 'XTR_LOCKED_BATCH'; -- 8
49 C_INAUGURAL_MISSING constant VARCHAR2(30) := 'XTR_INAUGURAL_MISSING'; -- 9
50 C_INAUGURAL_TRANSFER constant VARCHAR2(30) := 'XTR_INAUGURAL_TRANSFER'; -- 10
51 C_CUTOFF_DATE_ERROR constant VARCHAR2(30) := 'XTR_CUTOFF_DATE_ERROR'; -- 11
52 C_COMPLETED_BATCH constant VARCHAR2(30) := 'XTR_COMPLETED_BATCH'; -- 12
53 C_BATCH_ERROR constant VARCHAR2(30) := 'XTR_BATCH_ERROR'; -- 13
54 C_NO_BATCH constant VARCHAR2(30) := 'XTR_NO_BATCH'; -- 14
55 C_NEW_BATCH constant VARCHAR2(30) := 'XTR_NEW_BATCH'; -- 15
56 C_SUBMIT_FAILURE constant VARCHAR2(30) := 'XTR_SUBMIT_FAILURE'; -- 16
57 C_SUBMIT_REQUEST constant VARCHAR2(30) := 'XTR_SUBMIT_REQUEST'; -- 17
58 C_SUBPROCESS_REVAL constant VARCHAR2(30) := 'XTR_SUBPROCESS_REVAL'; -- 18
59 C_SUBPROCESS_ACCRUAL constant VARCHAR2(30) := 'XTR_SUBPROCESS_ACCRUAL'; -- 19
60 C_SUBPROCESS_JOURNAL constant VARCHAR2(30) := 'XTR_SUBPROCESS_JOURNAL'; -- 20
61 C_SUBPROCESS_TRANSFER constant VARCHAR2(30) := 'XTR_SUBPROCESS_TRANSFER'; -- 21
62 C_GENERATED_RATES constant VARCHAR2(30) := 'XTR_GENERATED_RATES'; -- 22
63 C_GENERATED_REVAL constant VARCHAR2(30) := 'XTR_GENERATED_REVAL'; -- 23
64 C_GENERATED_ACCRUAL constant VARCHAR2(30) := 'XTR_GENERATED_ACCRUAL'; -- 24
65 C_GENERATED_JOURNAL constant VARCHAR2(30) := 'XTR_GENERATED_JOURNAL'; -- 25
66 C_AUTHORIZED_REVAL constant VARCHAR2(30) := 'XTR_AUTHORIZED_REVAL'; -- 26
67 C_AUTHORIZED_ACCRUAL constant VARCHAR2(30) := 'XTR_AUTHORIZED_ACCRUAL'; -- 27
68 C_TRANSFERRED_JOURNAL constant VARCHAR2(30) := 'XTR_TRANSFERRED_JOURNAL'; -- 28
69 C_MISSING_REVAL constant VARCHAR2(30) := 'XTR_MISSING_REVAL'; -- 29
70 C_MISSING_ACCRUAL constant VARCHAR2(30) := 'XTR_MISSING_ACCRUAL'; -- 30
71 C_MISSING_JOURNAL constant VARCHAR2(30) := 'XTR_MISSING_JOURNAL'; -- 31
72 C_TOTAL_SUBMIT constant VARCHAR2(30) := 'XTR_TOTAL_SUBMIT'; -- 32
73 C_TOTAL_FAIL constant VARCHAR2(30) := 'XTR_TOTAL_FAIL'; -- 33
74 C_TOTAL_COMPANY constant VARCHAR2(30) := 'XTR_TOTAL_COMPANY'; -- 34
75 C_COMPANY_NO_REVAL constant VARCHAR2(30) := 'XTR_COMPANY_NO_REVAL'; -- 35
76 -- 3378028 FAS
77 C_INCOMPLETE_RETROET constant VARCHAR2(30) := 'XTR_INCOMPLETE_RETROET'; -- 36
78 C_NO_RETROET_DATA constant VARCHAR2(30) := 'XTR_NO_RETROET_DATA'; -- 37
79 C_LOCKED_RETROET constant VARCHAR2(30) := 'XTR_LOCKED_RETROET'; -- 38
80 C_SUBPROCESS_RETROET constant VARCHAR2(30) := 'XTR_SUBPROCESS_RETROET'; -- 39
81 C_GENERATED_RETROET constant VARCHAR2(30) := 'XTR_GENERATED_RETROET'; -- 40
82 C_AUTHORIZED_RETROET constant VARCHAR2(30) := 'XTR_AUTHORIZED_RETROET'; -- 41
83 C_MISSING_RETROET constant VARCHAR2(30) := 'XTR_MISSING_RETROET'; -- 42
84 C_COMPANY_NO_RETROET constant VARCHAR2(30) := 'XTR_COMPANY_NO_RETROET'; -- 43
85 C_COMPANY_SKIP_RETROET constant VARCHAR2(30) := 'XTR_COMPANY_SKIP_RETROET'; -- 44
86 C_INVALID_STRM_PROCESS constant VARCHAR2(30) := 'XTR_INVALID_STRM_PROCESS'; -- 45
87
88 G_MULTIPLE_ACCT VARCHAR2(10) := 'ALLOW'; -- Bug 4639287
89
90 -----------------------------------------------------------------------------------
91 -- Exceptions --
92 -----------------------------------------------------------------------------------
93 e_record_locked EXCEPTION;
94 PRAGMA EXCEPTION_INIT(e_record_locked, -54);
95
96
97 -----------------------------------------------------------------------------------
98 -- Functions --
99 -----------------------------------------------------------------------------------
100
101 FUNCTION REVAL_DETAILS_INCOMPLETE (p_company IN VARCHAR2,
102 p_batch_start IN DATE,
103 p_batch_end IN DATE,
104 p_batch_id IN NUMBER) RETURN BOOLEAN;
105
106 -- 3378028 FAS
107 FUNCTION RETRO_DETAILS_INCOMPLETE (p_company IN VARCHAR2,
108 p_batch_start IN DATE,
109 p_batch_end IN DATE,
110 p_batch_id IN NUMBER) RETURN BOOLEAN;
111
112 FUNCTION GET_EVENT_STATUS (p_company IN VARCHAR2,
113 p_batch_id IN NUMBER,
114 p_batch_BED IN DATE, -- Batch End Date
115 p_event IN VARCHAR2,
116 p_authorize IN VARCHAR2) RETURN BOOLEAN;
117
118 FUNCTION EVENT_EXISTS (p_company IN VARCHAR2,
119 p_batch_id IN NUMBER,
120 p_batch_BED IN DATE,
121 p_event IN VARCHAR2) RETURN BOOLEAN;
122
123 FUNCTION EVENT_AUTHORIZED (p_company IN VARCHAR2,
124 p_batch_id IN NUMBER,
125 p_event IN VARCHAR2) RETURN BOOLEAN;
126
127 FUNCTION GET_PARTY_CREATED_ON (p_company IN VARCHAR2) RETURN DATE;
128
129
130 FUNCTION LOCK_BATCH (p_batch_id IN NUMBER,
131 p_company IN VARCHAR2,
132 p_no_data_error IN VARCHAR2,
133 p_locking_error IN VARCHAR2) RETURN NUMBER;
134
135 FUNCTION LOCK_EVENT (p_batch_id IN NUMBER,
136 p_event IN VARCHAR2,
137 p_authorized IN VARCHAR2,
138 p_no_data_error IN VARCHAR2,
139 p_locking_error IN VARCHAR2) RETURN NUMBER;
140
141 FUNCTION CHK_ELIGIBLE_COMPANY (p_company IN VARCHAR2,
142 p_cutoff_date IN DATE,
143 p_do_reval IN VARCHAR2,
144 p_do_retro IN VARCHAR2, -- 3378028 FAS
145 p_start_process IN VARCHAR2,
146 p_end_process IN VARCHAR2) RETURN NUMBER;
147
148 -----------------------------------------------------------------------------------
149 -- Procedures --
150 -----------------------------------------------------------------------------------
151
152 PROCEDURE GET_PREV_NORMAL_BATCH (p_company IN VARCHAR2,
153 p_curr_BED IN DATE,
154 p_prev_BID OUT NOCOPY NUMBER,
155 p_prev_BED OUT NOCOPY DATE);
156
157 PROCEDURE GET_LATEST_BATCH (p_company IN VARCHAR2,
158 p_batch_id OUT NOCOPY NUMBER,
159 p_batch_start OUT NOCOPY DATE,
160 p_batch_end OUT NOCOPY DATE,
161 p_gl_group_id OUT NOCOPY NUMBER,
162 p_upgrade_batch OUT NOCOPY VARCHAR2);
163
164 PROCEDURE GENERATE_REVAL_RATES (p_company IN VARCHAR2,
165 p_batch_start IN DATE,
166 p_batch_end IN DATE,
167 p_prev_batch_id IN NUMBER,
168 p_batch_id IN OUT NOCOPY NUMBER,
169 p_retcode OUT NOCOPY NUMBER);
170
171 PROCEDURE GENERATE_REVAL_DETAILS (p_retcode OUT NOCOPY NUMBER,
172 p_company IN VARCHAR2,
173 p_batch_start IN DATE,
174 p_batch_end IN DATE,
175 p_batch_id IN NUMBER,
176 p_prev_batch_id IN NUMBER);
177
178 PROCEDURE AUTHORIZE_REVAL_EVENT (p_retcode OUT NOCOPY NUMBER,
179 p_company IN VARCHAR2,
180 p_batch_id IN NUMBER,
181 p_prev_batch_id IN NUMBER);
182
183 PROCEDURE GENERATE_RETRO_DETAILS (p_retcode OUT NOCOPY NUMBER,
184 p_company IN VARCHAR2,
185 p_batch_start IN DATE,
186 p_batch_end IN DATE,
187 p_batch_id IN NUMBER,
188 p_prev_batch_id IN NUMBER);
189
190 PROCEDURE AUTHORIZE_RETRO_EVENT (p_retcode OUT NOCOPY NUMBER,
191 p_company IN VARCHAR2,
192 p_batch_id IN NUMBER,
193 p_prev_batch_id IN NUMBER);
194
195 PROCEDURE GENERATE_ACCRUAL_DETAILS (p_retcode OUT NOCOPY NUMBER,
196 p_company IN VARCHAR2,
197 p_do_reval IN VARCHAR2,
198 p_do_retro IN VARCHAR2, -- 3378028 FAS
199 p_batch_start IN DATE,
200 p_batch_end IN DATE,
201 p_batch_id IN OUT NOCOPY NUMBER, -- do not pass batch id for new batch
202 p_prev_batch_id IN NUMBER);
203
204 PROCEDURE AUTHORIZE_ACCRUAL_EVENT (p_retcode OUT NOCOPY NUMBER,
205 p_company IN VARCHAR2,
206 p_batch_id IN NUMBER,
207 p_prev_batch_id IN NUMBER);
208
209 PROCEDURE GENERATE_JOURNAL_DETAILS (p_retcode OUT NOCOPY NUMBER,
210 p_company IN VARCHAR2,
211 p_batch_id IN NUMBER,
212 p_prev_batch_id IN NUMBER);
213
214 PROCEDURE TRANSFER_JOURNALS (p_retcode OUT NOCOPY NUMBER,
215 p_company IN VARCHAR2,
216 p_batch_id IN NUMBER,
217 p_prev_batch_id IN NUMBER,
218 p_closed_periods IN VARCHAR2);
219
220 PROCEDURE REVAL_SUBPROCESS (p_retcode OUT NOCOPY NUMBER,
221 p_company IN VARCHAR2,
222 p_cutoff_date IN DATE);
223
224 PROCEDURE CREATE_NEW_REVAL (p_retcode OUT NOCOPY NUMBER,
225 p_company IN VARCHAR2,
226 p_incomplete IN VARCHAR2,
227 p_cutoff_date IN DATE);
228
229 PROCEDURE RETRO_SUBPROCESS (p_retcode OUT NOCOPY NUMBER,
230 p_company IN VARCHAR2,
231 p_cutoff_date IN DATE);
232
233 PROCEDURE ACCRUAL_SUBPROCESS (p_retcode OUT NOCOPY NUMBER,
234 p_company IN VARCHAR2,
235 p_do_reval IN VARCHAR2,
236 p_do_retro IN VARCHAR2, -- 3378028 FAS
237 p_cutoff_date IN DATE);
238
239 PROCEDURE CREATE_NEW_ACCRUAL (p_retcode OUT NOCOPY NUMBER,
240 p_company IN VARCHAR2,
241 p_do_reval IN VARCHAR2,
242 p_incomplete IN VARCHAR2,
243 p_cutoff_date IN DATE);
244
245 PROCEDURE JOURNAL_SUBPROCESS (p_retcode OUT NOCOPY NUMBER,
246 p_company IN VARCHAR2,
247 p_cutoff_date IN DATE);
248
249 PROCEDURE TRANSFER_SUBPROCESS (p_retcode OUT NOCOPY NUMBER,
250 p_company IN VARCHAR2,
251 p_cutoff_date IN DATE,
252 p_closed_periods IN VARCHAR2);
253
254 PROCEDURE PROCESS_COMPANY (p_errbuf OUT NOCOPY VARCHAR2,
255 p_retcode OUT NOCOPY NUMBER,
256 p_company IN VARCHAR2,
257 p_do_reval IN VARCHAR2,
261 p_start_process IN VARCHAR2,
258 p_do_retro IN VARCHAR2,
259 p_incomplete IN VARCHAR2,
260 p_cutoff_date IN VARCHAR2,
262 p_end_process IN VARCHAR2,
263 p_closed_periods IN VARCHAR2,
264 p_multiple_acct IN VARCHAR2); -- Added Bug 4639287
265
266 PROCEDURE MAIN_PROCESS (p_errbuf OUT NOCOPY VARCHAR2,
267 p_retcode OUT NOCOPY NUMBER,
268 p_company IN VARCHAR2,
269 p_cutoff_date IN VARCHAR2,
270 p_dummy_date IN VARCHAR2,
271 p_start_process IN VARCHAR2,
272 p_end_process IN VARCHAR2,
273 p_dummy_process IN VARCHAR2,
274 p_closed_periods IN VARCHAR2,
275 p_multiple_acct IN VARCHAR2); -- Added Bug 4639287
276
277
278 end XTR_STREAMLINE_P;