APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_OPERATIONS_B

Line 1160: from ahl_operations_b

1156:
1157: cursor get_oper_status (p_operation_id in number)
1158: is
1159: select revision_status_code
1160: from ahl_operations_b
1161: where operation_id = p_operation_id;
1162:
1163: -- Bug # 7644260 (FP for ER # 6998882) -- start
1164: cursor get_min_sch_seq ( c_object_id NUMBER, c_association_type_code VARCHAR2 )

Line 1402: UPDATE ahl_operations_b

1398: OPEN get_oper_status (p_object_id);
1399: FETCH get_oper_status INTO l_obj_status;
1400: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
1401: THEN
1402: UPDATE ahl_operations_b
1403: SET revision_status_code = 'DRAFT'
1404: WHERE operation_id = p_object_id;
1405: END IF;
1406: CLOSE get_oper_status;

Line 2094: from ahl_operations_b

2090:
2091: cursor get_oper_status (p_operation_id in number)
2092: is
2093: select revision_status_code
2094: from ahl_operations_b
2095: where operation_id = p_operation_id;
2096:
2097: l_api_version CONSTANT NUMBER := 1.0;
2098: l_api_name CONSTANT VARCHAR2(30) := 'DEFINE_COST_PARAMETER';

Line 2294: UPDATE ahl_operations_b

2290: OPEN get_oper_status (l_object_id);
2291: FETCH get_oper_status INTO l_obj_status;
2292: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2293: THEN
2294: UPDATE ahl_operations_b
2295: SET revision_status_code = 'DRAFT'
2296: WHERE operation_id = l_object_id;
2297: END IF;
2298: CLOSE get_oper_status;