eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EMPLOYEE_BK1 SQL Statements

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

Line: 108


,P_RESUME_LAST_UPDATED in DATE
,P_SECOND_PASSPORT_EXISTS in VARCHAR2
,P_STUDENT_STATUS in VARCHAR2
,P_WORK_SCHEDULE in VARCHAR2
,P_SUFFIX in VARCHAR2
,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_COORD_BEN_MED_EXT_ER in VARCHAR2
,P_COORD_BEN_MED_PL_NAME in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_NAME in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_IDENT in VARCHAR2
,P_COORD_BEN_MED_CVG_STRT_DT in DATE
,P_COORD_BEN_MED_CVG_END_DT in DATE
,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_ADJUSTED_SVC_DATE in DATE
,P_PERSON_ID in NUMBER
,P_ASSIGNMENT_ID in NUMBER
,P_PER_OBJECT_VERSION_NUMBER in NUMBER
,P_ASG_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_ASSIGNMENT_NUMBER in VARCHAR2
,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 NUMBER
,P_NAME_COMBINATION_WARNING in BOOLEAN
,P_ASSIGN_PAYROLL_WARNING in BOOLEAN
,P_ORIG_HIRE_WARNING in BOOLEAN
)is
l_commit_unit_number number;

Line: 256


,P_RESUME_LAST_UPDATED => P_RESUME_LAST_UPDATED
,P_SECOND_PASSPORT_EXISTS => P_SECOND_PASSPORT_EXISTS
,P_STUDENT_STATUS => P_STUDENT_STATUS
,P_WORK_SCHEDULE => P_WORK_SCHEDULE
,P_SUFFIX => P_SUFFIX
,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_COORD_BEN_MED_EXT_ER => P_COORD_BEN_MED_EXT_ER
,P_COORD_BEN_MED_PL_NAME => P_COORD_BEN_MED_PL_NAME
,P_COORD_BEN_MED_INSR_CRR_NAME => P_COORD_BEN_MED_INSR_CRR_NAME
,P_COORD_BEN_MED_INSR_CRR_IDENT => P_COORD_BEN_MED_INSR_CRR_IDENT
,P_COORD_BEN_MED_CVG_STRT_DT => P_COORD_BEN_MED_CVG_STRT_DT
,P_COORD_BEN_MED_CVG_END_DT => P_COORD_BEN_MED_CVG_END_DT
,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_ADJUSTED_SVC_DATE => P_ADJUSTED_SVC_DATE
,P_PERSON_ID => P_PERSON_ID
,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
,P_PER_OBJECT_VERSION_NUMBER => P_PER_OBJECT_VERSION_NUMBER
,P_ASG_OBJECT_VERSION_NUMBER => P_ASG_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_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER
,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_NAME_COMBINATION_WARNING => P_NAME_COMBINATION_WARNING
,P_ASSIGN_PAYROLL_WARNING => P_ASSIGN_PAYROLL_WARNING
,P_ORIG_HIRE_WARNING => P_ORIG_HIRE_WARNING
);

Line: 432


,P_RESUME_LAST_UPDATED in DATE
,P_SECOND_PASSPORT_EXISTS in VARCHAR2
,P_STUDENT_STATUS in VARCHAR2
,P_WORK_SCHEDULE in VARCHAR2
,P_SUFFIX in VARCHAR2
,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_COORD_BEN_MED_EXT_ER in VARCHAR2
,P_COORD_BEN_MED_PL_NAME in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_NAME in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_IDENT in VARCHAR2
,P_COORD_BEN_MED_CVG_STRT_DT in DATE
,P_COORD_BEN_MED_CVG_END_DT in DATE
,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_ADJUSTED_SVC_DATE 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 NUMBER
)is
l_commit_unit_number number;

Line: 577


PER_IN_PERSON_LEG_HOOK.CHECK_IN_PERSON_INSERT
(P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
,P_HIRE_DATE => P_HIRE_DATE
,P_PER_INFORMATION4 => P_PER_INFORMATION4
,P_PER_INFORMATION5 => P_PER_INFORMATION5
,P_PER_INFORMATION6 => P_PER_INFORMATION6
,P_PER_INFORMATION7 => P_PER_INFORMATION7
,P_PER_INFORMATION8 => P_PER_INFORMATION8
,P_PER_INFORMATION9 => P_PER_INFORMATION9
,P_PER_INFORMATION10 => P_PER_INFORMATION10
,P_PER_INFORMATION11 => P_PER_INFORMATION11
,P_PER_INFORMATION12 => P_PER_INFORMATION12
,P_PER_INFORMATION13 => P_PER_INFORMATION13
,P_PER_INFORMATION14 => P_PER_INFORMATION14
,P_PER_INFORMATION15 => P_PER_INFORMATION15
);