1 PACKAGE PSB_WS_ACCT2 AS
2 /* $Header: PSBVWA2S.pls 120.5 2005/11/14 11:54:00 viraghun ship $ */
3
4 TYPE g_defccid_rec_type IS RECORD
5 ( budget_group_id NUMBER,
6 num_proposed_years NUMBER,
7 ccid NUMBER,
8 ccid_start_period DATE,
9 ccid_end_period DATE );
10
11 TYPE g_defccid_tbl_type IS TABLE OF g_defccid_rec_type
12 INDEX BY BINARY_INTEGER;
13
14 g_deferred_ccids g_defccid_tbl_type;
15 g_num_defccids NUMBER;
16
17 TYPE g_sortccid_rec_type IS RECORD
18 ( budget_group_id NUMBER,
19 num_proposed_years NUMBER,
20 ccid NUMBER,
21 ccid_start_period DATE,
22 ccid_end_period DATE );
23
24 TYPE g_sortccid_tbl_type IS TABLE OF g_sortccid_rec_type
25 INDEX BY BINARY_INTEGER;
26
27 g_sorted_ccids g_sortccid_tbl_type;
28 g_num_sortccids NUMBER;
29
30 --bug 3704360.defined the following public variable.
31 g_running_total NUMBER;
32
33 TYPE g_depccid_rec_type IS RECORD
34 (ccid NUMBER,
35 dependent_ccid NUMBER );
36
37 TYPE g_depccid_tbl_type IS TABLE OF g_depccid_rec_type
38 INDEX BY BINARY_INTEGER;
39
40 g_dependent_ccids g_depccid_tbl_type;
41 g_num_depccids NUMBER;
42
43 /* ----------------------------------------------------------------------- */
44
45 -- API name : Create_Worksheet_Accounts
46 -- Type : Private <Implementation>
47 -- Pre-reqs : FND_API, FND_MESSAGE
48 -- .
49 -- Version : Current version 1.0
50 -- Initial version 1.0
51 -- Created 05/16/1997 by Supriyo Ghosh
52 -- Modified 06/25/1997 by Supriyo Ghosh
53 -- Modified 09/02/1997 by Supriyo Ghosh
54 -- Included 2 new Parameters for BC
55 --
56 -- Notes : Create Worksheet Account Lines for Budget Group
57 -- after applying all Account Parameters specified
58 -- in the Parameter Set and distributing the Account
59 -- Lines using the Allocation Rules
60 --
61
62 PROCEDURE Create_Worksheet_Accounts
63 ( p_return_status OUT NOCOPY VARCHAR2,
64 p_worksheet_id IN NUMBER,
65 p_rounding_factor IN NUMBER,
66 p_stage_set_id IN NUMBER,
67 p_service_package_id IN NUMBER,
68 p_start_stage_seq IN NUMBER,
69 p_allocrule_set_id IN NUMBER,
70 p_budget_group_id IN NUMBER,
71 p_flex_code IN NUMBER,
72 p_parameter_set_id IN NUMBER,
73 p_budget_calendar_id IN NUMBER,
74 p_gl_cutoff_period IN DATE,
75 p_include_gl_commit_balance IN VARCHAR2,
76 p_include_gl_oblig_balance IN VARCHAR2,
77 p_include_gl_other_balance IN VARCHAR2,
78 p_budget_version_id IN NUMBER,
79 p_flex_mapping_set_id IN NUMBER,
80 p_gl_budget_set_id IN NUMBER,
81 p_set_of_books_id IN NUMBER,
82 p_set_of_books_name IN VARCHAR2,
83 p_func_currency IN VARCHAR2,
84 p_budgetary_control IN VARCHAR2,
85 p_incl_stat_bal IN VARCHAR2,
86 p_incl_trans_bal IN VARCHAR2,
87 p_incl_adj_period IN VARCHAR2,
88 p_num_proposed_years IN NUMBER,
89 p_num_years_to_allocate IN NUMBER,
90 p_budget_by_position IN VARCHAR2,
91 /* Bug No 4725091 */
92 P_incl_gl_fwd_balance IN VARCHAR2
93 );
94
95 /* ----------------------------------------------------------------------- */
96
97 -- API name : Update_GL_Balances
98 -- Type : Private <Implementation>
99 -- Pre-reqs : FND_API, FND_MESSAGE
100 -- .
101 -- Version : Current version 1.0
102 -- Initial version 1.0
103 -- Created 01/20/1998 by Supriyo Ghosh
104 --
105 -- Notes : Update CY GL Balances
106 --
107
108 PROCEDURE Update_GL_Balances
109 ( p_api_version IN NUMBER,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
111 p_return_status OUT NOCOPY VARCHAR2,
112 p_worksheet_id IN NUMBER
113 );
114
115 /* ----------------------------------------------------------------------- */
116
117 -- API name : Revise_Account_Projections
118 -- Type : Private <Implementation>
119 -- Pre-reqs : FND_API, FND_MESSAGE
120 -- .
121 -- Version : Current version 1.0
122 --
123 -- Notes : Revise Account Projections
124 --
125
126 PROCEDURE Revise_Account_Projections
127 ( p_api_version IN NUMBER,
128 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
129 p_return_status OUT NOCOPY VARCHAR2,
130 p_worksheet_id IN NUMBER,
131 p_parameter_id IN NUMBER
132 );
133
134 /* ----------------------------------------------------------------------- */
135
136 -- API name : Process_Deferred_CCIDs
137 -- Type : Private <Implementation>
138 -- Pre-reqs : FND_API, FND_MESSAGE
139 -- .
140 -- Version : Current version 1.0
141 --
142 -- Notes : Process accounts that were deferred for processing
143 --
144
145 PROCEDURE Process_Deferred_CCIDs
146 ( p_return_status OUT NOCOPY VARCHAR2,
147 p_worksheet_id IN NUMBER,
148 p_service_package_id IN NUMBER,
149 p_sequence_number IN NUMBER,
150 p_gl_cutoff_period IN DATE,
151 p_allocrule_set_id IN NUMBER,
152 p_rounding_factor IN NUMBER,
153 p_stage_set_id IN NUMBER,
154 p_flex_code IN NUMBER,
155 p_flex_mapping_set_id IN NUMBER,
156 p_func_currency IN VARCHAR2,
157 p_num_years_to_allocate IN NUMBER,
158 p_parameter_set_id IN NUMBER,
159 p_budget_calendar_id IN NUMBER,
160 p_budget_by_position IN VARCHAR2
161 );
162
163 /* ----------------------------------------------------------------------- */
164
165 -- API name : Apply_Account_Parameters
166 -- Type : Private <Implementation>
167 -- Pre-reqs : FND_API, FND_MESSAGE
168 -- .
169 -- Version : Current version 1.0
170 -- Initial version 1.0
171 -- Created 05/18/1997 by Supriyo Ghosh
172 -- Changed 10/28/1997 by Supriyo Ghosh
173 -- Added Parameters for Volume Inserts
174 -- Changed 11/14/1997 by Supriyo Ghosh
175 -- Added Parameters for Deferred Processing
176 --
177 -- Notes : Apply Account Parameters for a specific CCID
178 --
179
180 PROCEDURE Apply_Account_Parameters
181 ( p_api_version IN NUMBER,
182 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
183 p_return_status OUT NOCOPY VARCHAR2,
184 p_worksheet_id IN NUMBER,
185 p_service_package_id IN NUMBER,
186 p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
187 p_current_stage_seq IN NUMBER,
188 p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
189 p_stage_set_id IN NUMBER,
190 p_budget_group_id IN NUMBER,
191 p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
192 p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
193 p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
194 p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
195 p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
196 p_ccid IN NUMBER,
197 p_ccid_start_period IN DATE,
198 p_ccid_end_period IN DATE,
199 p_num_proposed_years IN NUMBER,
200 p_num_years_to_allocate IN NUMBER := FND_API.G_MISS_NUM,
201 p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
202 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
203 p_budget_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
204 p_defer_ccids IN VARCHAR2 := FND_API.G_TRUE
205 );
206
207 /* ----------------------------------------------------------------------- */
208
209 -- API name : Distribute_Account_Lines
210 -- Type : Private <Implementation>
211 -- Pre-reqs : FND_API, FND_MESSAGE
212 -- .
213 -- Version : Current version 1.0
214 -- Initial version 1.0
215 -- Created 05/18/1997 by Supriyo Ghosh
216 --
217 -- Notes : Distribute Account Lines using Allocation Rules
218 --
219
220 PROCEDURE Distribute_Account_Lines
221 ( p_return_status OUT NOCOPY VARCHAR2,
222 p_worksheet_id IN NUMBER,
223 p_flex_mapping_set_id IN NUMBER,
224 p_budget_year_type_id IN NUMBER,
225 p_allocrule_set_id IN NUMBER,
226 p_budget_calendar_id IN NUMBER,
227 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
228 p_ccid IN NUMBER,
229 p_ytd_amount IN NUMBER,
230 p_allocation_type IN VARCHAR2,
231 /* Bug No 2342169 Start */
232 p_rounding_factor IN NUMBER,
233 /* Bug No 2342169 End */
234 p_effective_start_date IN DATE,
235 p_effective_end_date IN DATE,
236 p_budget_periods IN PSB_WS_ACCT1.g_budgetperiod_tbl_type,
237 p_period_amount OUT NOCOPY PSB_WS_ACCT1.g_prdamt_tbl_type
238 );
239
240 /* ----------------------------------------------------------------------- */
241
242 -- API name : Distribute_Account_Lines
243 -- Type : Private <Implementation>
244 -- Pre-reqs : FND_API, FND_MESSAGE
245 -- .
246 -- Version : Current version 1.0
247 -- Initial version 1.0
248 -- Created 07/11/1997 by SGhosh
249 -- Changed 10/28/1997 by Supriyo Ghosh
250 -- Added Parameters for Volume Inserts
251 --
252 -- Notes : Redistribute YTD Amounts for Account Lines
253 --
254
255 PROCEDURE Distribute_Account_Lines
256 ( p_return_status OUT NOCOPY VARCHAR2,
257 p_worksheet_id IN NUMBER,
258 p_service_package_id IN NUMBER,
259 p_stage_set_id IN NUMBER,
260 p_current_stage_seq IN NUMBER,
261 p_account_line_id IN NUMBER,
262 p_rounding_factor IN NUMBER,
263 p_old_ytd_amount IN NUMBER,
264 p_new_ytd_amount IN NUMBER,
265 -- Bug#3128597: Support prorated allocation during annual amount updation
266 p_cy_ytd_amount IN NUMBER := NULL,
267 -- Bug#3128597: End
268 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
269 );
270
271 /* ----------------------------------------------------------------------- */
272
273 -- API name : Create_Rollup_Totals
274 -- Type : Private <Implementation>
275 -- Pre-reqs : FND_API, FND_MESSAGE
276 -- .
277 -- Version : Current version 1.0
278 -- Initial version 1.0
279 -- Created 05/18/1997 by Supriyo Ghosh
280 -- Modified 06/25/1997 by Supriyo Ghosh
281 --
282 -- Notes : Create Summary Rollups for Worksheet Accounts
283 --
284
285 PROCEDURE Create_Rollup_Totals
286 ( p_api_version IN NUMBER,
287 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
288 p_return_status OUT NOCOPY VARCHAR2,
289 p_worksheet_id IN NUMBER,
290 p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
291 p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
292 p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
293 p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
294 p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
295 p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
296 p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM
297 );
298
299 /* ----------------------------------------------------------------------- */
300
301 -- API name : Get_Debug
302 -- Type : Private
303 -- Pre-reqs : None
304
305 FUNCTION Get_Debug RETURN VARCHAR2;
306
307 /* ----------------------------------------------------------------------- */
308
309 END PSB_WS_ACCT2;