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.ENG_DEFAULT_REVISED_ITEM dependencies on FND_API

Line 173: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR THEN

169: BEGIN
170:
171: -- In the future call Flex APIs for defaults
172:
173: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR THEN
174: g_revised_item_rec.attribute_category := NULL;
175: END IF;
176:
177: IF g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 177: IF g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR THEN

173: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR THEN
174: g_revised_item_rec.attribute_category := NULL;
175: END IF;
176:
177: IF g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR THEN
178: g_revised_item_rec.attribute2 := NULL;
179: END IF;
180:
181: IF g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 181: IF g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR THEN

177: IF g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR THEN
178: g_revised_item_rec.attribute2 := NULL;
179: END IF;
180:
181: IF g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR THEN
182: g_revised_item_rec.attribute3 := NULL;
183: END IF;
184:
185: IF g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 185: IF g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR THEN

181: IF g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR THEN
182: g_revised_item_rec.attribute3 := NULL;
183: END IF;
184:
185: IF g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR THEN
186: g_revised_item_rec.attribute4 := NULL;
187: END IF;
188:
189: IF g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 189: IF g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR THEN

185: IF g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR THEN
186: g_revised_item_rec.attribute4 := NULL;
187: END IF;
188:
189: IF g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR THEN
190: g_revised_item_rec.attribute5 := NULL;
191: END IF;
192:
193: IF g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 193: IF g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR THEN

189: IF g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR THEN
190: g_revised_item_rec.attribute5 := NULL;
191: END IF;
192:
193: IF g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR THEN
194: g_revised_item_rec.attribute7 := NULL;
195: END IF;
196:
197: IF g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 197: IF g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR THEN

193: IF g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR THEN
194: g_revised_item_rec.attribute7 := NULL;
195: END IF;
196:
197: IF g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR THEN
198: g_revised_item_rec.attribute8 := NULL;
199: END IF;
200:
201: IF g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 201: IF g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR THEN

197: IF g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR THEN
198: g_revised_item_rec.attribute8 := NULL;
199: END IF;
200:
201: IF g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR THEN
202: g_revised_item_rec.attribute9 := NULL;
203: END IF;
204:
205: IF g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 205: IF g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR THEN

201: IF g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR THEN
202: g_revised_item_rec.attribute9 := NULL;
203: END IF;
204:
205: IF g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR THEN
206: g_revised_item_rec.attribute11 := NULL;
207: END IF;
208:
209: IF g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 209: IF g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR THEN

205: IF g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR THEN
206: g_revised_item_rec.attribute11 := NULL;
207: END IF;
208:
209: IF g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR THEN
210: g_revised_item_rec.attribute12 := NULL;
211: END IF;
212:
213: IF g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 213: IF g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR THEN

209: IF g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR THEN
210: g_revised_item_rec.attribute12 := NULL;
211: END IF;
212:
213: IF g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR THEN
214: g_revised_item_rec.attribute13 := NULL;
215: END IF;
216:
217: IF g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 217: IF g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR THEN

213: IF g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR THEN
214: g_revised_item_rec.attribute13 := NULL;
215: END IF;
216:
217: IF g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR THEN
218: g_revised_item_rec.attribute14 := NULL;
219: END IF;
220:
221: IF g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 221: IF g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR THEN

217: IF g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR THEN
218: g_revised_item_rec.attribute14 := NULL;
219: END IF;
220:
221: IF g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR THEN
222: g_revised_item_rec.attribute15 := NULL;
223: END IF;
224:
225: IF g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 225: IF g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR THEN

221: IF g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR THEN
222: g_revised_item_rec.attribute15 := NULL;
223: END IF;
224:
225: IF g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR THEN
226: g_revised_item_rec.attribute1 := NULL;
227: END IF;
228:
229: IF g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 229: IF g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR THEN

225: IF g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR THEN
226: g_revised_item_rec.attribute1 := NULL;
227: END IF;
228:
229: IF g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR THEN
230: g_revised_item_rec.attribute6 := NULL;
231: END IF;
232:
233: IF g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 233: IF g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR THEN

