APPS.HR_POSITION_BK2 SQL Statements

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

Line: 5

procedure UPDATE_POSITION_A
(P_POSITION_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_AVAILABILITY_STATUS_ID in NUMBER
,P_ENTRY_STEP_ID in NUMBER
,P_ENTRY_GRADE_RULE_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_PAY_FREQ_PAYROLL_ID in NUMBER
,P_POSITION_DEFINITION_ID in NUMBER
,P_POSITION_TRANSACTION_ID in NUMBER
,P_PRIOR_POSITION_ID in NUMBER
,P_RELIEF_POSITION_ID in NUMBER
,P_ENTRY_GRADE_ID in NUMBER
,P_SUCCESSOR_POSITION_ID in NUMBER
,P_SUPERVISOR_POSITION_ID in NUMBER
,P_AMENDMENT_DATE in DATE
,P_AMENDMENT_RECOMMENDATION in VARCHAR2
,P_AMENDMENT_REF_NUMBER in VARCHAR2
,P_BARGAINING_UNIT_CD in VARCHAR2
,P_COMMENTS in LONG
,P_CURRENT_JOB_PROP_END_DATE in DATE
,P_CURRENT_ORG_PROP_END_DATE in DATE
,P_AVAIL_STATUS_PROP_END_DATE in DATE
,P_DATE_EFFECTIVE in DATE
,P_DATE_END in DATE
,P_EARLIEST_HIRE_DATE in DATE
,P_FILL_BY_DATE in DATE
,P_FREQUENCY in VARCHAR2
,P_FTE in NUMBER
,P_MAX_PERSONS in NUMBER
,P_NAME in VARCHAR2
,P_OVERLAP_PERIOD in NUMBER
,P_OVERLAP_UNIT_CD in VARCHAR2
,P_PAY_TERM_END_DAY_CD in VARCHAR2
,P_PAY_TERM_END_MONTH_CD in VARCHAR2
,P_PERMANENT_TEMPORARY_FLAG in VARCHAR2
,P_PERMIT_RECRUITMENT_FLAG in VARCHAR2
,P_POSITION_TYPE in VARCHAR2
,P_POSTING_DESCRIPTION in VARCHAR2
,P_PROBATION_PERIOD in NUMBER
,P_PROBATION_PERIOD_UNIT_CD in VARCHAR2
,P_REPLACEMENT_REQUIRED_FLAG in VARCHAR2
,P_REVIEW_FLAG in VARCHAR2
,P_SEASONAL_FLAG in VARCHAR2
,P_SECURITY_REQUIREMENTS in VARCHAR2
,P_STATUS in VARCHAR2
,P_TERM_START_DAY_CD in VARCHAR2
,P_TERM_START_MONTH_CD in VARCHAR2
,P_TIME_NORMAL_FINISH in VARCHAR2
,P_TIME_NORMAL_START in VARCHAR2
,P_UPDATE_SOURCE_CD in VARCHAR2
,P_WORKING_HOURS in NUMBER
,P_WORKS_COUNCIL_APPROVAL_FLAG in VARCHAR2
,P_WORK_PERIOD_TYPE_CD in VARCHAR2
,P_WORK_TERM_END_DAY_CD in VARCHAR2
,P_WORK_TERM_END_MONTH_CD in VARCHAR2
,P_PROPOSED_FTE_FOR_LAYOFF in NUMBER
,P_PROPOSED_DATE_FOR_LAYOFF in DATE
,P_PAY_BASIS_ID in NUMBER
,P_SUPERVISOR_ID in NUMBER
,P_INFORMATION1 in VARCHAR2
,P_INFORMATION2 in VARCHAR2
,P_INFORMATION3 in VARCHAR2
,P_INFORMATION4 in VARCHAR2
,P_INFORMATION5 in VARCHAR2
,P_INFORMATION6 in VARCHAR2
,P_INFORMATION7 in VARCHAR2
,P_INFORMATION8 in VARCHAR2
,P_INFORMATION9 in VARCHAR2
,P_INFORMATION10 in VARCHAR2
,P_INFORMATION11 in VARCHAR2
,P_INFORMATION12 in VARCHAR2
,P_INFORMATION13 in VARCHAR2
,P_INFORMATION14 in VARCHAR2
,P_INFORMATION15 in VARCHAR2
,P_INFORMATION16 in VARCHAR2
,P_INFORMATION17 in VARCHAR2
,P_INFORMATION18 in VARCHAR2
,P_INFORMATION19 in VARCHAR2
,P_INFORMATION20 in VARCHAR2
,P_INFORMATION21 in VARCHAR2
,P_INFORMATION22 in VARCHAR2
,P_INFORMATION23 in VARCHAR2
,P_INFORMATION24 in VARCHAR2
,P_INFORMATION25 in VARCHAR2
,P_INFORMATION26 in VARCHAR2
,P_INFORMATION27 in VARCHAR2
,P_INFORMATION28 in VARCHAR2
,P_INFORMATION29 in VARCHAR2
,P_INFORMATION30 in VARCHAR2
,P_INFORMATION_CATEGORY in VARCHAR2
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_ATTRIBUTE11 in VARCHAR2
,P_ATTRIBUTE12 in VARCHAR2
,P_ATTRIBUTE13 in VARCHAR2
,P_ATTRIBUTE14 in VARCHAR2
,P_ATTRIBUTE15 in VARCHAR2
,P_ATTRIBUTE16 in VARCHAR2
,P_ATTRIBUTE17 in VARCHAR2
,P_ATTRIBUTE18 in VARCHAR2
,P_ATTRIBUTE19 in VARCHAR2
,P_ATTRIBUTE20 in VARCHAR2
,P_ATTRIBUTE21 in VARCHAR2
,P_ATTRIBUTE22 in VARCHAR2
,P_ATTRIBUTE23 in VARCHAR2
,P_ATTRIBUTE24 in VARCHAR2
,P_ATTRIBUTE25 in VARCHAR2
,P_ATTRIBUTE26 in VARCHAR2
,P_ATTRIBUTE27 in VARCHAR2
,P_ATTRIBUTE28 in VARCHAR2
,P_ATTRIBUTE29 in VARCHAR2
,P_ATTRIBUTE30 in VARCHAR2
,P_ATTRIBUTE_CATEGORY in VARCHAR2
,P_SEGMENT1 in VARCHAR2
,P_SEGMENT2 in VARCHAR2
,P_SEGMENT3 in VARCHAR2
,P_SEGMENT4 in VARCHAR2
,P_SEGMENT5 in VARCHAR2
,P_SEGMENT6 in VARCHAR2
,P_SEGMENT7 in VARCHAR2
,P_SEGMENT8 in VARCHAR2
,P_SEGMENT9 in VARCHAR2
,P_SEGMENT10 in VARCHAR2
,P_SEGMENT11 in VARCHAR2
,P_SEGMENT12 in VARCHAR2
,P_SEGMENT13 in VARCHAR2
,P_SEGMENT14 in VARCHAR2
,P_SEGMENT15 in VARCHAR2
,P_SEGMENT16 in VARCHAR2
,P_SEGMENT17 in VARCHAR2
,P_SEGMENT18 in VARCHAR2
,P_SEGMENT19 in VARCHAR2
,P_SEGMENT20 in VARCHAR2
,P_SEGMENT21 in VARCHAR2
,P_SEGMENT22 in VARCHAR2
,P_SEGMENT23 in VARCHAR2
,P_SEGMENT24 in VARCHAR2
,P_SEGMENT25 in VARCHAR2
,P_SEGMENT26 in VARCHAR2
,P_SEGMENT27 in VARCHAR2
,P_SEGMENT28 in VARCHAR2
,P_SEGMENT29 in VARCHAR2
,P_SEGMENT30 in VARCHAR2
,P_CONCAT_SEGMENTS in VARCHAR2
,P_REQUEST_ID in NUMBER
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_LANGUAGE_CODE in VARCHAR2
)is
l_commit_unit_number number;

