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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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:
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:
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:
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 . . .');
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:
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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;
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:
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
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;