[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ori.org_information4 seq_location
FROM hr_organization_information ori
WHERE ori.organization_id = p_business_group_id
AND ori.org_information_context = 'GHR_US_ORG_INFORMATION';
select position_structure id_flex_num
from per_business_groups
where business_group_id = p_business_group_id;
l_stmt := 'SELECT MAX(TO_NUMBER('||p_seq_location||')) max_seq '||
'FROM per_position_definitions pde WHERE id_flex_num= '||l_id_flex_num;
l_stmt := l_stmt||' AND EXISTS (SELECT 1 FROM per_positions pos'
||' WHERE pde.position_definition_id = pos.position_definition_id)';
,p_update_source_cd in varchar2 default null
,p_working_hours in number default null
,p_works_council_approval_flag in varchar2 default null
,p_work_period_type_cd in varchar2 default null
,p_work_term_end_day_cd in varchar2 default null
,p_work_term_end_month_cd in varchar2 default null
,p_proposed_fte_for_layoff in number default null
,p_proposed_date_for_layoff in date default null
,p_pay_basis_id in number default null
,p_supervisor_id in number default null
,p_information1 in varchar2 default null
,p_information2 in varchar2 default null
,p_information3 in varchar2 default null
,p_information4 in varchar2 default null
,p_information5 in varchar2 default null
,p_information6 in varchar2 default null
,p_information7 in varchar2 default null
,p_information8 in varchar2 default null
,p_information9 in varchar2 default null
,p_information10 in varchar2 default null
,p_information11 in varchar2 default null
,p_information12 in varchar2 default null
,p_information13 in varchar2 default null
,p_information14 in varchar2 default null
,p_information15 in varchar2 default null
,p_information16 in varchar2 default null
,p_information17 in varchar2 default null
,p_information18 in varchar2 default null
,p_information19 in varchar2 default null
,p_information20 in varchar2 default null
,p_information21 in varchar2 default null
,p_information22 in varchar2 default null
,p_information23 in varchar2 default null
,p_information24 in varchar2 default null
,p_information25 in varchar2 default null
,p_information26 in varchar2 default null
,p_information27 in varchar2 default null
,p_information28 in varchar2 default null
,p_information29 in varchar2 default null
,p_information30 in varchar2 default null
,p_information_category in varchar2 default null
,p_attribute1 in varchar2 default null
,p_attribute2 in varchar2 default null
,p_attribute3 in varchar2 default null
,p_attribute4 in varchar2 default null
,p_attribute5 in varchar2 default null
,p_attribute6 in varchar2 default null
,p_attribute7 in varchar2 default null
,p_attribute8 in varchar2 default null
,p_attribute9 in varchar2 default null
,p_attribute10 in varchar2 default null
,p_attribute11 in varchar2 default null
,p_attribute12 in varchar2 default null
,p_attribute13 in varchar2 default null
,p_attribute14 in varchar2 default null
,p_attribute15 in varchar2 default null
,p_attribute16 in varchar2 default null
,p_attribute17 in varchar2 default null
,p_attribute18 in varchar2 default null
,p_attribute19 in varchar2 default null
,p_attribute20 in varchar2 default null
,p_attribute21 in varchar2 default null
,p_attribute22 in varchar2 default null
,p_attribute23 in varchar2 default null
,p_attribute24 in varchar2 default null
,p_attribute25 in varchar2 default null
,p_attribute26 in varchar2 default null
,p_attribute27 in varchar2 default null
,p_attribute28 in varchar2 default null
,p_attribute29 in varchar2 default null
,p_attribute30 in varchar2 default null
,p_attribute_category in varchar2 default null
,p_segment1 in varchar2 default null
,p_segment2 in varchar2 default null
,p_segment3 in varchar2 default null
,p_segment4 in varchar2 default null
,p_segment5 in varchar2 default null
,p_segment6 in varchar2 default null
,p_segment7 in varchar2 default null
,p_segment8 in varchar2 default null
,p_segment9 in varchar2 default null
,p_segment10 in varchar2 default null
,p_segment11 in varchar2 default null
,p_segment12 in varchar2 default null
,p_segment13 in varchar2 default null
,p_segment14 in varchar2 default null
,p_segment15 in varchar2 default null
,p_segment16 in varchar2 default null
,p_segment17 in varchar2 default null
,p_segment18 in varchar2 default null
,p_segment19 in varchar2 default null
,p_segment20 in varchar2 default null
,p_segment21 in varchar2 default null
,p_segment22 in varchar2 default null
,p_segment23 in varchar2 default null
,p_segment24 in varchar2 default null
,p_segment25 in varchar2 default null
,p_segment26 in varchar2 default null
,p_segment27 in varchar2 default null
,p_segment28 in varchar2 default null
,p_segment29 in varchar2 default null
,p_segment30 in varchar2 default null
,p_concat_segments in varchar2 default null
,p_request_id in number default null
,p_program_application_id in number default null
,p_program_id in number default null
,p_program_update_date in date default null
) is
--
-- Declare cursors and local variables
--
l_position_id number;
select EFFECTIVE_DATE
from fnd_sessions where session_id = userenv('sessionid');
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_working_hours
,p_works_council_approval_flag => p_works_council_approval_flag
,p_work_period_type_cd => p_work_period_type_cd
,p_work_term_end_day_cd => p_work_term_end_day_cd
,p_work_term_end_month_cd => p_work_term_end_month_cd
,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
,p_proposed_date_for_layoff => p_proposed_date_for_layoff
,p_pay_basis_id => p_pay_basis_id
,p_supervisor_id => p_supervisor_id
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information29
,p_information29 => p_information29
,p_information30 => p_information30
,p_information_category => p_information_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute_category => p_attribute_category
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_segment21 => l_segment21
,p_segment22 => l_segment22
,p_segment23 => l_segment23
,p_segment24 => l_segment24
,p_segment25 => l_segment25
,p_segment26 => l_segment26
,p_segment27 => l_segment27
,p_segment28 => l_segment28
,p_segment29 => l_segment29
,p_segment30 => l_segment30
,p_concat_segments => p_concat_segments
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
);
UPDATE pqh_copy_entity_results
SET information1 = p_name
WHERE copy_entity_result_id = pqh_generic.g_result_id ;
SELECT pit.information_type
FROM per_position_info_types pit
WHERE pit.information_type NOT IN ('GHR_US_POS_MASS_ACTIONS','GHR_US_POS_OBLIG'
,'GHR_US_POSITION_DESCRIPTION');
SELECT poi.position_extra_info_id
FROM per_position_extra_info poi
WHERE poi.information_type = p_info_type
AND poi.position_id = p_source_posn_id;