Line: 171

hr_utility.set_location('Entering: HR_POSITION_BK2.UPDATE_POSITION_A', 10);

Line: 177

GHR_UTILITY.update_nfc_eit
(P_POSITION_ID => P_POSITION_ID
,P_SEGMENT1 => P_SEGMENT1
,P_SEGMENT2 => P_SEGMENT2
,P_SEGMENT3 => P_SEGMENT3
,P_SEGMENT4 => P_SEGMENT4
,P_SEGMENT5 => P_SEGMENT5
,P_SEGMENT6 => P_SEGMENT6
,P_SEGMENT7 => P_SEGMENT7
,P_SEGMENT8 => P_SEGMENT8
,P_SEGMENT9 => P_SEGMENT9
,P_SEGMENT10 => P_SEGMENT10
,P_SEGMENT11 => P_SEGMENT11
,P_SEGMENT12 => P_SEGMENT12
,P_SEGMENT13 => P_SEGMENT13
,P_SEGMENT14 => P_SEGMENT14
,P_SEGMENT15 => P_SEGMENT15
,P_SEGMENT16 => P_SEGMENT16
,P_SEGMENT17 => P_SEGMENT17
,P_SEGMENT18 => P_SEGMENT18
,P_SEGMENT19 => P_SEGMENT19
,P_SEGMENT20 => P_SEGMENT20
,P_SEGMENT21 => P_SEGMENT21
,P_SEGMENT22 => P_SEGMENT22
,P_SEGMENT23 => P_SEGMENT23
,P_SEGMENT24 => P_SEGMENT24
,P_SEGMENT25 => P_SEGMENT25
,P_SEGMENT26 => P_SEGMENT26
,P_SEGMENT27 => P_SEGMENT27
,P_SEGMENT28 => P_SEGMENT28
,P_SEGMENT29 => P_SEGMENT29
,P_SEGMENT30 => P_SEGMENT30
,P_INFORMATION6 => P_INFORMATION6
,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
,P_LANGUAGE_CODE => P_LANGUAGE_CODE
);

