APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_OPERATIONS_TL

Line 476: Update AHL_OPERATIONS_TL

472: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
473: FND_MSG_PUB.ADD;
474: END IF;
475:
476: Update AHL_OPERATIONS_TL
477: Set APPROVER_NOTE=null
478: Where OPERATION_ID=p_source_operation_id;
479:
480: IF sql%rowcount=0

Line 1487: UPDATE AHL_OPERATIONS_TL

1483: UPDATE AHL_OPERATIONS_B
1484: SET REVISION_STATUS_CODE=l_status,
1485: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1486: WHERE OPERATION_ID=P_OPERATION_ID;
1487: UPDATE AHL_OPERATIONS_TL
1488: SET APPROVER_NOTE=p_approver_note
1489: WHERE OPERATION_ID=P_OPERATION_ID;
1490: ELSIF l_check_flag='Y' and l_curr_status='TERMINATION_PENDING'
1491: and p_appr_status='APPROVED'