APPS.HR_APPLICANT_BK1 SQL Statements

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

Line: 101

,P_RESUME_LAST_UPDATED in DATE
,P_STUDENT_STATUS in VARCHAR2
,P_WORK_SCHEDULE in VARCHAR2
,P_SUFFIX in VARCHAR2
,P_DATE_OF_DEATH in DATE
,P_BENEFIT_GROUP_ID in NUMBER
,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
,P_COORD_BEN_MED_PLN_NO in VARCHAR2
,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
,P_USES_TOBACCO_FLAG in VARCHAR2
,P_DPDNT_ADOPTION_DATE in DATE
,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
,P_ORIGINAL_DATE_OF_HIRE in DATE
,P_PERSON_ID in NUMBER
,P_ASSIGNMENT_ID in NUMBER
,P_APPLICATION_ID in NUMBER
,P_PER_OBJECT_VERSION_NUMBER in NUMBER
,P_ASG_OBJECT_VERSION_NUMBER in NUMBER
,P_APL_OBJECT_VERSION_NUMBER in NUMBER
,P_PER_EFFECTIVE_START_DATE in DATE
,P_PER_EFFECTIVE_END_DATE in DATE
,P_FULL_NAME in VARCHAR2
,P_PER_COMMENT_ID in NUMBER
,P_ASSIGNMENT_SEQUENCE in NUMBER
,P_NAME_COMBINATION_WARNING in BOOLEAN
,P_ORIG_HIRE_WARNING in BOOLEAN
,P_TOWN_OF_BIRTH in VARCHAR2
,P_REGION_OF_BIRTH in VARCHAR2
,P_COUNTRY_OF_BIRTH in VARCHAR2
,P_GLOBAL_PERSON_ID in VARCHAR2
,P_PARTY_ID in VARCHAR2
,P_VACANCY_ID in NUMBER
)is
l_commit_unit_number number;

Line: 236

,P_RESUME_LAST_UPDATED => P_RESUME_LAST_UPDATED
,P_STUDENT_STATUS => P_STUDENT_STATUS
,P_WORK_SCHEDULE => P_WORK_SCHEDULE
,P_SUFFIX => P_SUFFIX
,P_DATE_OF_DEATH => P_DATE_OF_DEATH
,P_BENEFIT_GROUP_ID => P_BENEFIT_GROUP_ID
,P_RECEIPT_OF_DEATH_CERT_DATE => P_RECEIPT_OF_DEATH_CERT_DATE
,P_COORD_BEN_MED_PLN_NO => P_COORD_BEN_MED_PLN_NO
,P_COORD_BEN_NO_CVG_FLAG => P_COORD_BEN_NO_CVG_FLAG
,P_USES_TOBACCO_FLAG => P_USES_TOBACCO_FLAG
,P_DPDNT_ADOPTION_DATE => P_DPDNT_ADOPTION_DATE
,P_DPDNT_VLNTRY_SVCE_FLAG => P_DPDNT_VLNTRY_SVCE_FLAG
,P_ORIGINAL_DATE_OF_HIRE => P_ORIGINAL_DATE_OF_HIRE
,P_PERSON_ID => P_PERSON_ID
,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
,P_APPLICATION_ID => P_APPLICATION_ID
,P_PER_OBJECT_VERSION_NUMBER => P_PER_OBJECT_VERSION_NUMBER
,P_ASG_OBJECT_VERSION_NUMBER => P_ASG_OBJECT_VERSION_NUMBER
,P_APL_OBJECT_VERSION_NUMBER => P_APL_OBJECT_VERSION_NUMBER
,P_PER_EFFECTIVE_START_DATE => P_PER_EFFECTIVE_START_DATE
,P_PER_EFFECTIVE_END_DATE => P_PER_EFFECTIVE_END_DATE
,P_FULL_NAME => P_FULL_NAME
,P_PER_COMMENT_ID => P_PER_COMMENT_ID
,P_ASSIGNMENT_SEQUENCE => P_ASSIGNMENT_SEQUENCE
,P_NAME_COMBINATION_WARNING => P_NAME_COMBINATION_WARNING
,P_ORIG_HIRE_WARNING => P_ORIG_HIRE_WARNING
,P_TOWN_OF_BIRTH => P_TOWN_OF_BIRTH
,P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
,P_COUNTRY_OF_BIRTH => P_COUNTRY_OF_BIRTH
,P_GLOBAL_PERSON_ID => P_GLOBAL_PERSON_ID
,P_PARTY_ID => P_PARTY_ID
,P_VACANCY_ID => P_VACANCY_ID
);

Line: 394

,P_RESUME_LAST_UPDATED in DATE
,P_STUDENT_STATUS in VARCHAR2
,P_WORK_SCHEDULE in VARCHAR2
,P_SUFFIX in VARCHAR2
,P_DATE_OF_DEATH in DATE
,P_BENEFIT_GROUP_ID in NUMBER
,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
,P_COORD_BEN_MED_PLN_NO in VARCHAR2
,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
,P_USES_TOBACCO_FLAG in VARCHAR2
,P_DPDNT_ADOPTION_DATE in DATE
,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
,P_ORIGINAL_DATE_OF_HIRE in DATE
,P_TOWN_OF_BIRTH in VARCHAR2
,P_REGION_OF_BIRTH in VARCHAR2
,P_COUNTRY_OF_BIRTH in VARCHAR2
,P_GLOBAL_PERSON_ID in VARCHAR2
,P_PARTY_ID in VARCHAR2
,P_VACANCY_ID in NUMBER
)is
l_commit_unit_number number;