1: PACKAGE BODY OE_Lot_Serial_Util AS
2: /* $Header: OEXUSRLB.pls 120.0.12000000.2 2007/07/24 05:29:24 cpati ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXUSRLB.pls 120.0.12000000.2 2007/07/24 05:29:24 cpati ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Lot_Serial_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
32:
33: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute1,p_old_Lot_Serial_rec.attribute1)
34: THEN
35: l_index := l_index + 1;
36: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;
37: END IF;
38:
39: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute10,p_old_Lot_Serial_rec.attribute10)
40: THEN
38:
39: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute10,p_old_Lot_Serial_rec.attribute10)
40: THEN
41: l_index := l_index + 1;
42: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
43: END IF;
44:
45: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute11,p_old_Lot_Serial_rec.attribute11)
46: THEN
44:
45: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute11,p_old_Lot_Serial_rec.attribute11)
46: THEN
47: l_index := l_index + 1;
48: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
49: END IF;
50:
51: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute12,p_old_Lot_Serial_rec.attribute12)
52: THEN
50:
51: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute12,p_old_Lot_Serial_rec.attribute12)
52: THEN
53: l_index := l_index + 1;
54: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
55: END IF;
56:
57: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute13,p_old_Lot_Serial_rec.attribute13)
58: THEN
56:
57: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute13,p_old_Lot_Serial_rec.attribute13)
58: THEN
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
61: END IF;
62:
63: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute14,p_old_Lot_Serial_rec.attribute14)
64: THEN
62:
63: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute14,p_old_Lot_Serial_rec.attribute14)
64: THEN
65: l_index := l_index + 1;
66: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
67: END IF;
68:
69: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute15,p_old_Lot_Serial_rec.attribute15)
70: THEN
68:
69: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute15,p_old_Lot_Serial_rec.attribute15)
70: THEN
71: l_index := l_index + 1;
72: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
73: END IF;
74:
75: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute2,p_old_Lot_Serial_rec.attribute2)
76: THEN
74:
75: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute2,p_old_Lot_Serial_rec.attribute2)
76: THEN
77: l_index := l_index + 1;
78: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
79: END IF;
80:
81: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute3,p_old_Lot_Serial_rec.attribute3)
82: THEN
80:
81: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute3,p_old_Lot_Serial_rec.attribute3)
82: THEN
83: l_index := l_index + 1;
84: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
85: END IF;
86:
87: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute4,p_old_Lot_Serial_rec.attribute4)
88: THEN
86:
87: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute4,p_old_Lot_Serial_rec.attribute4)
88: THEN
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
91: END IF;
92:
93: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute5,p_old_Lot_Serial_rec.attribute5)
94: THEN
92:
93: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute5,p_old_Lot_Serial_rec.attribute5)
94: THEN
95: l_index := l_index + 1;
96: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
97: END IF;
98:
99: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute6,p_old_Lot_Serial_rec.attribute6)
100: THEN
98:
99: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute6,p_old_Lot_Serial_rec.attribute6)
100: THEN
101: l_index := l_index + 1;
102: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
103: END IF;
104:
105: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute7,p_old_Lot_Serial_rec.attribute7)
106: THEN
104:
105: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute7,p_old_Lot_Serial_rec.attribute7)
106: THEN
107: l_index := l_index + 1;
108: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
109: END IF;
110:
111: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute8,p_old_Lot_Serial_rec.attribute8)
112: THEN
110:
111: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute8,p_old_Lot_Serial_rec.attribute8)
112: THEN
113: l_index := l_index + 1;
114: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
115: END IF;
116:
117: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute9,p_old_Lot_Serial_rec.attribute9)
118: THEN
116:
117: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute9,p_old_Lot_Serial_rec.attribute9)
118: THEN
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
121: END IF;
122:
123: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.context,p_old_Lot_Serial_rec.context)
124: THEN
122:
123: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.context,p_old_Lot_Serial_rec.context)
124: THEN
125: l_index := l_index + 1;
126: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
127: END IF;
128:
129: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.created_by,p_old_Lot_Serial_rec.created_by)
130: THEN
128:
129: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.created_by,p_old_Lot_Serial_rec.created_by)
130: THEN
131: l_index := l_index + 1;
132: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
133: END IF;
134:
135: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.creation_date,p_old_Lot_Serial_rec.creation_date)
136: THEN
134:
135: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.creation_date,p_old_Lot_Serial_rec.creation_date)
136: THEN
137: l_index := l_index + 1;
138: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
139: END IF;
140:
141: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.from_serial_number,p_old_Lot_Serial_rec.from_serial_number)
142: THEN
140:
141: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.from_serial_number,p_old_Lot_Serial_rec.from_serial_number)
142: THEN
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
145: END IF;
146:
147: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_updated_by,p_old_Lot_Serial_rec.last_updated_by)
148: THEN
146:
147: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_updated_by,p_old_Lot_Serial_rec.last_updated_by)
148: THEN
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
151: END IF;
152:
153: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_date,p_old_Lot_Serial_rec.last_update_date)
154: THEN
152:
153: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_date,p_old_Lot_Serial_rec.last_update_date)
154: THEN
155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
157: END IF;
158:
159: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_login,p_old_Lot_Serial_rec.last_update_login)
160: THEN
158:
159: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_login,p_old_Lot_Serial_rec.last_update_login)
160: THEN
161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
163: END IF;
164:
165: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_id,p_old_Lot_Serial_rec.line_id)
166: THEN
164:
165: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_id,p_old_Lot_Serial_rec.line_id)
166: THEN
167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
169: END IF;
170:
171: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_set_id,p_old_Lot_Serial_rec.line_set_id)
172: THEN
170:
171: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_set_id,p_old_Lot_Serial_rec.line_set_id)
172: THEN
173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE_SET;
175: END IF;
176:
177: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_number,p_old_Lot_Serial_rec.lot_number)
178: THEN
176:
177: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_number,p_old_Lot_Serial_rec.lot_number)
178: THEN
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
181: END IF;
182:
183: /* IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' -- INVCONV
184: THEN
184: THEN
185: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.sublot_number,p_old_Lot_Serial_rec.sublot_number) -- OPM 2380194 -- INVCONV
186: THEN
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;
189: END IF;
190:
191: END IF; */
192:
192:
193: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_serial_id,p_old_Lot_Serial_rec.lot_serial_id)
194: THEN
195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;
197: END IF;
198:
199: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity,p_old_Lot_Serial_rec.quantity)
200: THEN
198:
199: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity,p_old_Lot_Serial_rec.quantity)
200: THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
203: END IF;
204:
205: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
206: THEN
206: THEN
207: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity2,p_old_Lot_Serial_rec.quantity2) -- OPM 2380194
208: THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;
211: END IF;
212: END IF;
213: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.to_serial_number,p_old_Lot_Serial_rec.to_serial_number)
214: THEN
212: END IF;
213: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.to_serial_number,p_old_Lot_Serial_rec.to_serial_number)
214: THEN
215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;
217: END IF;
218:
219: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
220: l_index := l_index + 1;
217: END IF;
218:
219: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;
222: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
225: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE1;
222: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
225: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
228: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
225: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
228: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
231: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
228: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
231: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
234: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
231: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
234: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
237: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
234: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
237: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
240: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
237: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
240: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
243: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
240: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
243: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
246: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
243: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
246: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
249: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
246: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
249: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
252: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
249: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
252: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
255: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
252: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
255: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
258: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
255: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
258: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
261: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
258: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
261: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
264: ELSIF p_attr_id = G_CONTEXT THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
261: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
264: ELSIF p_attr_id = G_CONTEXT THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
267: ELSIF p_attr_id = G_CREATED_BY THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
264: ELSIF p_attr_id = G_CONTEXT THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
267: ELSIF p_attr_id = G_CREATED_BY THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
270: ELSIF p_attr_id = G_CREATION_DATE THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
267: ELSIF p_attr_id = G_CREATED_BY THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
270: ELSIF p_attr_id = G_CREATION_DATE THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
273: ELSIF p_attr_id = G_FROM_SERIAL_NUMBER THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
270: ELSIF p_attr_id = G_CREATION_DATE THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
273: ELSIF p_attr_id = G_FROM_SERIAL_NUMBER THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
276: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
273: ELSIF p_attr_id = G_FROM_SERIAL_NUMBER THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
276: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
279: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
276: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
279: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
282: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
279: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
282: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
285: ELSIF p_attr_id = G_LINE THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
282: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
285: ELSIF p_attr_id = G_LINE THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
288: ELSIF p_attr_id = G_LOT_NUMBER THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
285: ELSIF p_attr_id = G_LINE THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
288: ELSIF p_attr_id = G_LOT_NUMBER THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
291: ELSIF p_attr_id = G_LOT_SERIAL THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
288: ELSIF p_attr_id = G_LOT_NUMBER THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
291: ELSIF p_attr_id = G_LOT_SERIAL THEN
292: l_index := l_index + 1;
293: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;
294: /*ELSIF p_attr_id = G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
291: ELSIF p_attr_id = G_LOT_SERIAL THEN
292: l_index := l_index + 1;
293: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_SERIAL;
294: /*ELSIF p_attr_id = G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV
295: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
296: THEN
297: l_index := l_index + 1;
294: /*ELSIF p_attr_id = G_SUBLOT_NUMBER THEN --OPM 2380194 INVCONV
295: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
296: THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;
299: END IF; */
300: ELSIF p_attr_id = G_QUANTITY THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
298: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_SUBLOT_NUMBER;
299: END IF; */
300: ELSIF p_attr_id = G_QUANTITY THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
303: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
304:
305: ELSIF p_attr_id = G_QUANTITY2 THEN --OPM 2380194
306: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
299: END IF; */
300: ELSIF p_attr_id = G_QUANTITY THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
303: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
304:
305: ELSIF p_attr_id = G_QUANTITY2 THEN --OPM 2380194
306: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
307: THEN
305: ELSIF p_attr_id = G_QUANTITY2 THEN --OPM 2380194
306: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;
310: END IF;
311: ELSIF p_attr_id = G_TO_SERIAL_NUMBER THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;
309: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY2;
310: END IF;
311: ELSIF p_attr_id = G_TO_SERIAL_NUMBER THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;
314: END IF;
315:
316: END Clear_Dependent_Attr;
317:
844: --added query_row for notification framework
845: --before update, query lot serial record, this record will be used
846: --to update global picture
847:
848: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
849: x_lot_serial_rec =>l_lot_serial_rec);
850: oe_debug_pub.add('before update, lot_serial_id= '|| l_lot_serial_rec.lot_serial_id, 1);
851: /* jolin end*/
852:
901: p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
902: x_index => l_index,
903: x_return_status => l_return_status);
904:
905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: -- notification framework end
1027: p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
1028: x_index => l_index,
1029: x_return_status => l_return_status);
1030:
1031: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.insert_row is: ' || l_return_status);
1032: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: -- notification framework end
1128:
1129:
1130: BEGIN
1131:
1132: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1133: IF (p_line_id <> FND_API.G_MISS_NUM)
1134: THEN
1135:
1136: OE_LINE_UTIL.Query_Row(p_line_id=>p_line_id,x_line_rec=>l_line_rec);
1148: FOR l_lots IN lot_serial
1149: LOOP
1150: --query lot serial record, then call notification framework to update global picture.
1151:
1152: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lots.lot_serial_id,
1153: x_lot_serial_rec =>l_old_lot_serial_rec);
1154:
1155: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_lots.lot_serial_id , 1);
1156:
1165: p_lot_serial_id => l_lots.lot_serial_id,
1166: x_index => l_index,
1167: x_return_status => l_return_status);
1168:
1169: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:
1182: END LOOP;
1197: FOR l_set IN line_set
1198: LOOP
1199: --query lot serial record, then call notification framework to update global picture.
1200:
1201: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_set.lot_serial_id,
1202: x_lot_serial_rec =>l_old_lot_serial_rec);
1203:
1204: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_set.lot_serial_id , 1);
1205:
1214: p_lot_serial_id => l_set.lot_serial_id,
1215: x_index => l_index,
1216: x_return_status => l_return_status);
1217:
1218: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: END LOOP;
1559: l_lot_serial_id NUMBER;
1560: l_lock_control NUMBER;
1561: BEGIN
1562:
1563: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.LOCK_ROW', 1);
1564:
1565: SAVEPOINT Lock_Row;
1566:
1567: l_lock_control := NULL;
1581: FOR UPDATE NOWAIT;
1582:
1583: oe_debug_pub.add('selected for update', 1);
1584:
1585: OE_Lot_serial_Util.Query_Row
1586: (p_lot_serial_id => l_lot_serial_id
1587: ,x_lot_serial_rec => p_x_lot_serial_rec );
1588:
1589:
1630: END IF;
1631:
1632: END IF;
1633:
1634: oe_debug_pub.add('Exiting OE_Lot_serial_UTIL.LOCK_ROW', 1);
1635:
1636: EXCEPTION
1637:
1638: WHEN NO_DATA_FOUND THEN
1692:
1693: l_lot_serial_id NUMBER;
1694: BEGIN
1695:
1696: oe_debug_pub.add('entering oe_lot_serial_util.lock_rows', 1);
1697:
1698: IF (p_lot_serial_id IS NOT NULL AND
1699: p_lot_serial_id <> FND_API.G_MISS_NUM) AND
1700: (p_line_id IS NOT NULL AND
1754: END;
1755:
1756: -- locked all
1757:
1758: OE_Lot_serial_Util.Query_Rows
1759: (p_lot_serial_id => p_lot_serial_id
1760: ,p_line_id => p_line_id
1761: ,x_lot_serial_tbl => x_lot_serial_tbl
1762: );
1762: );
1763:
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: oe_debug_pub.add('exiting oe_lot_serial_util.lock_rows', 1);
1767:
1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770:
1831: p_x_Lot_Serial_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1832:
1833: END Get_Ids;
1834:
1835: END OE_Lot_Serial_Util;