APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_ROUTES_TL

Line 857: UPDATE AHL_ROUTES_TL

853: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
854: FND_MSG_PUB.ADD;
855: END IF ;
856:
857: UPDATE AHL_ROUTES_TL
858: SET APPROVER_NOTE=null
859: WHERE ROUTE_ID=p_source_route_id;
860:
861: IF sql%rowcount=0

Line 1096: UPDATE AHL_ROUTES_TL

1092: SET REVISION_STATUS_CODE=l_status,
1093: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1094: WHERE ROUTE_ID=P_ROUTE_ID;
1095:
1096: UPDATE AHL_ROUTES_TL
1097: SET APPROVER_NOTE=p_approver_note
1098: WHERE ROUTE_ID=P_ROUTE_ID;
1099: Elsif l_check_flag='Y' and l_curr_status='TERMINATION_PENDING' and
1100: p_appr_status='APPROVED'