[Home] [Help]
PACKAGE: APPS.INV_GMI_MIGRATION
Source
1 PACKAGE INV_GMI_Migration AS
2 /* $Header: INVGMIMS.pls 120.2 2005/12/23 15:47:59 jgogna noship $
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 | |
35 +==========================================================================+
36 */
37
38 PROCEDURE migrate_inventory_types
39 ( p_migration_run_id IN NUMBER
40 , p_commit IN VARCHAR2
41 , x_failure_count OUT NOCOPY NUMBER);
42
43 PROCEDURE migrate_item_categories
44 ( p_migration_run_id IN NUMBER
45 , p_commit IN VARCHAR2
46 , p_start_rowid IN ROWID
47 , p_end_rowid IN ROWID
48 , x_failure_count OUT NOCOPY NUMBER);
49
50 PROCEDURE migrate_default_category_sets
51 ( p_migration_run_id IN NUMBER
52 , p_commit IN VARCHAR2
53 , x_failure_count OUT NOCOPY NUMBER);
54
55 PROCEDURE migrate_lot_status
56 ( p_migration_run_id IN NUMBER
57 , p_commit IN VARCHAR2
58 , x_failure_count OUT NOCOPY NUMBER);
59
60 PROCEDURE migrate_actions
61 ( p_migration_run_id IN NUMBER
62 , p_commit IN VARCHAR2
63 , x_failure_count OUT NOCOPY NUMBER);
64
65 PROCEDURE migrate_opm_grades
66 ( p_migration_run_id IN NUMBER
67 , p_commit IN VARCHAR2
68 , x_failure_count OUT NOCOPY NUMBER);
69
70 PROCEDURE migrate_odm_grades
71 ( p_migration_run_id IN NUMBER
72 , p_commit IN VARCHAR2
73 , x_failure_count OUT NOCOPY NUMBER);
74
75 PROCEDURE migrate_lot_conversions
76 ( p_migration_run_id IN NUMBER
77 , p_commit IN VARCHAR2
78 , p_start_rowid IN ROWID
79 , p_end_rowid IN ROWID
80 , x_failure_count OUT NOCOPY NUMBER);
81
82 PROCEDURE migrate_inventory_balances
83 ( p_migration_run_id IN NUMBER
84 , p_commit IN VARCHAR2
85 , x_failure_count OUT NOCOPY NUMBER);
86
87 FUNCTION ditem
88 ( p_organization_id IN NUMBER,
89 p_ditem_id IN NUMBER) RETURN VARCHAR2;
90
91 FUNCTION item
92 ( p_item_id IN NUMBER) RETURN VARCHAR2;
93
94 FUNCTION lot
95 ( p_lot_id IN NUMBER) RETURN VARCHAR2;
96
97 FUNCTION org
98 ( p_organization_id IN NUMBER) RETURN VARCHAR2;
99
100 END INV_GMI_Migration;