229: IF g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR THEN
230: g_revised_item_rec.attribute6 := NULL;
231: END IF;
232:
233: IF g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR THEN
234: g_revised_item_rec.attribute10 := NULL;
235: END IF;
236:
237: END Get_Flex_Revised_Item;

Line 246: AND g_revised_item_rec.lot_number <> FND_API.G_MISS_CHAR ) OR

242: RETURN NUMBER
243: IS
244: BEGIN
245: IF ( g_revised_item_rec.lot_number IS NOT NULL
246: AND g_revised_item_rec.lot_number <> FND_API.G_MISS_CHAR ) OR
247: ( g_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
248: AND g_rev_item_unexp_rec.from_wip_entity_id <> FND_API.G_MISS_NUM)
249: THEN
250: RETURN 1 ; -- Return 1 : Yes

Line 248: AND g_rev_item_unexp_rec.from_wip_entity_id <> FND_API.G_MISS_NUM)

244: BEGIN
245: IF ( g_revised_item_rec.lot_number IS NOT NULL
246: AND g_revised_item_rec.lot_number <> FND_API.G_MISS_CHAR ) OR
247: ( g_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
248: AND g_rev_item_unexp_rec.from_wip_entity_id <> FND_API.G_MISS_NUM)
249: THEN
250: RETURN 1 ; -- Return 1 : Yes
251: ELSE
252: RETURN 2 ; -- Return 2 : No

Line 294: RETURN FND_API.G_MISS_NUM;

290: WHEN NO_DATA_FOUND THEN
291: RETURN NULL;
292:
293: WHEN OTHERS THEN
294: RETURN FND_API.G_MISS_NUM;
295:
296:
297: END Get_Current_LifeCycle_Id;
298:

Line 327: RETURN FND_API.G_MISS_NUM;

323: WHEN NO_DATA_FOUND THEN
324: RETURN NULL;
325:
326: WHEN OTHERS THEN
327: RETURN FND_API.G_MISS_NUM;
328:
329:
330: END Get_Current_Structure_Rev_Id;
331:

Line 431: OR g_revised_item_rec.earliest_effective_date = FND_API.G_MISS_DATE

427:
428: END IF;
429:
430: IF g_revised_item_rec.earliest_effective_date IS NULL
431: OR g_revised_item_rec.earliest_effective_date = FND_API.G_MISS_DATE
432: THEN
433: -- commenting the defaulting of earliest_effective_date to sysdate for bug 3575375
434: g_revised_item_rec.earliest_effective_date := NULL;--SYSDATE;
435:

Line 502: g_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM

498: -- by MK on 02/15/2001. BO doest not need this logic
499: -- but ECO Form is still using it. Hence not comment out.
500: ***********************************************************************/
501: IF g_rev_item_unexp_rec.bill_sequence_id IS NULL OR
502: g_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM
503: THEN
504: g_rev_item_unexp_rec.bill_sequence_id := Get_Bill_Sequence;
505:
506: IF Bom_Globals.Get_Debug = 'Y' THEN

Line 534: g_rev_item_unexp_rec.use_up = FND_API.G_MISS_NUM

530: END IF;
531: END IF;
532:
533: IF g_rev_item_unexp_rec.use_up IS NULL OR
534: g_rev_item_unexp_rec.use_up = FND_API.G_MISS_NUM
535: THEN
536: g_rev_item_unexp_rec.use_up := 2;
537: END IF;
538:

Line 540: g_revised_item_rec.use_up_item_name = FND_API.G_MISS_CHAR

536: g_rev_item_unexp_rec.use_up := 2;
537: END IF;
538:
539: IF g_rev_item_unexp_rec.use_up_item_id IS NULL OR
540: g_revised_item_rec.use_up_item_name = FND_API.G_MISS_CHAR
541: THEN
542: g_rev_item_unexp_rec.use_up := 2;
543: END IF;
544:

Line 545: IF g_rev_item_unexp_rec.requestor_id = FND_API.G_MISS_NUM

541: THEN
542: g_rev_item_unexp_rec.use_up := 2;
543: END IF;
544:
545: IF g_rev_item_unexp_rec.requestor_id = FND_API.G_MISS_NUM
546: THEN
547: g_rev_item_unexp_rec.requestor_id := NULL;
548: END IF;
549:

