DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on PA_ASSIGNMENTS_HISTORY_PKG

Line 934: -- PA_ASSIGNMENTS_HISTORY_PKG.Update_Row is not used, since the last_approved_flag is used as both

930: --so updating the previously last approved record's flag to 'N'.
931: --
932: --IF no previous approved record exist, this statement does nothing.
933: --
934: -- PA_ASSIGNMENTS_HISTORY_PKG.Update_Row is not used, since the last_approved_flag is used as both
935: -- an criteria for search and the parameter need to be updated.
936: --
937: UPDATE pa_assignments_history
938: SET last_approved_flag = 'N'

Line 952: PA_ASSIGNMENTS_HISTORY_PKG.Insert_Row

948: ,x_msg => 'insert last approved record into assignment history table.'
949: ,x_log_level => 5);
950: END IF;
951:
952: PA_ASSIGNMENTS_HISTORY_PKG.Insert_Row
953: (p_assignment_id => l_assignment_rec.assignment_id
954: ,p_assignment_name => l_assignment_rec.assignment_name
955: ,p_assignment_type => l_assignment_rec.assignment_type
956: ,p_multiple_status_flag => l_assignment_rec.multiple_status_flag