APPS.ENG_GLOBALS dependencies on ENG_ENGINEERING_CHANGES

Line 482: FROM eng_engineering_changes

478: l_process_name := ENG_Globals.Get_Process_Name;
479:
480: SELECT approval_status_type
481: INTO l_approval_status_type
482: FROM eng_engineering_changes
483: WHERE change_notice = p_change_notice
484: AND organization_id = p_organization_id;
485:
486: -- ECO w/ Process is Approved

Line 520: UPDATE eng_engineering_changes

516: IS
517: BEGIN
518: -- Set ECO to 'Not Submitted For Approval'
519:
520: UPDATE eng_engineering_changes
521: SET approval_status_type = 1,
522: approval_request_date = null,
523: approval_date = null,
524: last_update_date = SYSDATE,

Line 583: from eng_engineering_changes

579: into l_assembly_type
580: from eng_change_order_types
581: where change_order_type_id =
582: (select change_order_type_id
583: from eng_engineering_changes
584: where change_notice = p_change_notice
585: and organization_id = p_organization_id);
586:
587: RETURN l_assembly_type;

Line 607: from ENG_ENGINEERING_CHANGES

603: l_process_name VARCHAR2(30) := NULL;
604: l_status_type NUMBER := NULL;
605:
606: cursor get_pri_chgtype_stat is select priority_code, change_order_type_id, status_type
607: from ENG_ENGINEERING_CHANGES
608: where change_notice = p_change_notice
609: and organization_id = p_organization_id;
610:
611: cursor check_ECO is select 1

Line 612: from ENG_ENGINEERING_CHANGES

608: where change_notice = p_change_notice
609: and organization_id = p_organization_id;
610:
611: cursor check_ECO is select 1
612: from ENG_ENGINEERING_CHANGES
613: where change_notice = p_change_notice
614: and organization_id = p_organization_id
615: and approval_status_type = 3;
616: BEGIN

Line 649: FROM eng_engineering_changes

645: ) RETURN VARCHAR2
646: IS
647: CURSOR c_plm_or_erp IS
648: SELECT nvl(plm_or_erp_change, 'PLM') plm_or_erp
649: FROM eng_engineering_changes
650: WHERE change_notice = p_change_notice
651: AND organization_id = p_organization_id;
652:
653: l_plm_or_erp_change VARCHAR2(3);