APPS.AHL_RM_ROUTE_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 3036: DELETE AHL_RT_OPER_RESOURCES

3032: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
3033: END IF;
3034:
3035: -- 2.Delete Resource Requirements
3036: DELETE AHL_RT_OPER_RESOURCES
3037: WHERE OBJECT_ID = p_route_id
3038: AND ASSOCIATION_TYPE_CODE = 'ROUTE';
3039:
3040: -- If no records exist, then, Continue.

Line 3285: FROM ahl_rt_oper_resources

3281: ATTRIBUTE15,
3282: -- Bug # 7644260 (FP for ER # 6998882) -- start
3283: SCHEDULE_SEQ
3284: -- Bug # 7644260 (FP for ER # 6998882) -- end
3285: FROM ahl_rt_oper_resources
3286: WHERE object_id = c_route_id
3287: AND association_type_code = 'ROUTE';
3288:
3289: CURSOR get_route_efcts (c_route_id NUMBER) IS

Line 3861: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id

3857: AND association_type_code = 'ROUTE';
3858:
3859: -- 2.Copy Resource Requirements and Alternate Resources
3860: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_route_id) LOOP
3861: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
3862: FROM dual;
3863: INSERT INTO AHL_RT_OPER_RESOURCES
3864: (
3865: RT_OPER_RESOURCE_ID,

Line 3863: INSERT INTO AHL_RT_OPER_RESOURCES

3859: -- 2.Copy Resource Requirements and Alternate Resources
3860: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_route_id) LOOP
3861: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
3862: FROM dual;
3863: INSERT INTO AHL_RT_OPER_RESOURCES
3864: (
3865: RT_OPER_RESOURCE_ID,
3866: OBJECT_VERSION_NUMBER,
3867: OBJECT_ID,