DBA Data[Home] [Help]

APPS.ENG_DEFAULT_REV_COMPONENT dependencies on FND_API

Line 358: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

354: BEGIN
355:
356: -- In the future call Flex APIs for defaults
357:
358: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
359: g_rev_component_rec.attribute_category := NULL;
360: END IF;
361:
362: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 362: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

358: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
359: g_rev_component_rec.attribute_category := NULL;
360: END IF;
361:
362: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
363: g_rev_component_rec.attribute1 := NULL;
364: END IF;
365:
366: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 366: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

362: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
363: g_rev_component_rec.attribute1 := NULL;
364: END IF;
365:
366: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
367: g_rev_component_rec.attribute2 := NULL;
368: END IF;
369:
370: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 370: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

366: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
367: g_rev_component_rec.attribute2 := NULL;
368: END IF;
369:
370: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
371: g_rev_component_rec.attribute3 := NULL;
372: END IF;
373:
374: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 374: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

370: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
371: g_rev_component_rec.attribute3 := NULL;
372: END IF;
373:
374: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
375: g_rev_component_rec.attribute4 := NULL;
376: END IF;
377:
378: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 378: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

374: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
375: g_rev_component_rec.attribute4 := NULL;
376: END IF;
377:
378: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
379: g_rev_component_rec.attribute5 := NULL;
380: END IF;
381:
382: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 382: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

378: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
379: g_rev_component_rec.attribute5 := NULL;
380: END IF;
381:
382: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
383: g_rev_component_rec.attribute6 := NULL;
384: END IF;
385:
386: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 386: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

382: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
383: g_rev_component_rec.attribute6 := NULL;
384: END IF;
385:
386: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
387: g_rev_component_rec.attribute7 := NULL;
388: END IF;
389:
390: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 390: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

386: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
387: g_rev_component_rec.attribute7 := NULL;
388: END IF;
389:
390: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
391: g_rev_component_rec.attribute8 := NULL;
392: END IF;
393:
394: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 394: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

390: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
391: g_rev_component_rec.attribute8 := NULL;
392: END IF;
393:
394: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
395: g_rev_component_rec.attribute9 := NULL;
396: END IF;
397:
398: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 398: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

394: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
395: g_rev_component_rec.attribute9 := NULL;
396: END IF;
397:
398: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
399: g_rev_component_rec.attribute10 := NULL;
400: END IF;
401:
402: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 402: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

398: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
399: g_rev_component_rec.attribute10 := NULL;
400: END IF;
401:
402: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
403: g_rev_component_rec.attribute11 := NULL;
404: END IF;
405:
406: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 406: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

402: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
403: g_rev_component_rec.attribute11 := NULL;
404: END IF;
405:
406: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
407: g_rev_component_rec.attribute12 := NULL;
408: END IF;
409:
410: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 410: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

406: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
407: g_rev_component_rec.attribute12 := NULL;
408: END IF;
409:
410: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
411: g_rev_component_rec.attribute13 := NULL;
412: END IF;
413:
414: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 414: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

410: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
411: g_rev_component_rec.attribute13 := NULL;
412: END IF;
413:
414: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
415: g_rev_component_rec.attribute14 := NULL;
416: END IF;
417:
418: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 418: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

414: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
415: g_rev_component_rec.attribute14 := NULL;
416: END IF;
417:
418: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
419: g_rev_component_rec.attribute15 := NULL;
420: END IF;
421:
422: END Get_Flex_Rev_Component;

Line 464: g_Rev_Comp_Unexp_Rec.component_sequence_id = FND_API.G_MISS_NUM

460: -- Default Component_Sequence_Id
461: --
462: ********************************************************************/
463: IF g_Rev_Comp_Unexp_Rec.component_sequence_id IS NULL OR
464: g_Rev_Comp_Unexp_Rec.component_sequence_id = FND_API.G_MISS_NUM
465: THEN
466: g_Rev_Comp_Unexp_Rec.component_sequence_id := Get_Component_Sequence;
467: END IF;
468:

Line 527: IF NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 3 AND

523: -- Default To_End_Item_Unit_Number
524: --
525: ********************************************************************/
526:
527: IF NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 3 AND
528: g_rev_component_rec.to_end_item_unit_number IS NULL THEN
529:
530: g_rev_component_rec.to_end_item_unit_number := Get_To_End_Item_Number;
531:

Line 585: g_rev_comp_unexp_rec.pick_components = FND_API.G_MISS_NUM