Line 552: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR

548: END IF;
549:
550: g_rev_item_unexp_rec.revised_item_sequence_id := Get_Revised_Item_Sequence;
551:
552: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR
553: OR g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR
554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR
555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR

Line 553: OR g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR

549:
550: g_rev_item_unexp_rec.revised_item_sequence_id := Get_Revised_Item_Sequence;
551:
552: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR
553: OR g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR
554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR
555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR

Line 554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR

550: g_rev_item_unexp_rec.revised_item_sequence_id := Get_Revised_Item_Sequence;
551:
552: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR
553: OR g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR
554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR
555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR

Line 555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR

551:
552: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR
553: OR g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR
554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR
555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR

Line 556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR

552: IF g_revised_item_rec.attribute_category = FND_API.G_MISS_CHAR
553: OR g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR
554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR
555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR

Line 557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR

553: OR g_revised_item_rec.attribute2 = FND_API.G_MISS_CHAR
554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR
555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR

Line 558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR

554: OR g_revised_item_rec.attribute3 = FND_API.G_MISS_CHAR
555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR

Line 559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR

555: OR g_revised_item_rec.attribute4 = FND_API.G_MISS_CHAR
556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR

Line 560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR

556: OR g_revised_item_rec.attribute5 = FND_API.G_MISS_CHAR
557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR

Line 561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR

557: OR g_revised_item_rec.attribute7 = FND_API.G_MISS_CHAR
558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR
565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR

Line 562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR

558: OR g_revised_item_rec.attribute8 = FND_API.G_MISS_CHAR
559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR
565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR
566: OR g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR

Line 563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR

559: OR g_revised_item_rec.attribute9 = FND_API.G_MISS_CHAR
560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR
565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR
566: OR g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR
567: OR g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR

Line 564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR

560: OR g_revised_item_rec.attribute11 = FND_API.G_MISS_CHAR
561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR
565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR
566: OR g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR
567: OR g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR
568: THEN

Line 565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR

561: OR g_revised_item_rec.attribute12 = FND_API.G_MISS_CHAR
562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR
565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR
566: OR g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR
567: OR g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR
568: THEN
569:

Line 566: OR g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR

562: OR g_revised_item_rec.attribute13 = FND_API.G_MISS_CHAR
563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR
565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR
566: OR g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR
567: OR g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR
568: THEN
569:
570: Get_Flex_Revised_Item;

Line 567: OR g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR

563: OR g_revised_item_rec.attribute14 = FND_API.G_MISS_CHAR
564: OR g_revised_item_rec.attribute15 = FND_API.G_MISS_CHAR
565: OR g_revised_item_rec.attribute1 = FND_API.G_MISS_CHAR
566: OR g_revised_item_rec.attribute6 = FND_API.G_MISS_CHAR
567: OR g_revised_item_rec.attribute10 = FND_API.G_MISS_CHAR
568: THEN
569:
570: Get_Flex_Revised_Item;
571:

Line 585: g_rev_item_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM

581: -- by MK on 02/15/2001. BO doest not need this logic
582: -- but ECO Form is still using it. Hence not comment out.
583: ***********************************************************************/
584: IF g_rev_item_unexp_rec.routing_sequence_id IS NULL OR
585: g_rev_item_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM
586: THEN
587: g_rev_item_unexp_rec.routing_sequence_id := Get_Routing_Sequence;
588:
589: IF Bom_Globals.Get_Debug = 'Y' THEN

Line 606: g_rev_item_unexp_rec.cfm_routing_flag = FND_API.G_MISS_NUM

602:
603: END IF;
604:
605: IF g_rev_item_unexp_rec.cfm_routing_flag IS NULL OR
606: g_rev_item_unexp_rec.cfm_routing_flag = FND_API.G_MISS_NUM
607: THEN
608: g_rev_item_unexp_rec.cfm_routing_flag := Bom_Default_Rtg_Header.Get_Cfm_Routing_Flag ;
609: END IF ; -- to Suppport Flow Routing, This should be exposed column.
610:

