APPS.HR_CONTINGENT_WORKER_BK2 SQL Statements

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

Line: 12

,P_DATETRACK_UPDATE_MODE in VARCHAR2
,P_PER_EFFECTIVE_START_DATE in DATE
,P_PER_EFFECTIVE_END_DATE in DATE
,P_PDP_OBJECT_VERSION_NUMBER in NUMBER
,P_ASSIGNMENT_ID in NUMBER
,P_ASG_OBJECT_VERSION_NUMBER in NUMBER
,P_ASSIGNMENT_SEQUENCE in NUMBER
)is
l_commit_unit_number number;

Line: 33

,P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE
,P_PER_EFFECTIVE_START_DATE => P_PER_EFFECTIVE_START_DATE
,P_PER_EFFECTIVE_END_DATE => P_PER_EFFECTIVE_END_DATE
,P_PDP_OBJECT_VERSION_NUMBER => P_PDP_OBJECT_VERSION_NUMBER
,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
,P_ASG_OBJECT_VERSION_NUMBER => P_ASG_OBJECT_VERSION_NUMBER
,P_ASSIGNMENT_SEQUENCE => P_ASSIGNMENT_SEQUENCE
);

Line: 53

,P_DATETRACK_UPDATE_MODE in VARCHAR2
)is
begin
hr_utility.set_location('Entering: HR_CONTINGENT_WORKER_BK2.CONVERT_TO_CWK_B', 10);