[Home] [Help]
PACKAGE: APPS.INV_OPM_ITEM_MIGRATION
Source
1 PACKAGE INV_OPM_Item_Migration AS
2 /* $Header: INVGIMGS.pls 120.3 2006/10/26 21:11:18 jgogna noship $
3 +==========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +==========================================================================+
8 | FILE NAME |
9 | INVGIMGS.pls |
10 | |
11 | TYPE |
12 | Public |
13 | |
14 | PACKAGE NAME |
15 | INV_OPM_Item_Migration |
16 | |
17 | DESCRIPTION |
18 | This package contains the procedure used for item migration for OPM |
19 | convergence project. These procedure are meant for migration only. |
20 | |
21 | Contents |
22 | get_ODM_item |
23 | get_ODM_regulatory_item |
24 | migrate_opm_items |
25 | migrate_obsolete_columns |
26 | |
27 | HISTORY |
28 | Created - Jatinder Gogna - 3/22/05 |
29 | |
30 | |
31 +==========================================================================+
32 */
33
34 PROCEDURE get_ODM_item
35 ( p_migration_run_id IN NUMBER
36 , p_item_id IN NUMBER
37 , p_organization_id IN NUMBER
38 , p_mode IN VARCHAR2
39 , p_commit IN VARCHAR2
40 , x_inventory_item_id OUT NOCOPY NUMBER
41 , x_failure_count OUT NOCOPY NUMBER
42 , p_item_code IN VARCHAR2 DEFAULT NULL
43 , p_item_source IN VARCHAR2 DeFAULT 'GMI'
44 );
45
46 PROCEDURE get_ODM_regulatory_item
47 ( p_migration_run_id IN NUMBER
48 , p_item_code IN VARCHAR2
49 , p_organization_id IN NUMBER
50 , p_mode IN VARCHAR2
51 , p_commit IN VARCHAR2
52 , x_inventory_item_id OUT NOCOPY NUMBER
53 , x_failure_count OUT NOCOPY NUMBER);
54
55 PROCEDURE migrate_obsolete_columns
56 ( p_migration_run_id IN NUMBER
57 , p_obsolete_column_name IN VARCHAR2
58 , p_flexfield_column_name IN VARCHAR2
59 , p_commit IN VARCHAR2
60 , x_failure_count OUT NOCOPY NUMBER);
61
62 PROCEDURE validate_item_controls
63 ( p_migration_run_id IN NUMBER);
64
65 PROCEDURE validate_desc_flex_definition
66 ( p_migration_run_id IN NUMBER);
67
68 g_desc_flex_conflict PLS_INTEGER;
69 g_attribute_context PLS_INTEGER;
70 g_attribute1 PLS_INTEGER;
71 g_attribute2 PLS_INTEGER;
72 g_attribute3 PLS_INTEGER;
73 g_attribute4 PLS_INTEGER;
74 g_attribute5 PLS_INTEGER;
75 g_attribute6 PLS_INTEGER;
76 g_attribute7 PLS_INTEGER;
77 g_attribute8 PLS_INTEGER;
78 g_attribute9 PLS_INTEGER;
79 g_attribute10 PLS_INTEGER;
80 g_attribute11 PLS_INTEGER;
81 g_attribute12 PLS_INTEGER;
82 g_attribute13 PLS_INTEGER;
83 g_attribute14 PLS_INTEGER;
84 g_attribute15 PLS_INTEGER;
85 g_attribute16 PLS_INTEGER;
86 g_attribute17 PLS_INTEGER;
87 g_attribute18 PLS_INTEGER;
88 g_attribute19 PLS_INTEGER;
89 g_attribute20 PLS_INTEGER;
90 g_attribute21 PLS_INTEGER;
91 g_attribute22 PLS_INTEGER;
92 g_attribute23 PLS_INTEGER;
93 g_attribute24 PLS_INTEGER;
94 g_attribute25 PLS_INTEGER;
95 g_attribute26 PLS_INTEGER;
96 g_attribute27 PLS_INTEGER;
97 g_attribute28 PLS_INTEGER;
98 g_attribute29 PLS_INTEGER;
99 g_attribute30 PLS_INTEGER;
100
101 END INV_OPM_Item_Migration;