APPS.BEN_CWB_PERSON_INFO_BK2 SQL Statements

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

Line: 5

procedure UPDATE_PERSON_INFO_A
(P_GROUP_PER_IN_LER_ID in NUMBER
,P_ASSIGNMENT_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_SUPERVISOR_ID in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_FULL_NAME in VARCHAR2
,P_BRIEF_NAME in VARCHAR2
,P_CUSTOM_NAME in VARCHAR2
,P_SUPERVISOR_FULL_NAME in VARCHAR2
,P_SUPERVISOR_BRIEF_NAME in VARCHAR2
,P_SUPERVISOR_CUSTOM_NAME in VARCHAR2
,P_LEGISLATION_CODE in VARCHAR2
,P_YEARS_EMPLOYED in NUMBER
,P_YEARS_IN_JOB in NUMBER
,P_YEARS_IN_POSITION in NUMBER
,P_YEARS_IN_GRADE in NUMBER
,P_EMPLOYEE_NUMBER in VARCHAR2
,P_START_DATE in DATE
,P_ORIGINAL_START_DATE in DATE
,P_ADJUSTED_SVC_DATE in DATE
,P_BASE_SALARY in NUMBER
,P_BASE_SALARY_CHANGE_DATE in DATE
,P_PAYROLL_NAME in VARCHAR2
,P_PERFORMANCE_RATING in VARCHAR2
,P_PERFORMANCE_RATING_TYPE in VARCHAR2
,P_PERFORMANCE_RATING_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_JOB_ID in NUMBER
,P_GRADE_ID in NUMBER
,P_POSITION_ID in NUMBER
,P_PEOPLE_GROUP_ID in NUMBER
,P_SOFT_CODING_KEYFLEX_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_PAY_RATE_ID in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
,P_FREQUENCY in VARCHAR2
,P_GRADE_ANNULIZATION_FACTOR in NUMBER
,P_PAY_ANNULIZATION_FACTOR in NUMBER
,P_GRD_MIN_VAL in NUMBER
,P_GRD_MAX_VAL in NUMBER
,P_GRD_MID_POINT in NUMBER
,P_GRD_QUARTILE in VARCHAR2
,P_GRD_COMPARATIO in NUMBER
,P_EMP_CATEGORY in VARCHAR2
,P_CHANGE_REASON in VARCHAR2
,P_NORMAL_HOURS in NUMBER
,P_EMAIL_ADDRESS in VARCHAR2
,P_BASE_SALARY_FREQUENCY in VARCHAR2
,P_NEW_ASSGN_OVN in NUMBER
,P_NEW_PERF_EVENT_ID in NUMBER
,P_NEW_PERF_REVIEW_ID in NUMBER
,P_POST_PROCESS_STAT_CD in VARCHAR2
,P_FEEDBACK_RATING in VARCHAR2
,P_FEEDBACK_COMMENTS in VARCHAR2
,P_CUSTOM_SEGMENT1 in VARCHAR2
,P_CUSTOM_SEGMENT2 in VARCHAR2
,P_CUSTOM_SEGMENT3 in VARCHAR2
,P_CUSTOM_SEGMENT4 in VARCHAR2
,P_CUSTOM_SEGMENT5 in VARCHAR2
,P_CUSTOM_SEGMENT6 in VARCHAR2
,P_CUSTOM_SEGMENT7 in VARCHAR2
,P_CUSTOM_SEGMENT8 in VARCHAR2
,P_CUSTOM_SEGMENT9 in VARCHAR2
,P_CUSTOM_SEGMENT10 in VARCHAR2
,P_CUSTOM_SEGMENT11 in NUMBER
,P_CUSTOM_SEGMENT12 in NUMBER
,P_CUSTOM_SEGMENT13 in NUMBER
,P_CUSTOM_SEGMENT14 in NUMBER
,P_CUSTOM_SEGMENT15 in NUMBER
,P_CUSTOM_SEGMENT16 in NUMBER
,P_CUSTOM_SEGMENT17 in NUMBER
,P_CUSTOM_SEGMENT18 in NUMBER
,P_CUSTOM_SEGMENT19 in NUMBER
,P_CUSTOM_SEGMENT20 in NUMBER
,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ASS_ATTRIBUTE1 in VARCHAR2
,P_ASS_ATTRIBUTE2 in VARCHAR2
,P_ASS_ATTRIBUTE3 in VARCHAR2
,P_ASS_ATTRIBUTE4 in VARCHAR2
,P_ASS_ATTRIBUTE5 in VARCHAR2
,P_ASS_ATTRIBUTE6 in VARCHAR2
,P_ASS_ATTRIBUTE7 in VARCHAR2
,P_ASS_ATTRIBUTE8 in VARCHAR2
,P_ASS_ATTRIBUTE9 in VARCHAR2
,P_ASS_ATTRIBUTE10 in VARCHAR2
,P_ASS_ATTRIBUTE11 in VARCHAR2
,P_ASS_ATTRIBUTE12 in VARCHAR2
,P_ASS_ATTRIBUTE13 in VARCHAR2
,P_ASS_ATTRIBUTE14 in VARCHAR2
,P_ASS_ATTRIBUTE15 in VARCHAR2
,P_ASS_ATTRIBUTE16 in VARCHAR2
,P_ASS_ATTRIBUTE17 in VARCHAR2
,P_ASS_ATTRIBUTE18 in VARCHAR2
,P_ASS_ATTRIBUTE19 in VARCHAR2
,P_ASS_ATTRIBUTE20 in VARCHAR2
,P_ASS_ATTRIBUTE21 in VARCHAR2
,P_ASS_ATTRIBUTE22 in VARCHAR2
,P_ASS_ATTRIBUTE23 in VARCHAR2
,P_ASS_ATTRIBUTE24 in VARCHAR2
,P_ASS_ATTRIBUTE25 in VARCHAR2
,P_ASS_ATTRIBUTE26 in VARCHAR2
,P_ASS_ATTRIBUTE27 in VARCHAR2
,P_ASS_ATTRIBUTE28 in VARCHAR2
,P_ASS_ATTRIBUTE29 in VARCHAR2
,P_ASS_ATTRIBUTE30 in VARCHAR2
,P_WS_COMMENTS in VARCHAR2
,P_PEOPLE_GROUP_NAME in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT1 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT2 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT3 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT4 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT5 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT6 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT7 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT8 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT9 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT10 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT11 in VARCHAR2
,P_CPI_ATTRIBUTE_CATEGORY in VARCHAR2
,P_CPI_ATTRIBUTE1 in VARCHAR2
,P_CPI_ATTRIBUTE2 in VARCHAR2
,P_CPI_ATTRIBUTE3 in VARCHAR2
,P_CPI_ATTRIBUTE4 in VARCHAR2
,P_CPI_ATTRIBUTE5 in VARCHAR2
,P_CPI_ATTRIBUTE6 in VARCHAR2
,P_CPI_ATTRIBUTE7 in VARCHAR2
,P_CPI_ATTRIBUTE8 in VARCHAR2
,P_CPI_ATTRIBUTE9 in VARCHAR2
,P_CPI_ATTRIBUTE10 in VARCHAR2
,P_CPI_ATTRIBUTE11 in VARCHAR2
,P_CPI_ATTRIBUTE12 in VARCHAR2
,P_CPI_ATTRIBUTE13 in VARCHAR2
,P_CPI_ATTRIBUTE14 in VARCHAR2
,P_CPI_ATTRIBUTE15 in VARCHAR2
,P_CPI_ATTRIBUTE16 in VARCHAR2
,P_CPI_ATTRIBUTE17 in VARCHAR2
,P_CPI_ATTRIBUTE18 in VARCHAR2
,P_CPI_ATTRIBUTE19 in VARCHAR2
,P_CPI_ATTRIBUTE20 in VARCHAR2
,P_CPI_ATTRIBUTE21 in VARCHAR2
,P_CPI_ATTRIBUTE22 in VARCHAR2
,P_CPI_ATTRIBUTE23 in VARCHAR2
,P_CPI_ATTRIBUTE24 in VARCHAR2
,P_CPI_ATTRIBUTE25 in VARCHAR2
,P_CPI_ATTRIBUTE26 in VARCHAR2
,P_CPI_ATTRIBUTE27 in VARCHAR2
,P_CPI_ATTRIBUTE28 in VARCHAR2
,P_CPI_ATTRIBUTE29 in VARCHAR2
,P_CPI_ATTRIBUTE30 in VARCHAR2
,P_FEEDBACK_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: BEN_CWB_PERSON_INFO_BK2.UPDATE_PERSON_INFO_A', 10);

Line: 161

hr_utility.set_location(' Leaving: BEN_CWB_PERSON_INFO_BK2.UPDATE_PERSON_INFO_A', 20);

Line: 162

end UPDATE_PERSON_INFO_A;

Line: 163

procedure UPDATE_PERSON_INFO_B
(P_GROUP_PER_IN_LER_ID in NUMBER
,P_ASSIGNMENT_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_SUPERVISOR_ID in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_FULL_NAME in VARCHAR2
,P_BRIEF_NAME in VARCHAR2
,P_CUSTOM_NAME in VARCHAR2
,P_SUPERVISOR_FULL_NAME in VARCHAR2
,P_SUPERVISOR_BRIEF_NAME in VARCHAR2
,P_SUPERVISOR_CUSTOM_NAME in VARCHAR2
,P_LEGISLATION_CODE in VARCHAR2
,P_YEARS_EMPLOYED in NUMBER
,P_YEARS_IN_JOB in NUMBER
,P_YEARS_IN_POSITION in NUMBER
,P_YEARS_IN_GRADE in NUMBER
,P_EMPLOYEE_NUMBER in VARCHAR2
,P_START_DATE in DATE
,P_ORIGINAL_START_DATE in DATE
,P_ADJUSTED_SVC_DATE in DATE
,P_BASE_SALARY in NUMBER
,P_BASE_SALARY_CHANGE_DATE in DATE
,P_PAYROLL_NAME in VARCHAR2
,P_PERFORMANCE_RATING in VARCHAR2
,P_PERFORMANCE_RATING_TYPE in VARCHAR2
,P_PERFORMANCE_RATING_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_JOB_ID in NUMBER
,P_GRADE_ID in NUMBER
,P_POSITION_ID in NUMBER
,P_PEOPLE_GROUP_ID in NUMBER
,P_SOFT_CODING_KEYFLEX_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_PAY_RATE_ID in NUMBER
,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
,P_FREQUENCY in VARCHAR2
,P_GRADE_ANNULIZATION_FACTOR in NUMBER
,P_PAY_ANNULIZATION_FACTOR in NUMBER
,P_GRD_MIN_VAL in NUMBER
,P_GRD_MAX_VAL in NUMBER
,P_GRD_MID_POINT in NUMBER
,P_GRD_QUARTILE in VARCHAR2
,P_GRD_COMPARATIO in NUMBER
,P_EMP_CATEGORY in VARCHAR2
,P_CHANGE_REASON in VARCHAR2
,P_NORMAL_HOURS in NUMBER
,P_EMAIL_ADDRESS in VARCHAR2
,P_BASE_SALARY_FREQUENCY in VARCHAR2
,P_NEW_ASSGN_OVN in NUMBER
,P_NEW_PERF_EVENT_ID in NUMBER
,P_NEW_PERF_REVIEW_ID in NUMBER
,P_POST_PROCESS_STAT_CD in VARCHAR2
,P_FEEDBACK_RATING in VARCHAR2
,P_FEEDBACK_COMMENTS in VARCHAR2
,P_CUSTOM_SEGMENT1 in VARCHAR2
,P_CUSTOM_SEGMENT2 in VARCHAR2
,P_CUSTOM_SEGMENT3 in VARCHAR2
,P_CUSTOM_SEGMENT4 in VARCHAR2
,P_CUSTOM_SEGMENT5 in VARCHAR2
,P_CUSTOM_SEGMENT6 in VARCHAR2
,P_CUSTOM_SEGMENT7 in VARCHAR2
,P_CUSTOM_SEGMENT8 in VARCHAR2
,P_CUSTOM_SEGMENT9 in VARCHAR2
,P_CUSTOM_SEGMENT10 in VARCHAR2
,P_CUSTOM_SEGMENT11 in NUMBER
,P_CUSTOM_SEGMENT12 in NUMBER
,P_CUSTOM_SEGMENT13 in NUMBER
,P_CUSTOM_SEGMENT14 in NUMBER
,P_CUSTOM_SEGMENT15 in NUMBER
,P_CUSTOM_SEGMENT16 in NUMBER
,P_CUSTOM_SEGMENT17 in NUMBER
,P_CUSTOM_SEGMENT18 in NUMBER
,P_CUSTOM_SEGMENT19 in NUMBER
,P_CUSTOM_SEGMENT20 in NUMBER
,P_ASS_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ASS_ATTRIBUTE1 in VARCHAR2
,P_ASS_ATTRIBUTE2 in VARCHAR2
,P_ASS_ATTRIBUTE3 in VARCHAR2
,P_ASS_ATTRIBUTE4 in VARCHAR2
,P_ASS_ATTRIBUTE5 in VARCHAR2
,P_ASS_ATTRIBUTE6 in VARCHAR2
,P_ASS_ATTRIBUTE7 in VARCHAR2
,P_ASS_ATTRIBUTE8 in VARCHAR2
,P_ASS_ATTRIBUTE9 in VARCHAR2
,P_ASS_ATTRIBUTE10 in VARCHAR2
,P_ASS_ATTRIBUTE11 in VARCHAR2
,P_ASS_ATTRIBUTE12 in VARCHAR2
,P_ASS_ATTRIBUTE13 in VARCHAR2
,P_ASS_ATTRIBUTE14 in VARCHAR2
,P_ASS_ATTRIBUTE15 in VARCHAR2
,P_ASS_ATTRIBUTE16 in VARCHAR2
,P_ASS_ATTRIBUTE17 in VARCHAR2
,P_ASS_ATTRIBUTE18 in VARCHAR2
,P_ASS_ATTRIBUTE19 in VARCHAR2
,P_ASS_ATTRIBUTE20 in VARCHAR2
,P_ASS_ATTRIBUTE21 in VARCHAR2
,P_ASS_ATTRIBUTE22 in VARCHAR2
,P_ASS_ATTRIBUTE23 in VARCHAR2
,P_ASS_ATTRIBUTE24 in VARCHAR2
,P_ASS_ATTRIBUTE25 in VARCHAR2
,P_ASS_ATTRIBUTE26 in VARCHAR2
,P_ASS_ATTRIBUTE27 in VARCHAR2
,P_ASS_ATTRIBUTE28 in VARCHAR2
,P_ASS_ATTRIBUTE29 in VARCHAR2
,P_ASS_ATTRIBUTE30 in VARCHAR2
,P_WS_COMMENTS in VARCHAR2
,P_PEOPLE_GROUP_NAME in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT1 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT2 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT3 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT4 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT5 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT6 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT7 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT8 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT9 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT10 in VARCHAR2
,P_PEOPLE_GROUP_SEGMENT11 in VARCHAR2
,P_CPI_ATTRIBUTE_CATEGORY in VARCHAR2
,P_CPI_ATTRIBUTE1 in VARCHAR2
,P_CPI_ATTRIBUTE2 in VARCHAR2
,P_CPI_ATTRIBUTE3 in VARCHAR2
,P_CPI_ATTRIBUTE4 in VARCHAR2
,P_CPI_ATTRIBUTE5 in VARCHAR2
,P_CPI_ATTRIBUTE6 in VARCHAR2
,P_CPI_ATTRIBUTE7 in VARCHAR2
,P_CPI_ATTRIBUTE8 in VARCHAR2
,P_CPI_ATTRIBUTE9 in VARCHAR2
,P_CPI_ATTRIBUTE10 in VARCHAR2
,P_CPI_ATTRIBUTE11 in VARCHAR2
,P_CPI_ATTRIBUTE12 in VARCHAR2
,P_CPI_ATTRIBUTE13 in VARCHAR2
,P_CPI_ATTRIBUTE14 in VARCHAR2
,P_CPI_ATTRIBUTE15 in VARCHAR2
,P_CPI_ATTRIBUTE16 in VARCHAR2
,P_CPI_ATTRIBUTE17 in VARCHAR2
,P_CPI_ATTRIBUTE18 in VARCHAR2
,P_CPI_ATTRIBUTE19 in VARCHAR2
,P_CPI_ATTRIBUTE20 in VARCHAR2
,P_CPI_ATTRIBUTE21 in VARCHAR2
,P_CPI_ATTRIBUTE22 in VARCHAR2
,P_CPI_ATTRIBUTE23 in VARCHAR2
,P_CPI_ATTRIBUTE24 in VARCHAR2
,P_CPI_ATTRIBUTE25 in VARCHAR2
,P_CPI_ATTRIBUTE26 in VARCHAR2
,P_CPI_ATTRIBUTE27 in VARCHAR2
,P_CPI_ATTRIBUTE28 in VARCHAR2
,P_CPI_ATTRIBUTE29 in VARCHAR2
,P_CPI_ATTRIBUTE30 in VARCHAR2
,P_FEEDBACK_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: BEN_CWB_PERSON_INFO_BK2.UPDATE_PERSON_INFO_B', 10);

Line: 319

hr_utility.set_location(' Leaving: BEN_CWB_PERSON_INFO_BK2.UPDATE_PERSON_INFO_B', 20);

Line: 320

end UPDATE_PERSON_INFO_B;