[Home] [Help]
PACKAGE: APPS.GMF_MIGRATION
Source
1 PACKAGE GMF_MIGRATION AS
2 /* $Header: gmfmigrs.pls 120.16 2006/10/05 12:50:39 anthiyag noship $ */
3
4 G_Migration_run_id NUMBER;
5 G_Table_name VARCHAR2(30);
6 G_Context VARCHAR2(255);
7 G_Mode VARCHAR2(5) DEFAULT 'ALL';
8
9 G_legal_entity VARCHAR2(30) DEFAULT 'LEGAL_ENTITY_ID';
10 G_Ledger_id VARCHAR2(30) DEFAULT 'LEDGER_ID';
11 G_organization VARCHAR2(30) DEFAULT 'ORGANIZATION_ID';
12 G_subinventory VARCHAR2(30) DEFAULT 'SUBINVENTORY_CODE';
13 G_inventory_item_id VARCHAR2(30) DEFAULT 'INVENTORY_ITEM_ID';
14 G_reason_id VARCHAR2(30) DEFAULT 'REASON_ID';
15 G_currency_code VARCHAR2(30) DEFAULT 'CURRENCY_CODE';
16 G_price_element_type_id VARCHAR2(30) DEFAULT 'AQUI_COST_ID';
17 G_resources VARCHAR2(30) DEFAULT 'RESOURCES';
18 G_order_type VARCHAR2(30) DEFAULT 'ORDER_TYPE';
19 G_cost_cmpntcls_id VARCHAR2(30) DEFAULT 'COST_CMPNTCLS_ID';
20 G_cost_analysis_code VARCHAR2(30) DEFAULT 'COST_ANALYSIS_CODE';
21 G_line_type VARCHAR2(30) DEFAULT 'LINE_TYPE';
22 G_ar_trx_type VARCHAR2(30) DEFAULT 'AR_TRX_TYPE_ID';
23 G_journal_line_type VARCHAR2(30) DEFAULT 'JOURNAL_LINE_TYPE';
24 G_gl_business_class_cat_id VARCHAR2(30) DEFAULT 'BC_CAT_CATEGORY_ID';
25 G_gl_product_line_cat_id VARCHAR2(30) DEFAULT 'PL_CAT_CATEGORY_ID';
26 G_gl_category_id VARCHAR2(30) DEFAULT 'GL_CAT_CATEGORY_ID';
27
28 G_vendor VARCHAR2(30) DEFAULT 'VENDOR_ID';
29 G_customer VARCHAR2(30) DEFAULT 'CUST_ID';
30 G_vendgl_class VARCHAR2(30) DEFAULT 'VENDGL_CLASS';
31 G_custgl_class VARCHAR2(30) DEFAULT 'CUSTGL_CLASS';
32 G_routing_id VARCHAR2(30) DEFAULT 'ROUTING_ID';
33
34 G_Constant VARCHAR2(30) DEFAULT 'C';
35 G_And VARCHAR2(30) DEFAULT 'A';
36 G_Or VARCHAR2(30) DEFAULT 'O';
37 G_Equal VARCHAR2(30) DEFAULT 'E';
38 G_Application_id NUMBER(38) := 555;
39
40 FUNCTION get_account_id
41 (
42 p_account_code IN VARCHAR2,
43 p_co_code IN VARCHAR2
44 )
45 RETURN VARCHAR2;
46
47 FUNCTION Get_Co_Code
48 (
49 p_whse_code IN VARCHAR2
50 )
51 RETURN VARCHAR2;
52
53 FUNCTION Get_Inventory_Item_Id
54 (
55 p_Item_id IN NUMBER
56 )
57 RETURN NUMBER;
58
59 FUNCTION Get_Legal_entity_Id
60 (
61 p_co_code IN VARCHAR2,
62 p_source_type IN VARCHAR2
63 )
64 RETURN NUMBER;
65
66 FUNCTION Get_Legal_entity_Id
67 (
68 p_organization_id IN NUMBER
69 )
70 RETURN NUMBER;
71
72 FUNCTION Get_Legal_entity_Id
73 (
74 p_whse_code IN VARCHAR2
75 )
76 RETURN NUMBER;
77
78 FUNCTION Get_Item_Number
79 (
80 p_inventory_item_id IN NUMBER
81 )
82 RETURN VARCHAR2;
83
84 FUNCTION Get_Customer_no
85 (
86 p_cust_id IN NUMBER
87 )
88 RETURN VARCHAR2;
89
90 FUNCTION Get_Vendor_no
91 (
92 p_vendor_id IN NUMBER
93 )
94 RETURN VARCHAR2;
95
96 FUNCTION Get_Reason_id
97 (
98 p_reason_code IN VARCHAR2
99 )
100 RETURN NUMBER;
101
102 PROCEDURE Get_Routing_no
103 (
104 p_routing_id IN NUMBER,
105 x_routing_no OUT NOCOPY VARCHAR2,
106 x_routing_vers OUT NOCOPY NUMBER
107 );
108
109 FUNCTION Get_price_element_Type_id
110 (
111 p_aqui_cost_id IN NUMBER
112 )
113 RETURN NUMBER;
114
115 FUNCTION Get_Cost_cmpntcls_code
116 (
117 p_cost_cmpntcls_id IN NUMBER
118 )
119 RETURN VARCHAR2;
120
121 FUNCTION Get_Order_type_code
122 (
123 p_Order_type IN NUMBER,
124 p_source_type IN NUMBER
125 )
126 RETURN VARCHAR2;
127
128 FUNCTION Get_Line_type_code
129 (
130 p_Line_type IN NUMBER
131 )
132 RETURN VARCHAR2;
133
134 FUNCTION Get_Ar_trx_type_code
135 (
136 p_ar_trx_type_id IN NUMBER,
137 p_legal_entity_id IN NUMBER
138 )
139 RETURN VARCHAR2;
140
141 FUNCTION Get_Gl_business_class_cat
142 (
143 p_Gl_business_class_cat_id IN NUMBER
144 )
145 RETURN VARCHAR2;
146
147 FUNCTION Get_Gl_product_line_cat
148 (
149 p_Gl_product_line_cat_id IN NUMBER
150 )
151 RETURN VARCHAR2;
152
153 PROCEDURE Migrate_Fiscal_Policies_LE
154 (
155 P_migration_run_id IN NUMBER,
156 P_commit IN VARCHAR2,
157 x_failure_count OUT NOCOPY NUMBER
158 );
159
160 PROCEDURE Migrate_Fiscal_Policies_Others
161 (
162 P_migration_run_id IN NUMBER,
163 P_commit IN VARCHAR2,
164 X_failure_count OUT NOCOPY NUMBER
165 );
166
167 PROCEDURE Migrate_Cost_Methods
168 (
169 P_migration_run_id IN NUMBER,
170 P_commit IN VARCHAR2,
171 X_failure_count OUT NOCOPY NUMBER
172 );
173
174 PROCEDURE Migrate_Lot_Cost_Methods
175 (
176 P_migration_run_id IN NUMBER,
177 P_commit IN VARCHAR2,
178 X_failure_count OUT NOCOPY NUMBER
179 );
180
181 PROCEDURE Migrate_Cost_Calendars
182 (
183 P_migration_run_id IN NUMBER,
184 P_commit IN VARCHAR2,
185 X_failure_count OUT NOCOPY NUMBER
186 );
187
188 PROCEDURE Migrate_Burden_Percentages
189 (
190 P_migration_run_id IN NUMBER,
191 P_commit IN VARCHAR2,
192 X_failure_count OUT NOCOPY NUMBER
193 );
194
195 PROCEDURE Migrate_Lot_Costs
196 (
197 P_migration_run_id IN NUMBER,
198 P_commit IN VARCHAR2,
199 X_failure_count OUT NOCOPY NUMBER
200 );
201
202 PROCEDURE Migrate_Lot_Costed_Items
203 (
204 P_migration_run_id IN NUMBER,
205 P_commit IN VARCHAR2,
206 X_failure_count OUT NOCOPY NUMBER
207 );
208
209 PROCEDURE Migrate_Lot_Cost_Adjustments
210 (
211 P_migration_run_id IN NUMBER,
212 P_commit IN VARCHAR2,
213 X_failure_count OUT NOCOPY NUMBER
214 );
215
216 PROCEDURE Migrate_Material_Lot_Cost_Txns
217 (
218 P_migration_run_id IN NUMBER,
219 P_commit IN VARCHAR2,
220 X_failure_count OUT NOCOPY NUMBER
221 );
222
223 PROCEDURE Migrate_Lot_Cost_Burdens
224 (
225 P_migration_run_id IN NUMBER,
226 P_commit IN VARCHAR2,
227 X_failure_count OUT NOCOPY NUMBER
228 );
229
230 PROCEDURE Migrate_Allocation_Basis
231 (
232 P_migration_run_id IN NUMBER,
233 P_commit IN VARCHAR2,
234 X_failure_count OUT NOCOPY NUMBER
235 );
236
237 PROCEDURE Migrate_Allocation_Expenses
238 (
239 P_migration_run_id IN NUMBER,
240 P_commit IN VARCHAR2,
241 X_failure_count OUT NOCOPY NUMBER
242 );
243
244 PROCEDURE Migrate_Account_Mappings
245 (
246 P_migration_run_id IN NUMBER,
247 P_commit IN VARCHAR2,
248 X_failure_count OUT NOCOPY NUMBER
249 );
250
251 PROCEDURE Migrate_Acquisition_Codes
252 (
253 P_migration_run_id IN NUMBER,
254 P_commit IN VARCHAR2,
255 X_failure_count OUT NOCOPY NUMBER
256 );
257
258 PROCEDURE Migrate_Period_Balances
259 (
260 P_migration_run_id IN NUMBER,
261 P_commit IN VARCHAR2,
262 X_failure_count OUT NOCOPY NUMBER
263 );
264
265 PROCEDURE Migrate_Allocation_Inputs
266 (
267 P_migration_run_id IN NUMBER,
268 P_commit IN VARCHAR2,
269 X_failure_count OUT NOCOPY NUMBER
270 );
271
272 PROCEDURE Migrate_Burden_Priorities
273 (
274 P_migration_run_id IN NUMBER,
275 P_commit IN VARCHAR2,
276 X_failure_count OUT NOCOPY NUMBER
277 );
278
279 PROCEDURE Migrate_Component_Materials
280 (
281 P_migration_run_id IN NUMBER,
282 P_commit IN VARCHAR2,
283 X_failure_count OUT NOCOPY NUMBER
284 );
285
286 PROCEDURE Migrate_Allocation_Codes
287 (
288 P_migration_run_id IN NUMBER,
289 P_commit IN VARCHAR2,
290 X_failure_count OUT NOCOPY NUMBER
291 );
292
293 PROCEDURE Migrate_Event_Policies
294 (
295 P_migration_run_id IN NUMBER,
296 P_commit IN VARCHAR2,
297 X_failure_count OUT NOCOPY NUMBER
298 );
299
300 PROCEDURE Migrate_Cost_Warehouses
301 (
302 P_migration_run_id IN NUMBER,
303 P_commit IN VARCHAR2,
304 X_failure_count OUT NOCOPY NUMBER
305 );
306
307 PROCEDURE Migrate_Source_Warehouses
308 (
309 P_migration_run_id IN NUMBER,
310 P_commit IN VARCHAR2,
311 X_failure_count OUT NOCOPY NUMBER
312 );
313
314 PROCEDURE Migrate_Items
315 (
316 P_migration_run_id IN NUMBER,
317 P_commit IN VARCHAR2,
318 X_failure_count OUT NOCOPY NUMBER
319 );
320
321 PROCEDURE Migrate_ActualCost_control
322 (
323 P_migration_run_id IN NUMBER,
324 P_commit IN VARCHAR2,
325 X_failure_count OUT NOCOPY NUMBER
326 );
327
328 PROCEDURE Migrate_Rollup_control
329 (
330 P_migration_run_id IN NUMBER,
331 P_commit IN VARCHAR2,
332 X_failure_count OUT NOCOPY NUMBER
333 );
334
335 PROCEDURE Migrate_CostUpdate_control
336 (
337 P_migration_run_id IN NUMBER,
338 P_commit IN VARCHAR2,
339 X_failure_count OUT NOCOPY NUMBER
340 );
341
342 PROCEDURE Migrate_SubLedger_control
343 (
344 P_migration_run_id IN NUMBER,
345 P_commit IN VARCHAR2,
346 X_failure_count OUT NOCOPY NUMBER
347 );
348
349 PROCEDURE Log_Errors
350 (
351 p_log_level IN PLS_INTEGER DEFAULT 2,
352 p_from_rowid IN ROWID,
353 p_to_rowid IN ROWID
354 );
355
356 PROCEDURE Migrate_Vendor_id
357 (
358 P_migration_run_id IN NUMBER,
359 P_commit IN VARCHAR2,
360 X_failure_count OUT NOCOPY NUMBER
361 );
362
363 END GMF_MIGRATION;