581: --
582: ********************************************************************/
583:
584: IF g_Rev_Comp_Unexp_Rec.pick_components IS NULL OR
585: g_rev_comp_unexp_rec.pick_components = FND_API.G_MISS_NUM
586: THEN
587: g_Rev_Comp_Unexp_Rec.pick_components := Get_Pick_Components;
588: END IF;
589:

Line 609: IF g_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN

605: --
606: -- Default Disable Date
607: --
608: ********************************************************************/
609: IF g_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
610: g_rev_component_rec.disable_date := NULL;
611: END IF;
612:
613: --dbms_output.put_line('After Effectivity Defaulted . . .');

Line 741: IF g_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN

737: -- If the user is trying to NULL to subinventory, then NULL out
738: -- Supply Locator also.
739: --
740: ********************************************************************/
741: IF g_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
742: g_rev_component_rec.supply_subinventory := NULL;
743: g_Rev_Comp_Unexp_Rec.Supply_Locator_Id := NULL;
744: END IF;
745:

Line 749: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN

745:
746: --dbms_output.put_line('Subinventory . . . ' ||
747: -- g_rev_component_rec.supply_subinventory );
748:
749: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
750: g_rev_component_rec.comments := NULL;
751: END IF;
752:
753: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

Line 753: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

749: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
750: g_rev_component_rec.comments := NULL;
751: END IF;
752:
753: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
754: g_rev_component_rec.wip_supply_type := NULL;
755: END IF;
756:
757: IF g_rev_comp_Unexp_rec.bom_item_type IS NULL OR

Line 758: g_rev_comp_unexp_rec.bom_item_type = FND_API.G_MISS_NUM

754: g_rev_component_rec.wip_supply_type := NULL;
755: END IF;
756:
757: IF g_rev_comp_Unexp_rec.bom_item_type IS NULL OR
758: g_rev_comp_unexp_rec.bom_item_type = FND_API.G_MISS_NUM
759: THEN
760: g_rev_comp_Unexp_rec.bom_item_type := get_bom_item_type;
761: END IF;
762:

Line 763: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN

759: THEN
760: g_rev_comp_Unexp_rec.bom_item_type := get_bom_item_type;
761: END IF;
762:
763: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
764: g_rev_component_rec.acd_type := NULL;
765: END IF;
766:
767: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM THEN

Line 767: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM THEN

763: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
764: g_rev_component_rec.acd_type := NULL;
765: END IF;
766:
767: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM THEN
768: g_rev_comp_unexp_rec.supply_locator_id := NULL;
769: END IF;
770:
771: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR

Line 771: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR

767: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM THEN
768: g_rev_comp_unexp_rec.supply_locator_id := NULL;
769: END IF;
770:
771: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
772: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR

Line 772: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR

768: g_rev_comp_unexp_rec.supply_locator_id := NULL;
769: END IF;
770:
771: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
772: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR

Line 773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR

769: END IF;
770:
771: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
772: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR

Line 774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR

770:
771: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
772: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR

Line 775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR

771: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
772: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR

Line 776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR

772: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR

Line 777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR

773: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR

Line 778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR

774: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR

Line 779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR

775: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR

Line 780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR

776: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR

Line 781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR

777: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
785: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR

Line 782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR

778: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
785: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
786: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR

Line 783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR

779: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
785: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
786: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
787: THEN

Line 784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR

780: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
785: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
786: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
787: THEN
788:

Line 785: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR

781: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
785: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
786: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
787: THEN
788:
789: Get_Flex_Rev_Component;

Line 786: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR

782: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
783: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
784: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
785: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
786: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
787: THEN
788:
789: Get_Flex_Rev_Component;
790:

Line 841: l_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM

837: ) AND
838: ( l_rev_comp_unexp_rec.supply_locator_id =
839: p_old_rev_comp_unexp_rec.supply_locator_id OR
840: ( l_rev_comp_unexp_rec.supply_locator_id IS NOT NULL AND
841: l_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM
842: )
843: )
844: )
845: THEN

Line 852: l_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM

848:
849: ELSIF l_rev_component_rec.Supply_Subinventory IS NOT NULL AND
850: l_rev_component_rec.Supply_Subinventory <>
851: p_old_rev_component_rec.supply_subinventory AND
852: l_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM
853: THEN
854: -- dbms_output.put_line('Supply Locator made NULL . . .');
855:
856: l_rev_comp_unexp_rec.supply_locator_id := NULL;