[Home] [Help]
286: -- Eng Change
287: IF g_unexp_eco_rec.change_mgmt_type_code = FND_API.G_MISS_CHAR
288: OR g_unexp_eco_rec.change_mgmt_type_code IS NULL
289: THEN
290: g_unexp_eco_rec.change_mgmt_type_code := Eng_Globals.G_CHANGE_ORDER ;
291: END IF;
292:
293: IF g_unexp_eco_rec.assignee_id = FND_API.G_MISS_NUM
294: THEN
536: );
537:
538: -- Initialize Workflow Process
539:
540: ENG_Globals.Init_Process_Name
541: ( g_Unexp_ECO_rec.change_order_type_id
542: , g_ECO_rec.priority_code
543: , g_Unexp_ECO_rec.organization_id);
544:
551: IF (p_control_rec.caller_type = 'FORM' AND
552: NVL(p_control_rec.validation_controller, FND_API.G_MISS_CHAR) =
553: 'PROCESS')
554: OR
555: l_ECO_rec.transaction_type = ENG_Globals.G_OPR_UPDATE
556: THEN
557: l_processed := FALSE;
558:
559: IF p_control_rec.caller_type = 'OI'
557: l_processed := FALSE;
558:
559: IF p_control_rec.caller_type = 'OI'
560: THEN
561: ENG_Globals.Check_Approved_For_Process
562: ( p_change_notice => l_ECO_rec.ECO_name
563: , p_organization_id => l_Unexp_ECO_rec.organization_id
564: , x_processed => l_processed
565: , x_err_text => l_err_text
626: END IF;
627:
628: l_processed := FALSE;
629:
630: IF l_ECO_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
631: (l_ECO_rec.priority_code <>
632: p_old_ECO_rec.priority_code OR
633: (l_ECO_rec.priority_code IS NULL AND
634: p_old_ECO_rec.priority_code IS NOT NULL) OR
638:
639: -- If process found, null out Approval List and set other approval details accordingly.
640: -- Also issue warning.
641:
642: ENG_Globals.Init_Process_Name
643: ( p_change_order_type_id => l_Unexp_ECO_rec.change_order_type_id
644: , p_priority_code => l_ECO_rec.priority_code
645: , p_organization_id => l_Unexp_ECO_rec.organization_id
646: );
646: );
647:
648: -- Get new Workflow Process name
649:
650: l_process_name := ENG_Globals.Get_Process_Name;
651:
652: IF l_process_name IS NOT NULL
653: THEN
654: l_Unexp_ECO_rec.approval_list_id := NULL;
670: END IF;
671: l_processed := TRUE;
672: END IF;
673:
674: IF l_ECO_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
675: (l_Unexp_ECO_rec.change_order_type_id <>
676: p_old_Unexp_ECO_rec.change_order_type_id OR
677: (l_Unexp_ECO_rec.change_order_type_id IS NULL AND
678: p_old_Unexp_ECO_rec.change_order_type_id IS NOT NULL))
683: ELSE
684:
685: -- Get new Workflow Process name
686:
687: ENG_Globals.Init_Process_Name
688: ( p_change_order_type_id => l_Unexp_ECO_rec.change_order_type_id
689: , p_priority_code => l_ECO_rec.priority_code
690: , p_organization_id => l_Unexp_ECO_rec.organization_id
691: );
689: , p_priority_code => l_ECO_rec.priority_code
690: , p_organization_id => l_Unexp_ECO_rec.organization_id
691: );
692:
693: l_process_name := ENG_Globals.Get_Process_Name;
694:
695: -- If process found, null out Approval List and set other approval details accordingly.
696: -- Also issue warning.
697:
716: END IF;
717: END IF;
718: END IF;
719:
720: IF l_ECO_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
721: (l_Unexp_ECO_rec.approval_list_id <>
722: p_old_Unexp_ECO_rec.approval_list_id OR
723: (l_Unexp_ECO_rec.approval_list_id IS NULL AND
724: p_old_Unexp_ECO_rec.approval_list_id IS NOT NULL) OR
762: END IF;
763:
764: END IF;
765:
766: IF l_ECO_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
767: (l_Unexp_ECO_rec.approval_status_type <>
768: p_old_Unexp_ECO_rec.approval_status_type OR
769: (l_Unexp_ECO_rec.approval_status_type IS NULL AND
770: p_old_Unexp_ECO_rec.approval_status_type IS NOT NULL) OR
845: -- Set the default hierarchy defined at the change type, if any.
846:
847: IF l_ECO_rec.organization_hierarchy IS NULL
848: AND l_ECO_rec.plm_or_erp_change = 'PLM'
849: AND l_ECO_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
850: THEN
851: l_sql_stmt := 'SELECT 1
852: FROM AK_CUSTOM_REGION_ITEMS AK_ITEMS, ENG_ATTRIBUTES_SECTIONS_TL ENG_ATTRIBUTES,
853: ENG_ATTRIBUTES_SECTIONS_B ENG_ATTRIBUTES_B, EGO_CUSTOMIZATION_EXT ATTRIBUTE_EXT