APPS.AHL_RM_ROUTE_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 2705: DELETE AHL_RT_OPER_RESOURCES

2701: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
2702: END IF;
2703:
2704: -- 2.Delete Resource Requirements
2705: DELETE AHL_RT_OPER_RESOURCES
2706: WHERE OBJECT_ID = p_route_id
2707: AND ASSOCIATION_TYPE_CODE = 'ROUTE';
2708:
2709: -- If no records exist, then, Continue.

Line 2954: FROM ahl_rt_oper_resources

2950: ATTRIBUTE15,
2951: -- Bug # 7644260 (FP for ER # 6998882) -- start
2952: SCHEDULE_SEQ
2953: -- Bug # 7644260 (FP for ER # 6998882) -- end
2954: FROM ahl_rt_oper_resources
2955: WHERE object_id = c_route_id
2956: AND association_type_code = 'ROUTE';
2957:
2958: CURSOR get_route_efcts (c_route_id NUMBER) IS

Line 3437: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id

3433: AND association_type_code = 'ROUTE';
3434:
3435: -- 2.Copy Resource Requirements and Alternate Resources
3436: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_route_id) LOOP
3437: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
3438: FROM dual;
3439: INSERT INTO AHL_RT_OPER_RESOURCES
3440: (
3441: RT_OPER_RESOURCE_ID,

Line 3439: INSERT INTO AHL_RT_OPER_RESOURCES

3435: -- 2.Copy Resource Requirements and Alternate Resources
3436: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_route_id) LOOP
3437: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
3438: FROM dual;
3439: INSERT INTO AHL_RT_OPER_RESOURCES
3440: (
3441: RT_OPER_RESOURCE_ID,
3442: OBJECT_VERSION_NUMBER,
3443: OBJECT_ID,