[Home] [Help]
PACKAGE: APPS.INV_OPM_LOT_MIGRATION
Source
1 PACKAGE INV_OPM_Lot_Migration AS
2 /* $Header: INVLTMGS.pls 120.1 2006/10/25 16:11:34 jgogna noship $
3 +==========================================================================+
4 | Copyright (c) 1998 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +==========================================================================+
8 | FILE NAME |
9 | INVLTMDS.pls |
10 | |
11 | TYPE |
12 | |
13 | PACKAGE NAME |
14 | INV_OPM_Lot_Migration |
15 | |
16 | DESCRIPTION |
17 | This package contains the procedure used for lot migration in OPM |
18 | convergence project. These procedures are meant for migration only. |
19 | |
20 | Contents |
21 | get_ODM_lot |
22 | |
23 | HISTORY |
24 | Created - Jatinder Gogna - 3/22/05 |
25 | |
26 | |
27 +==========================================================================+
28 */
29
30 PROCEDURE get_ODM_lot
31 ( p_migration_run_id IN NUMBER
32 , p_inventory_item_id IN NUMBER
33 , p_lot_no IN VARCHAR2
34 , p_sublot_no IN VARCHAR2
35 , p_organization_id IN NUMBER
36 , p_locator_id IN NUMBER
37 , p_commit IN VARCHAR2
38 , x_lot_number OUT NOCOPY VARCHAR2
39 , x_parent_lot_number OUT NOCOPY VARCHAR2
40 , x_failure_count OUT NOCOPY NUMBER);
41
42 PROCEDURE get_ODM_lot
43 ( p_migration_run_id IN NUMBER
44 , p_item_id IN NUMBER
45 , p_lot_no IN VARCHAR2
46 , p_sublot_no IN VARCHAR2
47 , p_whse_code IN VARCHAR2
48 , p_orgn_code IN VARCHAR2
49 , p_location IN VARCHAR2
50 , p_get_parent_only IN NUMBER
51 , p_commit IN VARCHAR2
52 , x_lot_number OUT NOCOPY VARCHAR2
53 , x_parent_lot_number OUT NOCOPY VARCHAR2
54 , x_failure_count OUT NOCOPY NUMBER);
55
56 PROCEDURE get_ODM_lot
57 ( p_migration_run_id IN NUMBER
58 , p_item_id IN NUMBER
59 , p_lot_id IN NUMBER
60 , p_whse_code IN VARCHAR2
61 , p_orgn_code IN VARCHAR2
62 , p_location IN VARCHAR2
63 , p_commit IN VARCHAR2
64 , x_lot_number OUT NOCOPY VARCHAR2
65 , x_parent_lot_number OUT NOCOPY VARCHAR2
66 , x_failure_count OUT NOCOPY NUMBER
67 , p_organization_id IN NUMBER DEFAULT NULL);
68
69
70 END INV_OPM_Lot_Migration;