[Home] [Help]
PACKAGE: APPS.INV_MATERIAL_STATUS_PUB
Source
1 PACKAGE INV_MATERIAL_STATUS_PUB as
2 /* $Header: INVMSPUS.pls 120.2 2007/12/25 02:24:03 musinha ship $ */
3
4 -- Following constants are valid update method values which are same as
5 -- the look up code definition for update_method in the table MTL_MATERIAL
6 -- _STATUS_HISTORY
7
8 g_update_method_receive CONSTANT NUMBER := 1 ;
9 g_update_method_manual CONSTANT NUMBER := 2 ;
10 g_update_method_auto CONSTANT NUMBER := 3 ;
11 g_update_method_quality CONSTANT NUMBER := 4 ;
12
13 ------------------------------------------------------------------------
14 -- Record type for status update record ------------------
15 ------------------------------------------------------------------------
16
17 TYPE mtl_status_update_rec_type is RECORD
18 (
19 ORGANIZATION_ID NUMBER := fnd_api.g_miss_num
20 ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num
21 ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22 ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23 ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24 ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25 ,STATUS_ID NUMBER := fnd_api.g_miss_num
26 ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27 ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28 ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29 ,CREATION_DATE DATE := fnd_api.g_miss_date
30 ,CREATED_BY NUMBER := fnd_api.g_miss_num
31 ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32 ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33 ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34 ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35 ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36 ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37 ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38 ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39 ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40 ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41 ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42 ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43 ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44 ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45 ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46 ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47 ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48 ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49 ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50 ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51 ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52 ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53 ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54 ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55 -- NSRIVAST, INVCONV , Start
56 ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
57 ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
58 ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
59 -- NSRIVAST, INVCONV , End
60 );
61
62 -- Bug# 1695432, added INITIAL_STATUS_FLAG and FROM_MOBILE_APPS_FLAG col
63 ------------------------------------------------------------------------------
64 -- Procedure
65 -- update_status
66 --
67 -- Description
68 -- update the corresponding entity (zone, locator, lot, serial) status and
69 -- record the update info in the update history
70 --
71 -- Input Paramters
72 -- p_api_version_number API version number (current version is 1.0)
73 --
74 -- p_init_msg_lst Whether initialize the error message list or
75 -- not.
76 -- Should be fnd_api.g_false or fnd_api.g_true
77 -- p_commit whether or not to commit the changes to Database
78 --
79 -- p_object_type this parameter is for performance purpose
80 -- must be specified for the proper function
81 -- 'Z' update zone (subinventory)
82 -- 'L' update locator
83 -- 'O' update lot
84 -- 'S' update serial
85
86 -- p_status_rec Contains info to be used to update entity status
87 --
88 -- Output Parameters
89 -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
90 -- = fnd_api.g_ret_sts_exc_error, if an expected
91 -- error occurred
92 -- = fnd_api.g_ret_sts_unexp_error, if
93 -- an unexpected error occurred
94 --
95 -- x_msg_count Number of error message in the error message
96 -- list
97 --
98 -- x_msg_data If the number of error message in the error
99 -- message list is one, the error message
100 -- is in this output parameter
101 --
102 ------------------------------------------------------------------------------
103
104 PROCEDURE update_status
105 ( p_api_version_number IN NUMBER
106 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
107 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
108 , x_return_status OUT NOCOPY VARCHAR2
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 , p_object_type IN VARCHAR2
112 , p_status_rec IN INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type
113 );
114
115 END INV_MATERIAL_STATUS_PUB;