Line 613: g_revised_item_rec.ctp_flag = FND_API.G_MISS_NUM THEN

609: END IF ; -- to Suppport Flow Routing, This should be exposed column.
610:
611:
612: IF g_revised_item_rec.ctp_flag IS NULL OR
613: g_revised_item_rec.ctp_flag = FND_API.G_MISS_NUM THEN
614: g_revised_item_rec.ctp_flag
615: := Bom_Default_Rtg_Header.Get_Ctp_Flag ;
616: END IF;
617:

Line 620: g_revised_item_rec.mixed_model_map_flag = FND_API.G_MISS_NUM THEN

616: END IF;
617:
618: /* Comment out. For Future Release
619: IF g_revised_item_rec.mixed_model_map_flag IS NULL OR
620: g_revised_item_rec.mixed_model_map_flag = FND_API.G_MISS_NUM THEN
621: g_revised_item_rec.mixed_model_map_flag
622: := Bom_Default_Rtg_Header.Get_Get_Mixed_Model_Map_Flag ;
623: END IF;
624: */

Line 629: g_revised_item_rec.eco_for_production = FND_API.G_MISS_NUM

625: -- Added by MK on 09/01/2000
626:
627: -- Eco For Production Added by MK on 10/06/2000
628: IF g_revised_item_rec.eco_for_production IS NULL OR
629: g_revised_item_rec.eco_for_production = FND_API.G_MISS_NUM
630: THEN
631: g_revised_item_rec.eco_for_production := Get_Eco_For_Production ;
632: END IF;
633: --11.5.10 Defaulting current_item_revision_id and current_lifecycle_state_id

Line 636: g_rev_item_unexp_rec.current_item_revision_id = FND_API.G_MISS_NUM

