APPS.AHL_RM_OPERATION_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 2060: DELETE AHL_RT_OPER_RESOURCES

2056: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
2057: END IF;
2058:
2059: -- 2.Delete Resource Requirements
2060: DELETE AHL_RT_OPER_RESOURCES
2061: WHERE OBJECT_ID = p_operation_id
2062: AND ASSOCIATION_TYPE_CODE = 'OPERATION';
2063:
2064: -- If no records exist, then, Continue.

Line 2288: FROM ahl_rt_oper_resources

2284: ATTRIBUTE15,
2285: -- Bug # 7644260 (FP for ER # 6998882) -- start
2286: SCHEDULE_SEQ
2287: -- Bug # 7644260 (FP for ER # 6998882) -- end
2288: FROM ahl_rt_oper_resources
2289: WHERE object_id = c_operation_id
2290: AND association_type_code = 'OPERATION';
2291:
2292: BEGIN

Line 2561: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id

2557: AND association_type_code = 'OPERATION';
2558:
2559: -- 2.Copy Resource Requirements and Alternate Resources
2560: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_operation_id) LOOP
2561: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
2562: FROM dual;
2563: INSERT INTO AHL_RT_OPER_RESOURCES
2564: (
2565: RT_OPER_RESOURCE_ID,

Line 2563: INSERT INTO AHL_RT_OPER_RESOURCES

2559: -- 2.Copy Resource Requirements and Alternate Resources
2560: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_operation_id) LOOP
2561: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
2562: FROM dual;
2563: INSERT INTO AHL_RT_OPER_RESOURCES
2564: (
2565: RT_OPER_RESOURCE_ID,
2566: OBJECT_VERSION_NUMBER,
2567: LAST_UPDATE_DATE,