[Home] [Help]
PACKAGE: APPS.INV_OPM_ITEM_MIGRATION
Source
1 PACKAGE INV_OPM_Item_Migration AUTHID CURRENT_USER AS
2 /* $Header: INVGIMGS.pls 120.5 2012/02/10 06:36:46 maychen ship $
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 | Fixed#10405668 Kedar Bavadekar 04/07/11 |
30 | Added procedure migrate_opm_items |
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_opm_items
56 ( p_organization_code IN VARCHAR2
57 , p_commit IN VARCHAR2) ;
58
59 PROCEDURE migrate_obsolete_columns
60 ( p_migration_run_id IN NUMBER
61 , p_obsolete_column_name IN VARCHAR2
62 , p_flexfield_column_name IN VARCHAR2
63 , p_commit IN VARCHAR2
64 , x_failure_count OUT NOCOPY NUMBER);
65
66 PROCEDURE validate_item_controls
67 ( p_migration_run_id IN NUMBER);
68
69 PROCEDURE validate_desc_flex_definition
70 ( p_migration_run_id IN NUMBER);
71
72 g_desc_flex_conflict PLS_INTEGER;
73 g_attribute_context PLS_INTEGER;
74 g_attribute1 PLS_INTEGER;
75 g_attribute2 PLS_INTEGER;
76 g_attribute3 PLS_INTEGER;
77 g_attribute4 PLS_INTEGER;
78 g_attribute5 PLS_INTEGER;
79 g_attribute6 PLS_INTEGER;
80 g_attribute7 PLS_INTEGER;
81 g_attribute8 PLS_INTEGER;
82 g_attribute9 PLS_INTEGER;
83 g_attribute10 PLS_INTEGER;
84 g_attribute11 PLS_INTEGER;
85 g_attribute12 PLS_INTEGER;
86 g_attribute13 PLS_INTEGER;
87 g_attribute14 PLS_INTEGER;
88 g_attribute15 PLS_INTEGER;
89 g_attribute16 PLS_INTEGER;
90 g_attribute17 PLS_INTEGER;
91 g_attribute18 PLS_INTEGER;
92 g_attribute19 PLS_INTEGER;
93 g_attribute20 PLS_INTEGER;
94 g_attribute21 PLS_INTEGER;
95 g_attribute22 PLS_INTEGER;
96 g_attribute23 PLS_INTEGER;
97 g_attribute24 PLS_INTEGER;
98 g_attribute25 PLS_INTEGER;
99 g_attribute26 PLS_INTEGER;
100 g_attribute27 PLS_INTEGER;
101 g_attribute28 PLS_INTEGER;
102 g_attribute29 PLS_INTEGER;
103 g_attribute30 PLS_INTEGER;
104
105 END INV_OPM_Item_Migration;