632: END IF;
633: --11.5.10 Defaulting current_item_revision_id and current_lifecycle_state_id
634:
635: IF g_rev_item_unexp_rec.current_item_revision_id IS NULL OR
636: g_rev_item_unexp_rec.current_item_revision_id = FND_API.G_MISS_NUM
637: THEN
638: g_rev_item_unexp_rec.current_item_revision_id :=
639: BOM_REVISIONS.get_item_revision_id_fn(
640: 'ALL',

Line 647: g_rev_item_unexp_rec.current_lifecycle_state_id = FND_API.G_MISS_NUM

643: g_rev_item_unexp_rec.revised_item_id, SYSDATE);
644: END IF;
645:
646: IF g_rev_item_unexp_rec.current_lifecycle_state_id IS NULL OR
647: g_rev_item_unexp_rec.current_lifecycle_state_id = FND_API.G_MISS_NUM
648: THEN
649: /* l_revision :=
650: BOM_REVISIONS.GET_ITEM_REVISION_FN (
651: 'ALL',

Line 684: g_revised_item_rec.from_item_revision := FND_API.G_MISS_CHAR;

680: -- for ERP case or when the new revision is not specified.
681: IF (Eng_Globals.Get_PLM_Or_ERP_Change(g_revised_item_rec.eco_name,
682: g_rev_item_unexp_rec.organization_id) <> 'PLM')
683: THEN
684: g_revised_item_rec.from_item_revision := FND_API.G_MISS_CHAR;
685:
686: -- Commented for bug fix 4517503
687: -- g_rev_item_unexp_rec.from_item_revision_id := FND_API.G_MISS_NUM;
688: g_rev_item_unexp_rec.new_revision_reason_code := FND_API.G_MISS_CHAR;

Line 687: -- g_rev_item_unexp_rec.from_item_revision_id := FND_API.G_MISS_NUM;

683: THEN
684: g_revised_item_rec.from_item_revision := FND_API.G_MISS_CHAR;
685:
686: -- Commented for bug fix 4517503
687: -- g_rev_item_unexp_rec.from_item_revision_id := FND_API.G_MISS_NUM;
688: g_rev_item_unexp_rec.new_revision_reason_code := FND_API.G_MISS_CHAR;
689: ELSE
690: g_revised_item_rec.from_item_revision
691: := Get_Current_Item_Revision

Line 688: g_rev_item_unexp_rec.new_revision_reason_code := FND_API.G_MISS_CHAR;

684: g_revised_item_rec.from_item_revision := FND_API.G_MISS_CHAR;
685:
686: -- Commented for bug fix 4517503
687: -- g_rev_item_unexp_rec.from_item_revision_id := FND_API.G_MISS_NUM;
688: g_rev_item_unexp_rec.new_revision_reason_code := FND_API.G_MISS_CHAR;
689: ELSE
690: g_revised_item_rec.from_item_revision
691: := Get_Current_Item_Revision
692: ( p_revised_item_id => g_rev_item_unexp_rec.revised_item_id

Line 704: g_rev_item_unexp_rec.from_item_revision_id = FND_API.G_MISS_NUM

700: -- In ENGURITB.pls this value is being used to populate eng_revised_items.
701: -- current_item_revision_id in procedure insert_row.
702: -- Moved from ENGURITB.pls => Eng_revised_item_util.Insert_Row
703: IF g_rev_item_unexp_rec.from_item_revision_id IS NULL OR
704: g_rev_item_unexp_rec.from_item_revision_id = FND_API.G_MISS_NUM
705: THEN
706: g_rev_item_unexp_rec.from_item_revision_id := g_rev_item_unexp_rec.current_item_revision_id;
707: END IF;
708: -- End of bug fix 4517503

Line 713: g_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR)

709:
710: -- The new revision related fields are being nulled out if the new
711: -- revision is not provided.
712: IF (g_revised_item_rec.new_revised_item_revision IS NULL OR
713: g_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR)
714: THEN
715: g_rev_item_unexp_rec.new_revision_reason_code := FND_API.G_MISS_CHAR;
716: END IF;
717:

Line 715: g_rev_item_unexp_rec.new_revision_reason_code := FND_API.G_MISS_CHAR;

711: -- revision is not provided.
712: IF (g_revised_item_rec.new_revised_item_revision IS NULL OR
713: g_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR)
714: THEN
715: g_rev_item_unexp_rec.new_revision_reason_code := FND_API.G_MISS_CHAR;
716: END IF;
717:
718: -- Validation for the scheduled_date
719:

Line 722: x_return_status := FND_API.G_RET_STS_SUCCESS;

718: -- Validation for the scheduled_date
719:
720: x_revised_item_rec := g_revised_item_rec;
721: x_rev_item_unexp_rec := g_rev_item_unexp_rec;
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723:
724: END Attribute_Defaulting;
725:
726: /******************************************************************************

Line 1519: l_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR OR

1515: --
1516: IF l_revised_item_rec.eco_for_production = 1 THEN
1517:
1518: IF l_revised_item_rec.new_revised_item_revision IS NOT NULL OR
1519: l_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR OR
1520: l_revised_item_rec.updated_revised_item_revision IS NOT NULL OR
1521: l_revised_item_rec.updated_revised_item_revision <> FND_API.G_MISS_CHAR OR
1522: l_revised_item_rec.new_routing_revision IS NOT NULL OR
1523: l_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR OR

Line 1521: l_revised_item_rec.updated_revised_item_revision <> FND_API.G_MISS_CHAR OR

1517:
1518: IF l_revised_item_rec.new_revised_item_revision IS NOT NULL OR
1519: l_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR OR
1520: l_revised_item_rec.updated_revised_item_revision IS NOT NULL OR
1521: l_revised_item_rec.updated_revised_item_revision <> FND_API.G_MISS_CHAR OR
1522: l_revised_item_rec.new_routing_revision IS NOT NULL OR
1523: l_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR OR
1524: l_revised_item_rec.updated_routing_revision IS NOT NULL OR
1525: l_revised_item_rec.updated_routing_revision <> FND_API.G_MISS_CHAR

Line 1523: l_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR OR

1519: l_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR OR
1520: l_revised_item_rec.updated_revised_item_revision IS NOT NULL OR
1521: l_revised_item_rec.updated_revised_item_revision <> FND_API.G_MISS_CHAR OR
1522: l_revised_item_rec.new_routing_revision IS NOT NULL OR
1523: l_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR OR
1524: l_revised_item_rec.updated_routing_revision IS NOT NULL OR
1525: l_revised_item_rec.updated_routing_revision <> FND_API.G_MISS_CHAR
1526: THEN
1527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1525: l_revised_item_rec.updated_routing_revision <> FND_API.G_MISS_CHAR

1521: l_revised_item_rec.updated_revised_item_revision <> FND_API.G_MISS_CHAR OR
1522: l_revised_item_rec.new_routing_revision IS NOT NULL OR
1523: l_revised_item_rec.new_routing_revision <> FND_API.G_MISS_CHAR OR
1524: l_revised_item_rec.updated_routing_revision IS NOT NULL OR
1525: l_revised_item_rec.updated_routing_revision <> FND_API.G_MISS_CHAR
1526: THEN
1527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1528: THEN
1529: Error_Handler.Add_Error_Token

Line 1637: FND_API.G_MISS_CHAR

1633: END LOOP;
1634:
1635: IF l_rev_already_exists = 0 AND
1636: l_revised_item_rec.updated_revised_item_revision <>
1637: FND_API.G_MISS_CHAR
1638: THEN
1639: --
1640: -- Insert new revision information into
1641: -- MTL_ITEM_REVISIONS

Line 1664: FND_API.G_MISS_CHAR OR

1660: ELSIF ( ( l_rev_already_exists = 0
1661: AND
1662: (
1663: l_revised_item_rec.updated_revised_item_revision =
1664: FND_API.G_MISS_CHAR OR
1665: l_revised_item_rec.updated_revised_item_revision
1666: IS NULL )
1667: )
1668: OR -- Added by MK on 02/13/2001 for Bug 1641488

Line 1713: l_revised_item_rec.alternate_bom_code <> fnd_api.G_MISS_CHAR)

1709: ( p_revised_item_id => l_rev_item_unexp_rec.revised_item_id
1710: , p_change_notice => l_revised_item_rec.eco_name
1711: , p_organization_id => l_rev_item_unexp_rec.organization_id
1712: ) AND
1713: l_revised_item_rec.alternate_bom_code <> fnd_api.G_MISS_CHAR)
1714: ) AND
1715: NOT Check_Alternate_Already_Exists
1716: ( p_revised_item_id => l_rev_item_unexp_rec.revised_item_id
1717: , p_alternate_bom_designator => l_revised_item_rec.alternate_bom_code

Line 1792: l_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM)

1788: -- Comment out by MK on 02/15/2001
1789: -- Because this code is duplicate the logic in Attribute Defaulting and
1790: -- ENG_Val_To_Id.Revised_Item_VID
1791: IF (l_rev_item_unexp_rec.bill_sequence_id IS NULL OR
1792: l_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM)
1793: AND l_revised_item_rec.alternate_bom_code IS NULL -- Added by MK on 10/31/00
1794: THEN
1795: --
1796: -- If the user is simply trying to add a revised item that

Line 1853: l_rev_item_unexp_rec.use_up_item_id <> FND_API.G_MISS_NUM AND -- Added by MK on 10/31/00

1849: Error_Handler.Write_Debug('Use Up Plan Name : ' ||l_revised_item_rec.use_up_plan_name );
1850: END IF;
1851:
1852: IF l_rev_item_unexp_rec.use_up_item_id IS NOT NULL AND
1853: l_rev_item_unexp_rec.use_up_item_id <> FND_API.G_MISS_NUM AND -- Added by MK on 10/31/00
1854: l_revised_item_rec.use_up_plan_name IS NOT NULL
1855: THEN
1856: G_OLD_SCHED_DATE := l_revised_item_rec.start_effective_date; -- 6657209
1857: l_revised_item_rec.start_effective_date :=

Line 2013: IF l_revised_item_rec.updated_revised_item_revision = FND_API.G_MISS_CHAR

2009:
2010: END IF; /* Status Type updation Ends */
2011:
2012:
2013: IF l_revised_item_rec.updated_revised_item_revision = FND_API.G_MISS_CHAR
2014: THEN
2015: l_revised_item_rec.updated_revised_item_revision := NULL;
2016: END IF;
2017:

