APPS.HR_ASSIGNMENT_BK6 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

,P_DATETRACK_UPDATE_MODE in VARCHAR2
,P_ASSIGNMENT_ID in NUMBER
,P_CHANGE_REASON in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
)is
l_commit_unit_number number;

Line: 23

,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
,P_CHANGE_REASON => P_CHANGE_REASON
,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
,P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE
,P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE
);

Line: 38

,P_DATETRACK_UPDATE_MODE in VARCHAR2
,P_ASSIGNMENT_ID in NUMBER
,P_CHANGE_REASON in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
)is
begin
hr_utility.set_location('Entering: HR_ASSIGNMENT_BK6.ACTIVATE_EMP_ASG_B', 10);