APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_OPERATIONS_B

Line 1202: from ahl_operations_b

1198:
1199: cursor get_oper_status (p_operation_id in number)
1200: is
1201: select revision_status_code
1202: from ahl_operations_b
1203: where operation_id = p_operation_id;
1204:
1205: -- Bug # 7644260 (FP for ER # 6998882) -- start
1206: cursor get_min_sch_seq ( c_object_id NUMBER, c_association_type_code VARCHAR2 )

Line 1444: UPDATE ahl_operations_b

1440: OPEN get_oper_status (p_object_id);
1441: FETCH get_oper_status INTO l_obj_status;
1442: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
1443: THEN
1444: UPDATE ahl_operations_b
1445: SET revision_status_code = 'DRAFT'
1446: WHERE operation_id = p_object_id;
1447: END IF;
1448: CLOSE get_oper_status;

Line 2136: from ahl_operations_b

2132:
2133: cursor get_oper_status (p_operation_id in number)
2134: is
2135: select revision_status_code
2136: from ahl_operations_b
2137: where operation_id = p_operation_id;
2138:
2139: l_api_version CONSTANT NUMBER := 1.0;
2140: l_api_name CONSTANT VARCHAR2(30) := 'DEFINE_COST_PARAMETER';

Line 2336: UPDATE ahl_operations_b

2332: OPEN get_oper_status (l_object_id);
2333: FETCH get_oper_status INTO l_obj_status;
2334: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2335: THEN
2336: UPDATE ahl_operations_b
2337: SET revision_status_code = 'DRAFT'
2338: WHERE operation_id = l_object_id;
2339: END IF;
2340: CLOSE get_oper_status;