Line 2018: IF l_revised_item_rec.new_effective_date = FND_API.G_MISS_DATE

2014: THEN
2015: l_revised_item_rec.updated_revised_item_revision := NULL;
2016: END IF;
2017:
2018: IF l_revised_item_rec.new_effective_date = FND_API.G_MISS_DATE
2019: THEN
2020: l_revised_item_rec.new_effective_date := NULL;
2021: END IF;
2022:

Line 2023: IF l_rev_item_unexp_rec.use_up_item_id = FND_API.G_MISS_NUM

2019: THEN
2020: l_revised_item_rec.new_effective_date := NULL;
2021: END IF;
2022:
2023: IF l_rev_item_unexp_rec.use_up_item_id = FND_API.G_MISS_NUM
2024: THEN
2025: l_rev_item_unexp_rec.use_up_item_id := NULL;
2026: END IF;
2027:

Line 2031: IF l_revised_item_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR

2027:
2028: -- Code section from From End Item Unit Number and
2029: -- New From End ITem Unit Number added by As on 07/06/99
2030:
2031: IF l_revised_item_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR
2032: THEN
2033: l_revised_item_rec.from_end_item_unit_number := NULL;
2034: END IF;
2035:

Line 2036: IF l_revised_item_rec.new_from_end_item_unit_number = FND_API.G_MISS_CHAR

