APPS.ENG_VALIDATE_REVISED_ITEM dependencies on ENG_ENGINEERING_CHANGES

Line 1039: FROM ENG_ENGINEERING_CHANGES

1035: l_ret BOOLEAN := FALSE;
1036:
1037: CURSOR check_ECO IS
1038: SELECT 1
1039: FROM ENG_ENGINEERING_CHANGES
1040: WHERE change_notice = p_change_notice
1041: AND organization_id = p_organization_id
1042: AND approval_status_type = 3;
1043: BEGIN

Line 1062: FROM ENG_ENGINEERING_CHANGES

1058: l_route_type_code VARCHAR2(30);
1059:
1060: CURSOR get_change_id IS
1061: SELECT CHANGE_ID
1062: FROM ENG_ENGINEERING_CHANGES
1063: WHERE CHANGE_NOTICE = p_change_notice
1064: AND ORGANIZATION_ID = p_organization_id;
1065:
1066: CURSOR check_eco_route_type(p_change_id NUMBER) IS

Line 1068: FROM ENG_ENGINEERING_CHANGES eec,

1064: AND ORGANIZATION_ID = p_organization_id;
1065:
1066: CURSOR check_eco_route_type(p_change_id NUMBER) IS
1067: SELECT ecr.ROUTE_TYPE_CODE
1068: FROM ENG_ENGINEERING_CHANGES eec,
1069: ENG_LIFECYCLE_STATUSES els,
1070: ENG_CHANGE_ROUTES ecr
1071: WHERE eec.CHANGE_ID = p_change_id
1072: AND els.ENTITY_NAME(+) = 'ENG_CHANGE'

Line 1124: FROM ENG_ENGINEERING_CHANGES

1120: l_ret BOOLEAN := FALSE;
1121:
1122: CURSOR check_ECO IS
1123: SELECT 1
1124: FROM ENG_ENGINEERING_CHANGES
1125: WHERE change_notice = p_change_notice
1126: AND organization_id = p_organization_id
1127: AND status_type = 1;
1128: BEGIN

Line 2180: FROM eng_engineering_changes

2176:
2177: l_ECO_approved NUMBER := 0;
2178: cursor c_CheckEcoApproval IS
2179: SELECT 1
2180: FROM eng_engineering_changes
2181: WHERE change_notice = p_revised_item_rec.eco_name
2182: AND organization_id = p_rev_item_unexp_rec.organization_id
2183: AND approval_status_type = 5;
2184:

Line 4882: FROM eng_engineering_changes

4878: THEN
4879: BEGIN
4880: SELECT 1
4881: INTO l_result
4882: FROM eng_engineering_changes
4883: WHERE change_notice = p_revised_item_rec.eco_name
4884: AND organization_id =
4885: p_rev_item_unexp_rec.organization_id
4886: AND status_type = p_revised_item_rec.status_type;

Line 6934: eng_engineering_changes eec

6930: CURSOR GetSubjects IS
6931: SELECT ecpv.attribute_code ,
6932: ecpv.attribute_char_value
6933: FROM eng_change_policies_v ecpv ,
6934: eng_engineering_changes eec
6935: WHERE ecpv.policy_object_name = 'EGO_CHANGE_TYPE'
6936: AND ecpv.policy_object_pk1_value = eec.change_order_type_id
6937: AND eec.change_notice = p_change_notice;
6938: BEGIN