[Home] [Help]
PACKAGE: APPS.INV_GMI_MIGRATION
Source
1 PACKAGE INV_GMI_Migration AUTHID CURRENT_USER AS
2 /* $Header: INVGMIMS.pls 120.3 2011/11/16 16:00:26 srpuri ship $
3 +==========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +==========================================================================+
8 | FILE NAME |
9 | INVGMIMS.pls |
10 | |
11 | TYPE |
12 | |
13 | PACKAGE NAME |
14 | INV_GMI_Migration |
15 | |
16 | DESCRIPTION |
17 | This package contains the procedure used for inventory migration for |
18 | OPM convergence project. These procedure are meant for migration only.|
19 | |
20 | Contents |
21 | migrate_inventory_types |
22 | migrate_item_categories |
23 | migrate_default_category_sets |
24 | migrate_lot_status |
25 | migrate_actions |
26 | migrate_opm_grades |
27 | migrate_odm_grades |
28 | migrate_lot_conversions |
29 | migrate_inventory_balances |
30 | |
31 | HISTORY |
32 | Created - Jatinder Gogna - 3/22/05 |
33 | |
34 | Srinivasulu Puri- 11/04/2011 Bug#13335019 |
35 | for migrate_inventory_balances procedure added |
36 | 2 new parameters start rowid and end rowid to |
37 | utilise adparallel functionality to improve the |
38 | performance. |
39 +==========================================================================+
40 */
41
42 PROCEDURE migrate_inventory_types
43 ( p_migration_run_id IN NUMBER
44 , p_commit IN VARCHAR2
45 , x_failure_count OUT NOCOPY NUMBER);
46
47 PROCEDURE migrate_item_categories
48 ( p_migration_run_id IN NUMBER
49 , p_commit IN VARCHAR2
50 , p_start_rowid IN ROWID
51 , p_end_rowid IN ROWID
52 , x_failure_count OUT NOCOPY NUMBER);
53
54 PROCEDURE migrate_default_category_sets
55 ( p_migration_run_id IN NUMBER
56 , p_commit IN VARCHAR2
57 , x_failure_count OUT NOCOPY NUMBER);
58
59 PROCEDURE migrate_lot_status
60 ( p_migration_run_id IN NUMBER
61 , p_commit IN VARCHAR2
62 , x_failure_count OUT NOCOPY NUMBER);
63
64 PROCEDURE migrate_actions
65 ( p_migration_run_id IN NUMBER
66 , p_commit IN VARCHAR2
67 , x_failure_count OUT NOCOPY NUMBER);
68
69 PROCEDURE migrate_opm_grades
70 ( p_migration_run_id IN NUMBER
71 , p_commit IN VARCHAR2
72 , x_failure_count OUT NOCOPY NUMBER);
73
74 PROCEDURE migrate_odm_grades
75 ( p_migration_run_id IN NUMBER
76 , p_commit IN VARCHAR2
77 , x_failure_count OUT NOCOPY NUMBER);
78
79 PROCEDURE migrate_lot_conversions
80 ( p_migration_run_id IN NUMBER
81 , p_commit IN VARCHAR2
82 , p_start_rowid IN ROWID
83 , p_end_rowid IN ROWID
84 , x_failure_count OUT NOCOPY NUMBER);
85
86 PROCEDURE migrate_inventory_balances
87 ( p_migration_run_id IN NUMBER
88 ,p_start_rowid IN ROWID
89 ,p_end_rowid IN ROWID
90 , p_commit IN VARCHAR2
91 , x_failure_count OUT NOCOPY NUMBER);
92
93 FUNCTION ditem
94 ( p_organization_id IN NUMBER,
95 p_ditem_id IN NUMBER) RETURN VARCHAR2;
96
97 FUNCTION item
98 ( p_item_id IN NUMBER) RETURN VARCHAR2;
99
100 FUNCTION lot
101 ( p_lot_id IN NUMBER) RETURN VARCHAR2;
102
103 FUNCTION org
104 ( p_organization_id IN NUMBER) RETURN VARCHAR2;
105
106 END INV_GMI_Migration;