APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 733: FROM ENG_CHANGE_ORDER_TYPES_VL

729: l_enable_item_in_local_org,
730: l_create_bom_in_local_org,
731: l_subject_updatable_flag,
732: l_base_change_mgmt_type_code --Added for Bug No:3497234, Issue: DEF-2071
733: FROM ENG_CHANGE_ORDER_TYPES_VL
734: WHERE
735: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
736:
737: SELECT START_DATE INTO c_start_date

Line 738: FROM ENG_CHANGE_ORDER_TYPES_VL

734: WHERE
735: CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
736:
737: SELECT START_DATE INTO c_start_date
738: FROM ENG_CHANGE_ORDER_TYPES_VL
739: WHERE CHANGE_MGMT_TYPE_CODE = X_CHANGE_MGMT_TYPE_CODE
740: AND TYPE_CLASSIFICATION = 'CATEGORY';
741:
742: ENG_CHANGE_ORDER_TYPES_PKG.INSERT_ROW(

Line 1101: FROM ENG_CHANGE_ORDER_TYPES_VL

1097: THEN
1098:
1099: SELECT CHANGE_MGMT_TYPE_CODE
1100: INTO l_base_change_mgmt_type_code
1101: FROM ENG_CHANGE_ORDER_TYPES_VL
1102: WHERE CHANGE_ORDER_TYPE_ID = l_parent_cat_id;
1103:
1104: DUPLICATE_CATEGORY_ENTRIES (
1105: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,

Line 1164: FROM ENG_CHANGE_ORDER_TYPES_VL

1160:
1161: ELSE
1162: SELECT BASE_CHANGE_MGMT_TYPE_CODE
1163: INTO l_base_change_mgmt_type_code
1164: FROM ENG_CHANGE_ORDER_TYPES_VL
1165: WHERE CHANGE_ORDER_TYPE_ID = X_CHANGE_ORDER_TYPE_ID;
1166:
1167: ADD_DEFAULT_LIFECYCLES (
1168: X_CHANGE_ORDER_TYPE_ID => X_CHANGE_ORDER_TYPE_ID,