1 PACKAGE CST_SubElements_PVT AUTHID CURRENT_USER AS
2 /* $Header: CSTVCCYS.pls 115.4 2002/11/11 23:18:55 gwu ship $ */
3
4 TYPE nonmatching_rec_type IS RECORD
5 ( code VARCHAR2(10),
6 ID NUMBER,
7 source VARCHAR2(1)
8 );
9
10 TYPE nonmatching_tbl_type IS TABLE OF nonmatching_rec_type
11 index by binary_integer;
12
13 ----------------------------------------------------------------------------
14 -- PROCEDURE --
15 -- processInterface --
16 -- --
17 -- DESCRIPTION --
18 -- This API serves as the wrapper that suitably creates or summarizes --
19 -- subelements in the enhanced interorg cost copy program --
20 -- --
21 -- PURPOSE: --
22 -- Oracle Applications Rel 11i.3 --
23 -- --
24 -- --
25 -- HISTORY: --
26 -- 09/14/00 Anitha B Created --
27 ----------------------------------------------------------------------------
28 PROCEDURE processInterface (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31 p_commit IN VARCHAR2 := FND_API.G_FALSE,
32 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
33
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37
38 p_group_id IN NUMBER,
39 p_from_organization_id IN NUMBER,
40 p_to_organization_id IN NUMBER,
41 p_from_cost_type_id IN NUMBER,
42 p_to_cost_type_id IN NUMBER,
43 p_summary_option IN NUMBER,
44 p_mtl_subelement IN NUMBER,
45 p_moh_subelement IN NUMBER,
46 p_res_subelement IN NUMBER,
47 p_osp_subelement IN NUMBER,
48 p_ovh_subelement IN NUMBER,
49 p_conv_type IN VARCHAR2,
50 p_exact_copy_flag IN VARCHAR2 );
51
52
53 ----------------------------------------------------------------------------
54 -- PROCEDURE --
55 -- getNonMatchingSubElements --
56 -- --
57 -- DESCRIPTION --
58 -- This API fetches all the non-matching subelements bewteen two --
59 -- organizations and returns them in a PL/SQL table format --
60 -- --
61 -- PURPOSE: --
62 -- Oracle Applications Rel 11i.3 --
63 -- --
64 -- --
65 -- HISTORY: --
66 -- 09/14/00 Anitha B Created --
67 ----------------------------------------------------------------------------
68
69 PROCEDURE getNonMatchingSubElements (
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72 p_commit IN VARCHAR2 := FND_API.G_FALSE,
73 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78
79 x_subelement_tbl OUT NOCOPY nonmatching_tbl_type,
80 x_department_tbl OUT NOCOPY nonmatching_tbl_type,
81 x_activity_tbl OUT NOCOPY nonmatching_tbl_type,
82 x_subelement_count OUT NOCOPY NUMBER,
83 x_department_count OUT NOCOPY NUMBER,
84 x_activity_count OUT NOCOPY NUMBER,
85
86 p_group_id IN NUMBER,
87 p_from_organization_id IN NUMBER ,
88 p_to_organization_id IN NUMBER );
89
90
91
92 ----------------------------------------------------------------------------
93 -- PROCEDURE --
94 -- createSubElements --
95 -- --
96 -- DESCRIPTION --
97 -- This API creates subelements in an organization. It also creates --
98 -- the necessary departments to which the subelements belong as --
99 -- required. --
100 -- --
101 -- PURPOSE: --
102 -- Oracle Applications Rel 11i.3 --
103 -- --
104 -- --
105 -- HISTORY: --
106 -- 09/14/00 Hemant Gosain Created --
107 ----------------------------------------------------------------------------
108
109 PROCEDURE createSubElements (
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114
115
116 p_subelement_tbl IN nonmatching_tbl_type,
117 p_department_tbl IN nonmatching_tbl_type,
118 p_activity_tbl IN nonmatching_tbl_type,
119 p_subelement_count IN NUMBER,
120 p_department_count IN NUMBER,
121 p_activity_count IN NUMBER,
122 p_from_organization_id IN NUMBER ,
123 p_to_organization_id IN NUMBER,
124 p_exact_copy_flag IN VARCHAR2,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2);
128
129 ----------------------------------------------------------------------------
130 -- PROCEDURE --
131 -- getDeptAccounts --
132 -- --
133 -- DESCRIPTION --
134 -- This API serevs as a client extension for returning department
135 -- accounts if the organization is WSM enabled. --
136 -- --
137 -- PURPOSE: --
138 -- Oracle Applications Rel 11i.3 --
139 -- --
140 -- --
141 -- HISTORY: --
142 -- 09/14/00 Hemant Gosain Created --
143 ----------------------------------------------------------------------------
144
145 PROCEDURE getDeptAccounts (
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148 p_commit IN VARCHAR2 := FND_API.G_FALSE,
149 p_validation_level IN NUMBER
150 := FND_API.G_VALID_LEVEL_FULL,
151 p_department_id IN NUMBER,
152 p_from_organization_id IN NUMBER,
153 p_to_organization_id IN NUMBER,
154 x_scrap_account OUT NOCOPY NUMBER,
155 x_est_absorption_account OUT NOCOPY NUMBER,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2) ;
159
160
161
162
163 ----------------------------------------------------------------------------
164 -- PROCEDURE --
165 -- getOSPItem --
166 -- --
167 -- DESCRIPTION --
168 -- This API serevs as a client extension for returning OSP item id --
169 -- --
170 -- PURPOSE: --
171 -- Oracle Applications Rel 11i.3 --
172 -- --
173 -- --
174 -- HISTORY: --
175 -- 09/14/00 Hemant Gosain Created --
176 ----------------------------------------------------------------------------
177
178 PROCEDURE getOSPItem (
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181 p_commit IN VARCHAR2 := FND_API.G_FALSE,
182 p_validation_level IN NUMBER
183 := FND_API.G_VALID_LEVEL_FULL,
184 p_resource_id IN NUMBER,
185 p_from_organization_id IN NUMBER,
186 p_to_organization_id IN NUMBER,
187
188 x_item_id OUT NOCOPY NUMBER,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2);
192
193 ----------------------------------------------------------------------------
194 -- PROCEDURE --
195 -- getDefaultActivity --
196 -- --
197 -- DESCRIPTION --
198 -- This API serevs as a client extension for returning --
199 -- default activity for a given subelement --
200 -- --
201 -- PURPOSE: --
202 -- Oracle Applications Rel 11i.3 --
203 -- --
204 -- --
205 -- HISTORY: --
206 -- 09/14/00 Hemant Gosain Created --
207 ----------------------------------------------------------------------------
208
209 PROCEDURE getDefaultActivity (
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212 p_commit IN VARCHAR2 := FND_API.G_FALSE,
213 p_validation_level IN NUMBER
214 := FND_API.G_VALID_LEVEL_FULL,
215
216 p_resource_id IN NUMBER,
217 p_from_organization_id IN NUMBER,
218 p_to_organization_id IN NUMBER,
219 x_activity_id OUT NOCOPY NUMBER,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2) ;
223
224 ----------------------------------------------------------------------------
225 -- PROCEDURE --
226 -- getExpenditureType --
227 -- --
228 -- DESCRIPTION --
229 -- This API serevs as a client extension for returning --
230 -- Expenditure Type for a given subelement --
231 -- --
232 -- PURPOSE: --
233 -- Oracle Applications Rel 11i.3 --
234 -- --
235 -- --
236 -- HISTORY: --
237 -- 09/14/00 Hemant Gosain Created --
238 ----------------------------------------------------------------------------
239
240 PROCEDURE getExpenditureType (
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243 p_commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_validation_level IN NUMBER
245 := FND_API.G_VALID_LEVEL_FULL,
246
247 p_resource_id IN NUMBER,
248 p_from_organization_id IN NUMBER,
249 p_to_organization_id IN NUMBER,
250 x_expenditure_type OUT NOCOPY VARCHAR2,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2) ;
254
255 ----------------------------------------------------------------------------
256 -- PROCEDURE --
257 -- getSubelementAcct --
258 -- --
259 -- DESCRIPTION --
260 -- This API serevs as a client extension for returning --
261 -- Abosorption and rate variance account for a given subelement --
262 -- --
263 -- PURPOSE: --
264 -- Oracle Applications Rel 11i.3 --
268 -- 09/14/00 Hemant Gosain Created --
265 -- --
266 -- --
267 -- HISTORY: --
269 ----------------------------------------------------------------------------
270
271 PROCEDURE getSubelementAcct (
272 p_api_version IN NUMBER,
273 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274 p_commit IN VARCHAR2 := FND_API.G_FALSE,
275 p_validation_level IN NUMBER
276 := FND_API.G_VALID_LEVEL_FULL,
277
278 p_resource_id IN NUMBER,
279 p_from_organization_id IN NUMBER,
280 p_to_organization_id IN NUMBER,
281 x_absorption_account OUT NOCOPY NUMBER,
282 x_rate_variance_account OUT NOCOPY NUMBER,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2) ;
286
287 ----------------------------------------------------------------------------
288 -- PROCEDURE --
289 -- summarizeSubElements --
290 -- --
291 -- DESCRIPTION --
292 -- This API summarizes subelements into a single Item Basis type default--
293 -- subelements per cost element for all non-matching subelements between--
294 -- two organizations --
295 -- --
296 -- PURPOSE: --
297 -- Oracle Applications Rel 11i.3 --
298 -- --
299 -- --
300 -- HISTORY: --
301 -- 09/14/00 Anirban Dey Created --
302 ----------------------------------------------------------------------------
303
304 PROCEDURE summarizeSubElements (
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307 p_commit IN VARCHAR2 := FND_API.G_FALSE,
308 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309
310 x_return_status OUT NOCOPY VARCHAR2,
311 x_msg_count OUT NOCOPY NUMBER,
312 x_msg_data OUT NOCOPY VARCHAR2,
313
314 p_subelement_tbl IN nonmatching_tbl_type,
315 p_subelement_count IN NUMBER,
316 p_department_tbl IN nonmatching_tbl_type,
317 p_department_count IN NUMBER,
318 p_activity_tbl IN nonmatching_tbl_type,
319 p_activity_count IN NUMBER,
320 p_summary_option IN NUMBER,
321 p_material_subelement IN NUMBER := null,
322 p_moh_subelement IN NUMBER := null,
323 p_resource_subelement IN NUMBER := null,
324 p_overhead_subelement IN NUMBER := null,
325 p_osp_subelement IN NUMBER := null,
326 p_from_organization_id IN NUMBER ,
327 p_to_organization_id IN NUMBER ,
328 p_from_cost_type_id IN NUMBER ,
329 p_to_cost_type_id IN NUMBER ,
330 p_group_id IN NUMBER ,
331 p_conversion_type IN VARCHAR2 );
332
333
334 END;
|
|
|