2032: THEN
2033: l_revised_item_rec.from_end_item_unit_number := NULL;
2034: END IF;
2035:
2036: IF l_revised_item_rec.new_from_end_item_unit_number = FND_API.G_MISS_CHAR
2037: THEN
2038: l_revised_item_rec.new_from_end_item_unit_number := NULL;
2039: END IF;
2040:

Line 2042: IF l_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR

2038: l_revised_item_rec.new_from_end_item_unit_number := NULL;
2039: END IF;
2040:
2041: -- Added by MK on 11/15/00
2042: IF l_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR
2043: THEN
2044: l_revised_item_rec.new_revised_item_revision := NULL;
2045: END IF;
2046:

Line 2047: IF l_revised_item_rec.new_routing_revision = FND_API.G_MISS_CHAR

2043: THEN
2044: l_revised_item_rec.new_revised_item_revision := NULL;
2045: END IF;
2046:
2047: IF l_revised_item_rec.new_routing_revision = FND_API.G_MISS_CHAR
2048: THEN
2049: l_revised_item_rec.new_routing_revision := NULL;
2050: END IF;
2051:

Line 2052: IF l_revised_item_rec.updated_routing_revision = FND_API.G_MISS_CHAR

2048: THEN
2049: l_revised_item_rec.new_routing_revision := NULL;
2050: END IF;
2051:
2052: IF l_revised_item_rec.updated_routing_revision = FND_API.G_MISS_CHAR
2053: THEN
2054: l_revised_item_rec.updated_routing_revision := NULL;
2055: END IF;
2056:

Line 2146: FND_API.G_MISS_CHAR

2142: END LOOP;
2143:
2144: IF l_rtg_rev_already_exists = 0 AND
2145: l_revised_item_rec.updated_routing_revision <>
2146: FND_API.G_MISS_CHAR
2147: THEN
2148: --
2149: -- Insert updated routing revision information into
2150: -- MTL_RTG_ITEM_REVISIONS

Line 2172: = FND_API.G_MISS_CHAR OR

2168: END IF ;
2169:
2170: ELSIF ( l_rtg_rev_already_exists = 0 AND
2171: ( l_revised_item_rec.updated_routing_revision
2172: = FND_API.G_MISS_CHAR OR
2173: l_revised_item_rec.updated_routing_revision
2174: IS NULL )
2175: )
2176: OR -- Added by MK on 02/13/2001 for Bug 1641488

Line 2247: l_rev_item_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM )

