1 PACKAGE BODY CSD_GROUP_SERIAL_NUMBER_PVT as
2 /* $Header: csdvsrnb.pls 120.1.12000000.2 2007/02/20 22:43:27 takwong ship $*/
3 --
4 -- Package name : CSD_GROUP_SERIAL_NUMBER_PVT
5 -- Purpose : This package contains the private APIs for creating,
6 -- updating, deleting, locking serial numbers.
7 -- Access is restricted to Oracle Depot Rapair
8 -- Internal Development.
9 -- History :
10 -- Version Date Name Description
11 -- 115.0 05/08/02 askumar Created.
12 --
13 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_GROUP_SERIAL_NUMBER_PVT';
14 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvsrnb.pls';
15 --
16 G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17 G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
18 G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
19 G_PROGRAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
20 G_PROG_APPL_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
21 g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
22 --
23 --
24 -- *******************************************************
25 -- API Name: Create_Serial_Number
26 -- Type : Private
27 -- Pre-Req : None
28 -- Parameters:
29 -- IN
30 -- p_api_version_number IN NUMBER Required
31 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
32 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
34
35 -- x_MRO_Serial_Number_Rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type
36 -- x_return_status OUT NOCOPY VARCHAR2
37 -- x_msg_count OUT NOCOPY NUMBER
38 -- x_msg_data OUT NOCOPY VARCHAR2
39 --
40 -- Version : Current version 1.0
41 -- Initial Version 1.0
42 --
43 -- Notes: This API will create a Serial Numbers entered via the Serial
44 -- Number Capture Screen. They will be validated against IB or
45 -- Service Inventory if the user opted for them.
46 --
47 PROCEDURE Create_Serial_Number(
48 P_Api_Version_Number IN NUMBER,
49 P_Init_Msg_List IN VARCHAR2,
50 P_Commit IN VARCHAR2,
51 p_validation_level IN NUMBER,
52 x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
53 X_Return_Status OUT NOCOPY VARCHAR2,
54 X_Msg_Count OUT NOCOPY NUMBER,
55 X_Msg_Data OUT NOCOPY VARCHAR2
56 )
57 IS
58 --
59 --
60 BEGIN
61 --
62
63 NULL;
64
65 End Create_Serial_Number;
66
67 PROCEDURE Update_Serial_Number(
68 P_Api_Version_Number IN NUMBER,
69 P_Init_Msg_List IN VARCHAR2,
70 P_Commit IN VARCHAR2,
71 p_validation_level IN NUMBER,
72 x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
73 X_Return_Status OUT NOCOPY VARCHAR2,
74 X_Msg_Count OUT NOCOPY NUMBER,
75 X_Msg_Data OUT NOCOPY VARCHAR2
76 )
77 IS
78 --
79
80 --
81 BEGIN
82
83 NULL;
84 --
85 End Update_Serial_Number;
86
87
88 PROCEDURE Delete_Serial_Number(
89 P_Api_Version_Number IN NUMBER,
90 P_Init_Msg_List IN VARCHAR2,
91 P_Commit IN VARCHAR2,
92 p_validation_level IN NUMBER,
93 p_MRO_Serial_Number_ID IN NUMBER,
94 X_Return_Status OUT NOCOPY VARCHAR2,
95 x_Msg_Count OUT NOCOPY NUMBER,
96 x_Msg_Data OUT NOCOPY VARCHAR2
97 )
98 iS
99 --
100 --
101 BEGIN
102 --
103 -- Standard Start of API savepoint
104 null;
105 End Delete_Serial_Number;
106
107
108
109 PROCEDURE Lock_Serial_Number(
110 P_Api_Version_Number IN NUMBER,
111 P_Init_Msg_List IN VARCHAR2,
112 P_Commit IN VARCHAR2,
113 p_validation_level IN NUMBER,
114 x_MRO_Serial_Number_rec IN CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
115 X_Return_Status OUT NOCOPY VARCHAR2,
116 X_Msg_Count OUT NOCOPY NUMBER,
117 X_Msg_Data OUT NOCOPY VARCHAR2
118 )
119 IS
120 --
121
122 BEGIN
123 --
124 -- Standard Start of API savepoint
125 NULL;
126
127 End Lock_Serial_Number;
128
129
130 /*------------------------------------------------------------*/
131 /* This function verifies that the item is a valid inventory */
132 /* item and is marked as 'Trackable' */
133 /*------------------------------------------------------------*/
134
135 FUNCTION Is_ib_trackable
136 (
137 p_inv_item_id IN NUMBER,
138 p_stack_err_msg IN BOOLEAN
139 )
140 RETURN BOOLEAN IS
141
142
143 BEGIN
144 return null;
145
146 END Is_ib_trackable;
147
148
149 /*------------------------------------------------------------*/
150 /* This function verifies that the item is a serialized */
151 /* item or not */
152 /*------------------------------------------------------------*/
153
154 FUNCTION Is_serialized
155 (
156 p_inv_item_id IN NUMBER,
157 p_item_number IN VARCHAR2,
158 p_stack_err_msg IN BOOLEAN
159 )
160 RETURN BOOLEAN IS
161
162
163 BEGIN
164 return null;
165
166 END Is_serialized;
167
168
169 /*------------------------------------------------------------*/
170 -- Procedure: Validate_Serial_Number (for 11.5.7.1 development)
171 -- Purpose: Validate serial numbers entered via the
172 -- serial number capture screen
173 /*------------------------------------------------------------*/
174
175 PROCEDURE Validate_Serial_Number
176 (
177 p_ib_flag IN VARCHAR2,
178 p_inv_item_id IN NUMBER,
179 p_serial_number IN VARCHAR2,
180 x_return_value OUT NOCOPY VARCHAR2
181 ) IS
182
183 BEGIN
184 -- Validate against installed base if the user opted for it
185 null;
186 END Validate_Serial_Number;
187
188
189 /*------------------------------------------------------------*/
190 -- Function: Is_Duplicate_Serial_Num (11.5.7.1 development)
191 -- Purpose: Checks if serial numbers entered are duplicates
192 /*------------------------------------------------------------*/
193
194 PROCEDURE Is_Duplicate_Serial_Num
195 (p_Api_Version_Number IN NUMBER,
196 P_Init_Msg_List IN VARCHAR2,
197 P_Commit IN VARCHAR2,
198 p_validation_level IN NUMBER,
199 p_repair_group_id IN NUMBER,
200 p_serial_number IN VARCHAR2,
201 x_return_value OUT NOCOPY BOOLEAN,
202 X_Return_Status OUT NOCOPY VARCHAR2,
203 X_Msg_Count OUT NOCOPY NUMBER,
204 X_Msg_Data OUT NOCOPY VARCHAR2
205 )
206 IS
207
208 BEGIN
209 --
210 null;
211
212 END Is_Duplicate_Serial_Num;
213
214
215 End CSD_GROUP_SERIAL_NUMBER_PVT;