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