2243: -- Because this code is duplicate the logic in Attribute Defaulting and
2244: -- ENG_Val_To_Id.Revised_Item_VID
2245:
2246: IF ( l_rev_item_unexp_rec.routing_sequence_id IS NULL OR
2247: l_rev_item_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM )
2248: AND l_revised_item_rec.alternate_bom_code IS NULL -- Added by MK on 10/31/00
2249: THEN
2250: --
2251: -- If the user is simply trying to add a revised item that

Line 2274: IF l_revised_item_rec.from_cumulative_quantity = FND_API.G_MISS_NUM

2270: -- Added by MK on 09/01/2000
2271: ***********************************************************************/
2272: -- Added by MK for ECO Routing
2273:
2274: IF l_revised_item_rec.from_cumulative_quantity = FND_API.G_MISS_NUM
2275: THEN
2276: l_revised_item_rec.from_cumulative_quantity := NULL ;
2277: END IF ;
2278:

Line 2279: IF l_revised_item_rec.lot_number = FND_API.G_MISS_CHAR

2275: THEN
2276: l_revised_item_rec.from_cumulative_quantity := NULL ;
2277: END IF ;
2278:
2279: IF l_revised_item_rec.lot_number = FND_API.G_MISS_CHAR
2280: THEN
2281: l_revised_item_rec.lot_number := NULL ;
2282: END IF ;
2283:

Line 2284: IF l_revised_item_rec.completion_subinventory = FND_API.G_MISS_CHAR

2280: THEN
2281: l_revised_item_rec.lot_number := NULL ;
2282: END IF ;
2283:
2284: IF l_revised_item_rec.completion_subinventory = FND_API.G_MISS_CHAR
2285: THEN
2286: l_revised_item_rec.completion_subinventory := NULL ;
2287: END IF ;
2288:

Line 2289: IF l_revised_item_rec.priority = FND_API.G_MISS_NUM

2285: THEN
2286: l_revised_item_rec.completion_subinventory := NULL ;
2287: END IF ;
2288:
2289: IF l_revised_item_rec.priority = FND_API.G_MISS_NUM
2290: THEN
2291: l_revised_item_rec.priority := NULL ;
2292: END IF ;
2293:

Line 2294: IF l_revised_item_rec.routing_comment = FND_API.G_MISS_CHAR

2290: THEN
2291: l_revised_item_rec.priority := NULL ;
2292: END IF ;
2293:
2294: IF l_revised_item_rec.routing_comment = FND_API.G_MISS_CHAR
2295: THEN
2296: l_revised_item_rec.routing_comment := NULL ;
2297: END IF ;
2298:

Line 2299: IF l_rev_item_unexp_rec.from_wip_entity_id = FND_API.G_MISS_NUM

2295: THEN
2296: l_revised_item_rec.routing_comment := NULL ;
2297: END IF ;
2298:
2299: IF l_rev_item_unexp_rec.from_wip_entity_id = FND_API.G_MISS_NUM
2300: THEN
2301: l_rev_item_unexp_rec.from_wip_entity_id := NULL ;
2302: END IF ;
2303:

Line 2305: IF l_rev_item_unexp_rec.to_wip_entity_id = FND_API.G_MISS_NUM

2301: l_rev_item_unexp_rec.from_wip_entity_id := NULL ;
2302: END IF ;
2303:
2304:
2305: IF l_rev_item_unexp_rec.to_wip_entity_id = FND_API.G_MISS_NUM
2306: THEN
2307: l_rev_item_unexp_rec.to_wip_entity_id := NULL ;
2308: END IF ;
2309:

Line 2310: IF l_rev_item_unexp_rec.completion_locator_id = FND_API.G_MISS_NUM

2306: THEN
2307: l_rev_item_unexp_rec.to_wip_entity_id := NULL ;
2308: END IF ;
2309:
2310: IF l_rev_item_unexp_rec.completion_locator_id = FND_API.G_MISS_NUM
2311: THEN
2312: l_rev_item_unexp_rec.completion_locator_id := NULL ;
2313: END IF ;
2314:

Line 2386: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2382: -- Load out record
2383: x_revised_item_rec := l_revised_item_rec;
2384: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2385: x_Mesg_Token_Tbl := l_MEsg_Token_Tbl;
2386: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2387:
2388: END Entity_Defaulting;
2389:
2390: