DBA Data[Home] [Help]

APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 696: FROM ENG_CHANGE_ORDER_TYPES_VL

692: l_enable_item_in_local_org,
693: l_create_bom_in_local_org,
694: l_subject_updatable_flag,
695: l_base_change_mgmt_type_code --Added for Bug No:3497234, Issue: DEF-2071
696: FROM ENG_CHANGE_ORDER_TYPES_VL
697: WHERE
698: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
699:
700: SELECT START_DATE INTO c_start_date

Line 701: FROM ENG_CHANGE_ORDER_TYPES_VL

697: WHERE
698: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
699:
700: SELECT START_DATE INTO c_start_date
701: FROM ENG_CHANGE_ORDER_TYPES_VL
702: WHERE CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
703: AND TYPE_CLASSIFICATION = 'CATEGORY';
704:
705: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(

Line 1064: FROM ENG_CHANGE_ORDER_TYPES_VL

1060: THEN
1061:
1062: SELECT CHANGE_MGMT_TYPE_CODE
1063: INTO l_base_change_mgmt_type_code
1064: FROM ENG_CHANGE_ORDER_TYPES_VL
1065: WHERE CHANGE_ORDER_TYPE_ID = l_parent_cat_id;
1066:
1067: DUPLICATE_CATEGORY_ENTRIES (
1068: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,

Line 1127: FROM ENG_CHANGE_ORDER_TYPES_VL

1123:
1124: ELSE
1125: SELECT BASE_CHANGE_MGMT_TYPE_CODE
1126: INTO l_base_change_mgmt_type_code
1127: FROM ENG_CHANGE_ORDER_TYPES_VL
1128: WHERE CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1129:
1130: ADD_DEFAULT_LIFECYCLES (
1131: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,