APPS.ENG_DEFAULT_ECO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

    SELECT ENG_ENGINEERING_CHANGES_S.NEXTVAL
    INTO l_change_id
    FROM DUAL;

Line: 146

       SELECT status_code ,status_type
       from  eng_change_statuses_vl
       where status_code in
       (select status_code from  eng_lifecycle_statuses
                        where entity_name='ENG_CHANGE_TYPE'
                        and entity_id1 = p_change_order_type_id
                        and sequence_number =
                           (select min(sequence_number) from eng_lifecycle_statuses
                            where entity_name='ENG_CHANGE_TYPE'
                            and entity_id1 = p_change_order_type_id)
       );

Line: 162

			SELECT TypePriorityCodeEO.PRIORITY_CODE
    FROM
    ENG_CHANGE_TYPE_PRIORITIES TypePriorityCodeEO,
    ENG_CHANGE_PRIORITIES WHERE
    TypePriorityCodeEO.CHANGE_TYPE_ID = p_change_order_type_id AND
    TypePriorityCodeEO.PRIORITY_CODE = ENG_CHANGE_PRIORITIES.ENG_CHANGE_PRIORITY_CODE
    AND ENG_CHANGE_PRIORITIES.ORGANIZATION_ID=-1
    AND ROWNUM=1
    ORDER BY ENG_CHANGE_PRIORITY_CODE;

Line: 175

			select default_assignee_id,default_assignee_type
			      FROM ENG_CHANGE_ORDER_TYPES_VL
			      WHERE change_order_type_id=p_change_order_type_id
			      AND default_assignee_id IS NOT NULL;

Line: 223

			SELECT person_id INTO g_Unexp_ECO_rec.assignee_id FROM EGO_PEOPLE_V WHERE user_name=Upper(FND_GLOBAL.USER_NAME);

Line: 367

SELECT pos.organization_structure_id, pos.NAME
FROM per_organization_structures pos
WHERE pos.organization_structure_id in (SELECT hierarchy_id
		FROM ENG_TYPE_ORG_HIERARCHIES
		WHERE change_type_id = cp_change_type_id
		AND organization_id = cp_organization_id
		AND default_hierarchy_flag = 'Y');

Line: 555

       l_ECO_rec.transaction_type = ENG_Globals.G_OPR_UPDATE
    THEN
	l_processed := FALSE;

Line: 599

		        UPDATE eng_revised_items
        		   SET 	status_type = 1,
        			last_update_date = SYSDATE,
	        		last_updated_by = 'XXX',
		                last_update_login = 'XXX'
		         WHERE organization_id = p_Unexp_ECO_rec.organization_id
        		   AND change_notice = p_ECO_rec.ECO_name
		           AND status_type = 4;

Line: 851

    	l_sql_stmt := 'SELECT 1
			FROM AK_CUSTOM_REGION_ITEMS AK_ITEMS, ENG_ATTRIBUTES_SECTIONS_TL ENG_ATTRIBUTES,
			     ENG_ATTRIBUTES_SECTIONS_B ENG_ATTRIBUTES_B, EGO_CUSTOMIZATION_EXT  ATTRIBUTE_EXT
			WHERE
			     AK_ITEMS.ATTRIBUTE_CODE = ENG_ATTRIBUTES.ATTRIBUTE_SECTION_CODE
			     AND  ENG_ATTRIBUTES_B.ATTRIBUTE_SECTION_CODE = ENG_ATTRIBUTES.ATTRIBUTE_SECTION_CODE
			     AND ENG_ATTRIBUTES_B.ATTRIBUTE_SECTION_FLAG= ''A''
			     AND AK_ITEMS.PROPERTY_NAME= ''DISPLAY_SEQUENCE''
			     AND AK_ITEMS.CUSTOMIZATION_CODE=ATTRIBUTE_EXT.CUSTOMIZATION_CODE
			     AND ATTRIBUTE_EXT.CLASSIFICATION1 =:1
			     AND ATTRIBUTE_EXT.CLASSIFICATION2 =  :2
			     AND ATTRIBUTE_EXT.REGION_CODE = ''ENG_ADMIN_CONFIGURATIONS''
			     AND ATTRIBUTE_EXT.REGION_APPLICATION_ID = ''703''	 AND ENG_ATTRIBUTES.language = USERENV(''lang'')
			     AND AK_ITEMS.ATTRIBUTE_CODE =  ''ORGANIZATION_HIERARCHY''	';