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 1808: l_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM)

1804: -- Comment out by MK on 02/15/2001
1805: -- Because this code is duplicate the logic in Attribute Defaulting and
1806: -- ENG_Val_To_Id.Revised_Item_VID
1807: IF (l_rev_item_unexp_rec.bill_sequence_id IS NULL OR
1808: l_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM)
1809: AND l_revised_item_rec.alternate_bom_code IS NULL -- Added by MK on 10/31/00
1810: THEN
1811: --
1812: -- If the user is simply trying to add a revised item that

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

1865: Error_Handler.Write_Debug('Use Up Plan Name : ' ||l_revised_item_rec.use_up_plan_name );
1866: END IF;
1867:
1868: IF l_rev_item_unexp_rec.use_up_item_id IS NOT NULL AND
1869: l_rev_item_unexp_rec.use_up_item_id <> FND_API.G_MISS_NUM AND -- Added by MK on 10/31/00
1870: l_revised_item_rec.use_up_plan_name IS NOT NULL
1871: THEN
1872: G_OLD_SCHED_DATE := l_revised_item_rec.start_effective_date; -- 6657209
1873: l_revised_item_rec.start_effective_date :=

Line 2029: IF l_revised_item_rec.updated_revised_item_revision = FND_API.G_MISS_CHAR

2025:
2026: END IF; /* Status Type updation Ends */
2027:
2028:
2029: IF l_revised_item_rec.updated_revised_item_revision = FND_API.G_MISS_CHAR
2030: THEN
2031: l_revised_item_rec.updated_revised_item_revision := NULL;
2032: END IF;
2033:

Line 2034: IF l_revised_item_rec.new_effective_date = FND_API.G_MISS_DATE

2030: THEN
2031: l_revised_item_rec.updated_revised_item_revision := NULL;
2032: END IF;
2033:
2034: IF l_revised_item_rec.new_effective_date = FND_API.G_MISS_DATE
2035: THEN
2036: l_revised_item_rec.new_effective_date := NULL;
2037: END IF;
2038:

Line 2039: IF l_rev_item_unexp_rec.use_up_item_id = FND_API.G_MISS_NUM

2035: THEN
2036: l_revised_item_rec.new_effective_date := NULL;
2037: END IF;
2038:
2039: IF l_rev_item_unexp_rec.use_up_item_id = FND_API.G_MISS_NUM
2040: THEN
2041: l_rev_item_unexp_rec.use_up_item_id := NULL;
2042: END IF;
2043:

Line 2047: IF l_revised_item_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR

2043:
2044: -- Code section from From End Item Unit Number and
2045: -- New From End ITem Unit Number added by As on 07/06/99
2046:
2047: IF l_revised_item_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR
2048: THEN
2049: l_revised_item_rec.from_end_item_unit_number := NULL;
2050: END IF;
2051:

Line 2052: IF l_revised_item_rec.new_from_end_item_unit_number = FND_API.G_MISS_CHAR

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

Line 2058: IF l_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR

2054: l_revised_item_rec.new_from_end_item_unit_number := NULL;
2055: END IF;
2056:
2057: -- Added by MK on 11/15/00
2058: IF l_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR
2059: THEN
2060: l_revised_item_rec.new_revised_item_revision := NULL;
2061: END IF;
2062:

Line 2063: IF l_revised_item_rec.new_routing_revision = FND_API.G_MISS_CHAR

2059: THEN
2060: l_revised_item_rec.new_revised_item_revision := NULL;
2061: END IF;
2062:
2063: IF l_revised_item_rec.new_routing_revision = FND_API.G_MISS_CHAR
2064: THEN
2065: l_revised_item_rec.new_routing_revision := NULL;
2066: END IF;
2067:

Line 2068: IF l_revised_item_rec.updated_routing_revision = FND_API.G_MISS_CHAR

2064: THEN
2065: l_revised_item_rec.new_routing_revision := NULL;
2066: END IF;
2067:
2068: IF l_revised_item_rec.updated_routing_revision = FND_API.G_MISS_CHAR
2069: THEN
2070: l_revised_item_rec.updated_routing_revision := NULL;
2071: END IF;
2072:

Line 2162: FND_API.G_MISS_CHAR

2158: END LOOP;
2159:
2160: IF l_rtg_rev_already_exists = 0 AND
2161: l_revised_item_rec.updated_routing_revision <>
2162: FND_API.G_MISS_CHAR
2163: THEN
2164: --
2165: -- Insert updated routing revision information into
2166: -- MTL_RTG_ITEM_REVISIONS

Line 2188: = FND_API.G_MISS_CHAR OR

