APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_OPERATIONS_TL

Line 532: Update AHL_OPERATIONS_TL

528: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
529: FND_MSG_PUB.ADD;
530: END IF;
531:
532: Update AHL_OPERATIONS_TL
533: Set APPROVER_NOTE=null
534: Where OPERATION_ID=p_source_operation_id;
535:
536: IF sql%rowcount=0

Line 1547: UPDATE AHL_OPERATIONS_TL

1543: UPDATE AHL_OPERATIONS_B
1544: SET REVISION_STATUS_CODE=l_status,
1545: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1546: WHERE OPERATION_ID=P_OPERATION_ID;
1547: UPDATE AHL_OPERATIONS_TL
1548: SET APPROVER_NOTE=p_approver_note
1549: WHERE OPERATION_ID=P_OPERATION_ID;
1550: ELSIF l_check_flag='Y' and l_curr_status='TERMINATION_PENDING'
1551: and p_appr_status='APPROVED'