APPS.AHL_RM_OPERATION_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 1856: DELETE AHL_RT_OPER_RESOURCES

1852: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
1853: END IF;
1854:
1855: -- 2.Delete Resource Requirements
1856: DELETE AHL_RT_OPER_RESOURCES
1857: WHERE OBJECT_ID = p_operation_id
1858: AND ASSOCIATION_TYPE_CODE = 'OPERATION';
1859:
1860: -- If no records exist, then, Continue.

Line 2084: FROM ahl_rt_oper_resources

2080: ATTRIBUTE15,
2081: -- Bug # 7644260 (FP for ER # 6998882) -- start
2082: SCHEDULE_SEQ
2083: -- Bug # 7644260 (FP for ER # 6998882) -- end
2084: FROM ahl_rt_oper_resources
2085: WHERE object_id = c_operation_id
2086: AND association_type_code = 'OPERATION';
2087:
2088: BEGIN

Line 2347: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id

2343: AND association_type_code = 'OPERATION';
2344:
2345: -- 2.Copy Resource Requirements and Alternate Resources
2346: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_operation_id) LOOP
2347: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
2348: FROM dual;
2349: INSERT INTO AHL_RT_OPER_RESOURCES
2350: (
2351: RT_OPER_RESOURCE_ID,

Line 2349: INSERT INTO AHL_RT_OPER_RESOURCES

2345: -- 2.Copy Resource Requirements and Alternate Resources
2346: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_operation_id) LOOP
2347: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
2348: FROM dual;
2349: INSERT INTO AHL_RT_OPER_RESOURCES
2350: (
2351: RT_OPER_RESOURCE_ID,
2352: OBJECT_VERSION_NUMBER,
2353: LAST_UPDATE_DATE,