APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_ROUTES_TL

Line 915: UPDATE AHL_ROUTES_TL

911: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
912: FND_MSG_PUB.ADD;
913: END IF ;
914:
915: UPDATE AHL_ROUTES_TL
916: SET APPROVER_NOTE=null
917: WHERE ROUTE_ID=p_source_route_id;
918:
919: IF sql%rowcount=0

Line 1154: UPDATE AHL_ROUTES_TL

1150: SET REVISION_STATUS_CODE=l_status,
1151: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1152: WHERE ROUTE_ID=P_ROUTE_ID;
1153:
1154: UPDATE AHL_ROUTES_TL
1155: SET APPROVER_NOTE=p_approver_note
1156: WHERE ROUTE_ID=P_ROUTE_ID;
1157: Elsif l_check_flag='Y' and l_curr_status='TERMINATION_PENDING' and
1158: p_appr_status='APPROVED'