2184: END IF ;
2185:
2186: ELSIF ( l_rtg_rev_already_exists = 0 AND
2187: ( l_revised_item_rec.updated_routing_revision
2188: = FND_API.G_MISS_CHAR OR
2189: l_revised_item_rec.updated_routing_revision
2190: IS NULL )
2191: )
2192: OR -- Added by MK on 02/13/2001 for Bug 1641488

Line 2263: l_rev_item_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM )

2259: -- Because this code is duplicate the logic in Attribute Defaulting and
2260: -- ENG_Val_To_Id.Revised_Item_VID
2261:
2262: IF ( l_rev_item_unexp_rec.routing_sequence_id IS NULL OR
2263: l_rev_item_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM )
2264: AND l_revised_item_rec.alternate_bom_code IS NULL -- Added by MK on 10/31/00
2265: THEN
2266: --
2267: -- If the user is simply trying to add a revised item that

Line 2290: IF l_revised_item_rec.from_cumulative_quantity = FND_API.G_MISS_NUM

2286: -- Added by MK on 09/01/2000
2287: ***********************************************************************/
2288: -- Added by MK for ECO Routing
2289:
2290: IF l_revised_item_rec.from_cumulative_quantity = FND_API.G_MISS_NUM
2291: THEN
2292: l_revised_item_rec.from_cumulative_quantity := NULL ;
2293: END IF ;
2294:

Line 2295: IF l_revised_item_rec.lot_number = FND_API.G_MISS_CHAR

2291: THEN
2292: l_revised_item_rec.from_cumulative_quantity := NULL ;
2293: END IF ;
2294:
2295: IF l_revised_item_rec.lot_number = FND_API.G_MISS_CHAR
2296: THEN
2297: l_revised_item_rec.lot_number := NULL ;
2298: END IF ;
2299:

Line 2300: IF l_revised_item_rec.completion_subinventory = FND_API.G_MISS_CHAR

2296: THEN
2297: l_revised_item_rec.lot_number := NULL ;
2298: END IF ;
2299:
2300: IF l_revised_item_rec.completion_subinventory = FND_API.G_MISS_CHAR
2301: THEN
2302: l_revised_item_rec.completion_subinventory := NULL ;
2303: END IF ;
2304:

Line 2305: IF l_revised_item_rec.priority = FND_API.G_MISS_NUM

2301: THEN
2302: l_revised_item_rec.completion_subinventory := NULL ;
2303: END IF ;
2304:
2305: IF l_revised_item_rec.priority = FND_API.G_MISS_NUM
2306: THEN
2307: l_revised_item_rec.priority := NULL ;
2308: END IF ;
2309:

Line 2310: IF l_revised_item_rec.routing_comment = FND_API.G_MISS_CHAR

2306: THEN
2307: l_revised_item_rec.priority := NULL ;
2308: END IF ;
2309:
2310: IF l_revised_item_rec.routing_comment = FND_API.G_MISS_CHAR
2311: THEN
2312: l_revised_item_rec.routing_comment := NULL ;
2313: END IF ;
2314:

Line 2315: IF l_rev_item_unexp_rec.from_wip_entity_id = FND_API.G_MISS_NUM

2311: THEN
2312: l_revised_item_rec.routing_comment := NULL ;
2313: END IF ;
2314:
2315: IF l_rev_item_unexp_rec.from_wip_entity_id = FND_API.G_MISS_NUM
2316: THEN
2317: l_rev_item_unexp_rec.from_wip_entity_id := NULL ;
2318: END IF ;
2319:

Line 2321: IF l_rev_item_unexp_rec.to_wip_entity_id = FND_API.G_MISS_NUM

2317: l_rev_item_unexp_rec.from_wip_entity_id := NULL ;
2318: END IF ;
2319:
2320:
2321: IF l_rev_item_unexp_rec.to_wip_entity_id = FND_API.G_MISS_NUM
2322: THEN
2323: l_rev_item_unexp_rec.to_wip_entity_id := NULL ;
2324: END IF ;
2325:

Line 2326: IF l_rev_item_unexp_rec.completion_locator_id = FND_API.G_MISS_NUM

2322: THEN
2323: l_rev_item_unexp_rec.to_wip_entity_id := NULL ;
2324: END IF ;
2325:
2326: IF l_rev_item_unexp_rec.completion_locator_id = FND_API.G_MISS_NUM
2327: THEN
2328: l_rev_item_unexp_rec.completion_locator_id := NULL ;
2329: END IF ;
2330:

Line 2402: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2398: -- Load out record
2399: x_revised_item_rec := l_revised_item_rec;
2400: x_rev_item_unexp_rec := l_rev_item_unexp_rec;
2401: x_Mesg_Token_Tbl := l_MEsg_Token_Tbl;
2402: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2403:
2404: END Entity_Defaulting;
2405:
2406: