eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LOT_SERIAL_UTIL dependencies on OE_GLOBALS

Line 18: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

14: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
15: )
16: IS
17: l_index NUMBER := 0;
18: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
19: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
20: BEGIN
21:
22: -- SINCE THIS PROCEDURE IS DOING NOTHING, FOR PERFORMANCE, IT RETURNS IMMEDIATELY

Line 19: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

15: )
16: IS
17: l_index NUMBER := 0;
18: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
19: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
20: BEGIN
21:
22: -- SINCE THIS PROCEDURE IS DOING NOTHING, FOR PERFORMANCE, IT RETURNS IMMEDIATELY
23: RETURN;

Line 33: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute1,p_old_Lot_Serial_rec.attribute1)

29: -- every changed attribute clear its dependent fields.
30:
31: IF p_attr_id = FND_API.G_MISS_NUM THEN
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;

Line 39: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute10,p_old_Lot_Serial_rec.attribute10)

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
41: l_index := l_index + 1;
42: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE10;
43: END IF;

Line 45: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute11,p_old_Lot_Serial_rec.attribute11)

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
47: l_index := l_index + 1;
48: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE11;
49: END IF;

Line 51: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute12,p_old_Lot_Serial_rec.attribute12)

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
53: l_index := l_index + 1;
54: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE12;
55: END IF;

Line 57: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute13,p_old_Lot_Serial_rec.attribute13)

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
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE13;
61: END IF;

Line 63: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute14,p_old_Lot_Serial_rec.attribute14)

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
65: l_index := l_index + 1;
66: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE14;
67: END IF;

Line 69: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute15,p_old_Lot_Serial_rec.attribute15)

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
71: l_index := l_index + 1;
72: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE15;
73: END IF;

Line 75: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute2,p_old_Lot_Serial_rec.attribute2)

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
77: l_index := l_index + 1;
78: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE2;
79: END IF;

Line 81: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute3,p_old_Lot_Serial_rec.attribute3)

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
83: l_index := l_index + 1;
84: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE3;
85: END IF;

Line 87: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute4,p_old_Lot_Serial_rec.attribute4)

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
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE4;
91: END IF;

Line 93: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute5,p_old_Lot_Serial_rec.attribute5)

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
95: l_index := l_index + 1;
96: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE5;
97: END IF;

Line 99: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute6,p_old_Lot_Serial_rec.attribute6)

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
101: l_index := l_index + 1;
102: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE6;
103: END IF;

Line 105: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute7,p_old_Lot_Serial_rec.attribute7)

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
107: l_index := l_index + 1;
108: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE7;
109: END IF;

Line 111: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute8,p_old_Lot_Serial_rec.attribute8)

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
113: l_index := l_index + 1;
114: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE8;
115: END IF;

Line 117: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute9,p_old_Lot_Serial_rec.attribute9)

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
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_ATTRIBUTE9;
121: END IF;

Line 123: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.context,p_old_Lot_Serial_rec.context)

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
125: l_index := l_index + 1;
126: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CONTEXT;
127: END IF;

Line 129: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.created_by,p_old_Lot_Serial_rec.created_by)

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
131: l_index := l_index + 1;
132: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATED_BY;
133: END IF;

Line 135: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.creation_date,p_old_Lot_Serial_rec.creation_date)

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
137: l_index := l_index + 1;
138: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_CREATION_DATE;
139: END IF;

Line 141: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.from_serial_number,p_old_Lot_Serial_rec.from_serial_number)

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
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_FROM_SERIAL_NUMBER;
145: END IF;

Line 147: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_updated_by,p_old_Lot_Serial_rec.last_updated_by)

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
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATED_BY;
151: END IF;

Line 153: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_date,p_old_Lot_Serial_rec.last_update_date)

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
155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_DATE;
157: END IF;

Line 159: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_login,p_old_Lot_Serial_rec.last_update_login)

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
161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LAST_UPDATE_LOGIN;
163: END IF;

Line 165: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_id,p_old_Lot_Serial_rec.line_id)

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
167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE;
169: END IF;

Line 171: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_set_id,p_old_Lot_Serial_rec.line_set_id)

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
173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LINE_SET;
175: END IF;

Line 177: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_number,p_old_Lot_Serial_rec.lot_number)

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
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_LOT_NUMBER;
181: END IF;

Line 185: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.sublot_number,p_old_Lot_Serial_rec.sublot_number) -- OPM 2380194 -- INVCONV

181: END IF;
182:
183: /* IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' -- INVCONV
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;

Line 193: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_serial_id,p_old_Lot_Serial_rec.lot_serial_id)

189: END IF;
190:
191: END IF; */
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;

Line 199: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity,p_old_Lot_Serial_rec.quantity)

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
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_QUANTITY;
203: END IF;

Line 207: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity2,p_old_Lot_Serial_rec.quantity2) -- OPM 2380194

203: END IF;
204:
205: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
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;

Line 213: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.to_serial_number,p_old_Lot_Serial_rec.to_serial_number)

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
215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := OE_LOT_SERIAL_UTIL.G_TO_SERIAL_NUMBER;
217: END IF;

Line 338: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute1,p_old_Lot_Serial_rec.attribute1)

334:
335: -- Please take out the comment when there is going to be a code associated
336: -- with following attributes
337: /*
338: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute1,p_old_Lot_Serial_rec.attribute1)
339: THEN
340: NULL;
341: END IF;
342:

Line 343: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute10,p_old_Lot_Serial_rec.attribute10)

339: THEN
340: NULL;
341: END IF;
342:
343: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute10,p_old_Lot_Serial_rec.attribute10)
344: THEN
345: NULL;
346: END IF;
347:

Line 348: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute11,p_old_Lot_Serial_rec.attribute11)

344: THEN
345: NULL;
346: END IF;
347:
348: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute11,p_old_Lot_Serial_rec.attribute11)
349: THEN
350: NULL;
351: END IF;
352:

Line 353: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute12,p_old_Lot_Serial_rec.attribute12)

349: THEN
350: NULL;
351: END IF;
352:
353: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute12,p_old_Lot_Serial_rec.attribute12)
354: THEN
355: NULL;
356: END IF;
357:

Line 358: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute13,p_old_Lot_Serial_rec.attribute13)

354: THEN
355: NULL;
356: END IF;
357:
358: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute13,p_old_Lot_Serial_rec.attribute13)
359: THEN
360: NULL;
361: END IF;
362:

Line 363: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute14,p_old_Lot_Serial_rec.attribute14)

359: THEN
360: NULL;
361: END IF;
362:
363: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute14,p_old_Lot_Serial_rec.attribute14)
364: THEN
365: NULL;
366: END IF;
367:

Line 368: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute15,p_old_Lot_Serial_rec.attribute15)

364: THEN
365: NULL;
366: END IF;
367:
368: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute15,p_old_Lot_Serial_rec.attribute15)
369: THEN
370: NULL;
371: END IF;
372:

Line 373: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute2,p_old_Lot_Serial_rec.attribute2)

369: THEN
370: NULL;
371: END IF;
372:
373: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute2,p_old_Lot_Serial_rec.attribute2)
374: THEN
375: NULL;
376: END IF;
377:

Line 378: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute3,p_old_Lot_Serial_rec.attribute3)

374: THEN
375: NULL;
376: END IF;
377:
378: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute3,p_old_Lot_Serial_rec.attribute3)
379: THEN
380: NULL;
381: END IF;
382:

Line 383: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute4,p_old_Lot_Serial_rec.attribute4)

379: THEN
380: NULL;
381: END IF;
382:
383: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute4,p_old_Lot_Serial_rec.attribute4)
384: THEN
385: NULL;
386: END IF;
387:

Line 388: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute5,p_old_Lot_Serial_rec.attribute5)

384: THEN
385: NULL;
386: END IF;
387:
388: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute5,p_old_Lot_Serial_rec.attribute5)
389: THEN
390: NULL;
391: END IF;
392:

Line 393: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute6,p_old_Lot_Serial_rec.attribute6)

389: THEN
390: NULL;
391: END IF;
392:
393: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute6,p_old_Lot_Serial_rec.attribute6)
394: THEN
395: NULL;
396: END IF;
397:

Line 398: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute7,p_old_Lot_Serial_rec.attribute7)

394: THEN
395: NULL;
396: END IF;
397:
398: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute7,p_old_Lot_Serial_rec.attribute7)
399: THEN
400: NULL;
401: END IF;
402:

Line 403: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute8,p_old_Lot_Serial_rec.attribute8)

399: THEN
400: NULL;
401: END IF;
402:
403: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute8,p_old_Lot_Serial_rec.attribute8)
404: THEN
405: NULL;
406: END IF;
407:

Line 408: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute9,p_old_Lot_Serial_rec.attribute9)

404: THEN
405: NULL;
406: END IF;
407:
408: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.attribute9,p_old_Lot_Serial_rec.attribute9)
409: THEN
410: NULL;
411: END IF;
412:

Line 413: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.context,p_old_Lot_Serial_rec.context)

409: THEN
410: NULL;
411: END IF;
412:
413: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.context,p_old_Lot_Serial_rec.context)
414: THEN
415: NULL;
416: END IF;
417:

Line 418: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.created_by,p_old_Lot_Serial_rec.created_by)

414: THEN
415: NULL;
416: END IF;
417:
418: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.created_by,p_old_Lot_Serial_rec.created_by)
419: THEN
420: NULL;
421: END IF;
422:

Line 423: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.creation_date,p_old_Lot_Serial_rec.creation_date)

419: THEN
420: NULL;
421: END IF;
422:
423: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.creation_date,p_old_Lot_Serial_rec.creation_date)
424: THEN
425: NULL;
426: END IF;
427:

Line 429: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_updated_by,p_old_Lot_Serial_rec.last_updated_by)

425: NULL;
426: END IF;
427:
428:
429: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_updated_by,p_old_Lot_Serial_rec.last_updated_by)
430: THEN
431: NULL;
432: END IF;
433:

Line 434: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_date,p_old_Lot_Serial_rec.last_update_date)

430: THEN
431: NULL;
432: END IF;
433:
434: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_date,p_old_Lot_Serial_rec.last_update_date)
435: THEN
436: NULL;
437: END IF;
438:

Line 439: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_login,p_old_Lot_Serial_rec.last_update_login)

435: THEN
436: NULL;
437: END IF;
438:
439: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.last_update_login,p_old_Lot_Serial_rec.last_update_login)
440: THEN
441: NULL;
442: END IF;
443:

Line 444: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_id,p_old_Lot_Serial_rec.line_id)

440: THEN
441: NULL;
442: END IF;
443:
444: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_id,p_old_Lot_Serial_rec.line_id)
445: THEN
446: NULL;
447: END IF;
448:

Line 449: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_set_id,p_old_Lot_Serial_rec.line_set_id)

445: THEN
446: NULL;
447: END IF;
448:
449: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.line_set_id,p_old_Lot_Serial_rec.line_set_id)
450: THEN
451: NULL;
452: END IF;
453:

Line 454: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_number,p_old_Lot_Serial_rec.lot_number)

450: THEN
451: NULL;
452: END IF;
453:
454: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_number,p_old_Lot_Serial_rec.lot_number)
455: THEN
456: NULL;
457: END IF;
458:

Line 459: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_serial_id,p_old_Lot_Serial_rec.lot_serial_id)

455: THEN
456: NULL;
457: END IF;
458:
459: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.lot_serial_id,p_old_Lot_Serial_rec.lot_serial_id)
460: THEN
461: NULL;
462: END IF;
463:

Line 464: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.from_serial_number,p_old_Lot_Serial_rec.from_serial_number)

460: THEN
461: NULL;
462: END IF;
463:
464: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.from_serial_number,p_old_Lot_Serial_rec.from_serial_number)
465: THEN
466: l_serial_validation_flag := 'Y';
467: END IF;
468:

Line 469: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity,p_old_Lot_Serial_rec.quantity)

465: THEN
466: l_serial_validation_flag := 'Y';
467: END IF;
468:
469: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.quantity,p_old_Lot_Serial_rec.quantity)
470: THEN
471: l_serial_validation_flag := 'Y';
472: END IF;
473:

Line 474: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.to_serial_number,p_old_Lot_Serial_rec.to_serial_number)

470: THEN
471: l_serial_validation_flag := 'Y';
472: END IF;
473:
474: IF NOT OE_GLOBALS.Equal(p_x_Lot_Serial_rec.to_serial_number,p_old_Lot_Serial_rec.to_serial_number)
475: THEN
476: l_serial_validation_flag := 'Y';
477: END IF;
478:

Line 1138: IF (l_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE)

1134: THEN
1135:
1136: OE_LINE_UTIL.Query_Row(p_line_id=>p_line_id,x_line_rec=>l_line_rec);
1137:
1138: IF (l_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE)
1139: THEN
1140: IF (l_line_rec.line_set_id IS NULL OR
1141: l_line_rec.line_set_id = FND_API.G_MISS_NUM)
1142: THEN

Line 1158: l_new_lot_serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1154:
1155: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_lots.lot_serial_id , 1);
1156:
1157: /* Set the operation on the record so that globals are updated as well */
1158: l_new_lot_serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1159: l_new_lot_serial_rec.lot_serial_id :=l_lots.lot_serial_id;
1160:
1161: OE_ORDER_UTIL.Update_Global_Picture(
1162: p_Upd_New_Rec_If_Exists => True,

Line 1207: l_new_lot_serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1203:
1204: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_set.lot_serial_id , 1);
1205:
1206: /* Set the operation on the record so that globals are updated as well */
1207: l_new_lot_serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1208: l_new_lot_serial_rec.lot_serial_id :=l_set.lot_serial_id;
1209:
1210: OE_ORDER_UTIL.Update_Global_Picture(
1211: p_Upd_New_Rec_If_Exists => True,

Line 1605: IF OE_GLOBALS.Equal(p_x_lot_serial_rec.lock_control,

1601:
1602: -- Row locked. If the whole record is passed, then
1603: -- Compare IN attributes to DB attributes.
1604:
1605: IF OE_GLOBALS.Equal(p_x_lot_serial_rec.lock_control,
1606: l_lock_control)
1607: THEN
1608:
1609: -- Set return status