Line: 216

hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_POSITION', 'AP');

Line: 217

hr_utility.set_location(' Leaving: HR_POSITION_BK2.UPDATE_POSITION_A', 20);

Line: 218

end UPDATE_POSITION_A;

Line: 219

procedure UPDATE_POSITION_B
(P_POSITION_ID in NUMBER
,P_AVAILABILITY_STATUS_ID in NUMBER
,P_ENTRY_STEP_ID in NUMBER
,P_ENTRY_GRADE_RULE_ID in NUMBER
,P_LOCATION_ID in NUMBER
,P_PAY_FREQ_PAYROLL_ID in NUMBER
,P_POSITION_DEFINITION_ID in NUMBER
,P_POSITION_TRANSACTION_ID in NUMBER
,P_PRIOR_POSITION_ID in NUMBER
,P_RELIEF_POSITION_ID in NUMBER
,P_ENTRY_GRADE_ID in NUMBER
,P_SUCCESSOR_POSITION_ID in NUMBER
,P_SUPERVISOR_POSITION_ID in NUMBER
,P_AMENDMENT_DATE in DATE
,P_AMENDMENT_RECOMMENDATION in VARCHAR2
,P_AMENDMENT_REF_NUMBER in VARCHAR2
,P_BARGAINING_UNIT_CD in VARCHAR2
,P_COMMENTS in LONG
,P_CURRENT_JOB_PROP_END_DATE in DATE
,P_CURRENT_ORG_PROP_END_DATE in DATE
,P_AVAIL_STATUS_PROP_END_DATE in DATE
,P_DATE_EFFECTIVE in DATE
,P_DATE_END in DATE
,P_EARLIEST_HIRE_DATE in DATE
,P_FILL_BY_DATE in DATE
,P_FREQUENCY in VARCHAR2
,P_FTE in NUMBER
,P_MAX_PERSONS in NUMBER
,P_NAME in VARCHAR2
,P_OVERLAP_PERIOD in NUMBER
,P_OVERLAP_UNIT_CD in VARCHAR2
,P_PAY_TERM_END_DAY_CD in VARCHAR2
,P_PAY_TERM_END_MONTH_CD in VARCHAR2
,P_PERMANENT_TEMPORARY_FLAG in VARCHAR2
,P_PERMIT_RECRUITMENT_FLAG in VARCHAR2
,P_POSITION_TYPE in VARCHAR2
,P_POSTING_DESCRIPTION in VARCHAR2
,P_PROBATION_PERIOD in NUMBER
,P_PROBATION_PERIOD_UNIT_CD in VARCHAR2
,P_REPLACEMENT_REQUIRED_FLAG in VARCHAR2
,P_REVIEW_FLAG in VARCHAR2
,P_SEASONAL_FLAG in VARCHAR2
,P_SECURITY_REQUIREMENTS in VARCHAR2
,P_STATUS in VARCHAR2
,P_TERM_START_DAY_CD in VARCHAR2
,P_TERM_START_MONTH_CD in VARCHAR2
,P_TIME_NORMAL_FINISH in VARCHAR2
,P_TIME_NORMAL_START in VARCHAR2
,P_UPDATE_SOURCE_CD in VARCHAR2
,P_WORKING_HOURS in NUMBER
,P_WORKS_COUNCIL_APPROVAL_FLAG in VARCHAR2
,P_WORK_PERIOD_TYPE_CD in VARCHAR2
,P_WORK_TERM_END_DAY_CD in VARCHAR2
,P_WORK_TERM_END_MONTH_CD in VARCHAR2
,P_PROPOSED_FTE_FOR_LAYOFF in NUMBER
,P_PROPOSED_DATE_FOR_LAYOFF in DATE
,P_PAY_BASIS_ID in NUMBER
,P_SUPERVISOR_ID in NUMBER
,P_INFORMATION1 in VARCHAR2
,P_INFORMATION2 in VARCHAR2
,P_INFORMATION3 in VARCHAR2
,P_INFORMATION4 in VARCHAR2
,P_INFORMATION5 in VARCHAR2
,P_INFORMATION6 in VARCHAR2
,P_INFORMATION7 in VARCHAR2
,P_INFORMATION8 in VARCHAR2
,P_INFORMATION9 in VARCHAR2
,P_INFORMATION10 in VARCHAR2
,P_INFORMATION11 in VARCHAR2
,P_INFORMATION12 in VARCHAR2
,P_INFORMATION13 in VARCHAR2
,P_INFORMATION14 in VARCHAR2
,P_INFORMATION15 in VARCHAR2
,P_INFORMATION16 in VARCHAR2
,P_INFORMATION17 in VARCHAR2
,P_INFORMATION18 in VARCHAR2
,P_INFORMATION19 in VARCHAR2
,P_INFORMATION20 in VARCHAR2
,P_INFORMATION21 in VARCHAR2
,P_INFORMATION22 in VARCHAR2
,P_INFORMATION23 in VARCHAR2
,P_INFORMATION24 in VARCHAR2
,P_INFORMATION25 in VARCHAR2
,P_INFORMATION26 in VARCHAR2
,P_INFORMATION27 in VARCHAR2
,P_INFORMATION28 in VARCHAR2
,P_INFORMATION29 in VARCHAR2
,P_INFORMATION30 in VARCHAR2
,P_INFORMATION_CATEGORY in VARCHAR2
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_ATTRIBUTE11 in VARCHAR2
,P_ATTRIBUTE12 in VARCHAR2
,P_ATTRIBUTE13 in VARCHAR2
,P_ATTRIBUTE14 in VARCHAR2
,P_ATTRIBUTE15 in VARCHAR2
,P_ATTRIBUTE16 in VARCHAR2
,P_ATTRIBUTE17 in VARCHAR2
,P_ATTRIBUTE18 in VARCHAR2
,P_ATTRIBUTE19 in VARCHAR2
,P_ATTRIBUTE20 in VARCHAR2
,P_ATTRIBUTE21 in VARCHAR2
,P_ATTRIBUTE22 in VARCHAR2
,P_ATTRIBUTE23 in VARCHAR2
,P_ATTRIBUTE24 in VARCHAR2
,P_ATTRIBUTE25 in VARCHAR2
,P_ATTRIBUTE26 in VARCHAR2
,P_ATTRIBUTE27 in VARCHAR2
,P_ATTRIBUTE28 in VARCHAR2
,P_ATTRIBUTE29 in VARCHAR2
,P_ATTRIBUTE30 in VARCHAR2
,P_ATTRIBUTE_CATEGORY in VARCHAR2
,P_SEGMENT1 in VARCHAR2
,P_SEGMENT2 in VARCHAR2
,P_SEGMENT3 in VARCHAR2
,P_SEGMENT4 in VARCHAR2
,P_SEGMENT5 in VARCHAR2
,P_SEGMENT6 in VARCHAR2
,P_SEGMENT7 in VARCHAR2
,P_SEGMENT8 in VARCHAR2
,P_SEGMENT9 in VARCHAR2
,P_SEGMENT10 in VARCHAR2
,P_SEGMENT11 in VARCHAR2
,P_SEGMENT12 in VARCHAR2
,P_SEGMENT13 in VARCHAR2
,P_SEGMENT14 in VARCHAR2
,P_SEGMENT15 in VARCHAR2
,P_SEGMENT16 in VARCHAR2
,P_SEGMENT17 in VARCHAR2
,P_SEGMENT18 in VARCHAR2
,P_SEGMENT19 in VARCHAR2
,P_SEGMENT20 in VARCHAR2
,P_SEGMENT21 in VARCHAR2
,P_SEGMENT22 in VARCHAR2
,P_SEGMENT23 in VARCHAR2
,P_SEGMENT24 in VARCHAR2
,P_SEGMENT25 in VARCHAR2
,P_SEGMENT26 in VARCHAR2
,P_SEGMENT27 in VARCHAR2
,P_SEGMENT28 in VARCHAR2
,P_SEGMENT29 in VARCHAR2
,P_SEGMENT30 in VARCHAR2
,P_CONCAT_SEGMENTS in VARCHAR2
,P_REQUEST_ID in NUMBER
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_LANGUAGE_CODE in VARCHAR2
)is
l_commit_unit_number number;

Line: 383

hr_utility.set_location('Entering: HR_POSITION_BK2.UPDATE_POSITION_B', 10);

Line: 427

hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_POSITION', 'BP');

Line: 428

hr_utility.set_location(' Leaving: HR_POSITION_BK2.UPDATE_POSITION_B', 20);

Line: 429

end UPDATE_POSITION_B;