[Home] [Help]
3017: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Effectivities' );
3018: END IF;
3019:
3020: -- 1.Delete Material Requirements
3021: DELETE AHL_RT_OPER_MATERIALS
3022: WHERE OBJECT_ID = p_route_id
3023: AND ASSOCIATION_TYPE_CODE = 'ROUTE';
3024:
3025: -- If no records exist, then, Continue.
3694: l_get_route_efcts.ATTRIBUTE14,
3695: l_get_route_efcts.ATTRIBUTE15
3696: );
3697:
3698: INSERT INTO AHL_RT_OPER_MATERIALS
3699: (
3700: RT_OPER_MATERIAL_ID,
3701: OBJECT_VERSION_NUMBER,
3702: OBJECT_ID,
3733: CREATED_BY,
3734: LAST_UPDATE_LOGIN,
3735: IN_SERVICE --pdoki added for OGMA 105 issue
3736: ) SELECT
3737: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
3738: 1,
3739: l_route_effectivity_id,
3740: 'DISPOSITION',
3741: position_path_id ,
3769: creation_date,
3770: created_by,
3771: last_update_login,
3772: in_service --pdoki added for OGMA 105 issue
3773: FROM AHL_RT_OPER_MATERIALS
3774: WHERE OBJECT_ID = l_get_route_efcts.route_effectivity_id
3775: -- Added condition for fixing bug #12733884 - sthilak; sorao for backporting project
3776: AND ASSOCIATION_TYPE_CODE = 'DISPOSITION';
3777:
3777:
3778: END LOOP;
3779:
3780: -- 1.Copy Material Requirements
3781: INSERT INTO AHL_RT_OPER_MATERIALS
3782: (
3783: RT_OPER_MATERIAL_ID,
3784: OBJECT_VERSION_NUMBER,
3785: OBJECT_ID,
3816: MC_ID,
3817: POSITION_KEY
3818: )
3819: SELECT
3820: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
3821: 1,
3822: l_route_id,
3823: ASSOCIATION_TYPE_CODE,
3824: ITEM_GROUP_ID,
3851: IN_SERVICE, --pdoki added for OGMA 105 issue
3852: --sukhwsin::SB Effectivity - added two columns for position based mat. requirements
3853: MC_ID,
3854: POSITION_KEY
3855: FROM AHL_RT_OPER_MATERIALS
3856: WHERE object_id = p_route_id
3857: AND association_type_code = 'ROUTE';
3858:
3859: -- 2.Copy Resource Requirements and Alternate Resources