[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_program_update_date in date default null
,p_attribute_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_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_analysis_criteria_id in out nocopy number
,p_person_analysis_id out nocopy number
,p_pea_object_version_number out nocopy number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'create_sit';
l_program_update_date per_person_analyses.program_update_date%TYPE;
select 1
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
select 1
from per_special_info_types pc,
fnd_id_flex_structures fs
where fs.id_flex_num = pc.id_flex_num
and fs.id_flex_code = 'PEA'
and pc.enabled_flag = 'Y'
and pc.business_group_id + 0 = p_business_group_id
and pc.id_flex_num = p_id_flex_num;
select 1
from fnd_id_flex_structures fs
where fs.id_flex_num = p_id_flex_num
and fs.id_flex_code = 'PEA';
select 1
from per_special_info_types pc
where pc.business_group_id + 0 = p_business_group_id
and pc.id_flex_num = p_id_flex_num;
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from per_analysis_criteria
where analysis_criteria_id = l_analysis_criteria_id;
l_program_update_date := trunc(p_program_update_date);
,p_program_update_date => l_program_update_date
,p_attribute_category => p_attribute_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_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_program_update_date => l_program_update_date
,p_attribute_category => p_attribute_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_object_version_number => l_object_version_number
,p_person_analysis_id => l_person_analysis_id
);
,p_program_update_date => l_program_update_date
,p_attribute_category => p_attribute_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_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_analysis_criteria_id => l_analysis_criteria_id
,p_person_analysis_id => l_person_analysis_id
,p_pea_object_version_number => l_object_version_number
);
procedure update_sit
(p_validate in boolean default false
,p_person_analysis_id in number
,p_pea_object_version_number in out nocopy number
,p_comments in varchar2 default hr_api.g_varchar2
,p_date_from in date default hr_api.g_date
,p_date_to in date default hr_api.g_date
,p_request_id in number default hr_api.g_number
,p_program_application_id in number default hr_api.g_number
,p_program_id in number default hr_api.g_number
,p_program_update_date in date default hr_api.g_date
,p_attribute_category in varchar2 default hr_api.g_varchar2
,p_attribute1 in varchar2 default hr_api.g_varchar2
,p_attribute2 in varchar2 default hr_api.g_varchar2
,p_attribute3 in varchar2 default hr_api.g_varchar2
,p_attribute4 in varchar2 default hr_api.g_varchar2
,p_attribute5 in varchar2 default hr_api.g_varchar2
,p_attribute6 in varchar2 default hr_api.g_varchar2
,p_attribute7 in varchar2 default hr_api.g_varchar2
,p_attribute8 in varchar2 default hr_api.g_varchar2
,p_attribute9 in varchar2 default hr_api.g_varchar2
,p_attribute10 in varchar2 default hr_api.g_varchar2
,p_attribute11 in varchar2 default hr_api.g_varchar2
,p_attribute12 in varchar2 default hr_api.g_varchar2
,p_attribute13 in varchar2 default hr_api.g_varchar2
,p_attribute14 in varchar2 default hr_api.g_varchar2
,p_attribute15 in varchar2 default hr_api.g_varchar2
,p_attribute16 in varchar2 default hr_api.g_varchar2
,p_attribute17 in varchar2 default hr_api.g_varchar2
,p_attribute18 in varchar2 default hr_api.g_varchar2
,p_attribute19 in varchar2 default hr_api.g_varchar2
,p_attribute20 in varchar2 default hr_api.g_varchar2
,p_segment1 in varchar2 default hr_api.g_varchar2
,p_segment2 in varchar2 default hr_api.g_varchar2
,p_segment3 in varchar2 default hr_api.g_varchar2
,p_segment4 in varchar2 default hr_api.g_varchar2
,p_segment5 in varchar2 default hr_api.g_varchar2
,p_segment6 in varchar2 default hr_api.g_varchar2
,p_segment7 in varchar2 default hr_api.g_varchar2
,p_segment8 in varchar2 default hr_api.g_varchar2
,p_segment9 in varchar2 default hr_api.g_varchar2
,p_segment10 in varchar2 default hr_api.g_varchar2
,p_segment11 in varchar2 default hr_api.g_varchar2
,p_segment12 in varchar2 default hr_api.g_varchar2
,p_segment13 in varchar2 default hr_api.g_varchar2
,p_segment14 in varchar2 default hr_api.g_varchar2
,p_segment15 in varchar2 default hr_api.g_varchar2
,p_segment16 in varchar2 default hr_api.g_varchar2
,p_segment17 in varchar2 default hr_api.g_varchar2
,p_segment18 in varchar2 default hr_api.g_varchar2
,p_segment19 in varchar2 default hr_api.g_varchar2
,p_segment20 in varchar2 default hr_api.g_varchar2
,p_segment21 in varchar2 default hr_api.g_varchar2
,p_segment22 in varchar2 default hr_api.g_varchar2
,p_segment23 in varchar2 default hr_api.g_varchar2
,p_segment24 in varchar2 default hr_api.g_varchar2
,p_segment25 in varchar2 default hr_api.g_varchar2
,p_segment26 in varchar2 default hr_api.g_varchar2
,p_segment27 in varchar2 default hr_api.g_varchar2
,p_segment28 in varchar2 default hr_api.g_varchar2
,p_segment29 in varchar2 default hr_api.g_varchar2
,p_segment30 in varchar2 default hr_api.g_varchar2
,p_concat_segments in varchar2 default hr_api.g_varchar2
,p_analysis_criteria_id in out nocopy number
) is
--
--
l_proc varchar2(72) := g_package||'update_sit';
l_program_update_date per_person_analyses.program_update_date%TYPE;
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from per_analysis_criteria
where analysis_criteria_id = l_analysis_criteria_id;
select id_flex_num
from per_person_analyses
where person_analysis_id = p_person_analysis_id;
savepoint update_sit;
l_program_update_date := trunc(p_program_update_date);
hr_sit_bk2.update_sit_b
(p_person_analysis_id => p_person_analysis_id
,p_pea_object_version_number => p_pea_object_version_number
,p_comments => p_comments
,p_date_from => l_date_from
,p_date_to => l_date_to
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => l_program_update_date
,p_attribute_category => p_attribute_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_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_module_name => 'UPDATE_SIT'
,p_hook_type => 'BP'
);
,p_program_update_date => l_program_update_date
,p_attribute_category => p_attribute_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_object_version_number => l_object_version_number
);
hr_sit_bk2.update_sit_a
(p_person_analysis_id => p_person_analysis_id
,p_pea_object_version_number => l_object_version_number
,p_comments => p_comments
,p_date_from => l_date_from
,p_date_to => l_date_to
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => l_program_update_date
,p_attribute_category => p_attribute_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_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_analysis_criteria_id => l_analysis_criteria_id
);
(p_module_name => 'UPDATE_SIT'
,p_hook_type => 'AP'
);
ROLLBACK TO update_sit;
ROLLBACK TO update_sit;
end update_sit;
procedure delete_sit
(p_validate in boolean default false
,p_person_analysis_id in number
,p_pea_object_version_number in number
) IS
--
l_proc varchar2(72) := g_package||'delete_sit';
savepoint delete_sit;
hr_sit_bk3.delete_sit_b
(p_person_analysis_id => p_person_analysis_id
,p_pea_object_version_number => p_pea_object_version_number
);
(p_module_name => 'DELETE_SIT'
,p_hook_type => 'BP'
);
hr_sit_bk3.delete_sit_a
(p_person_analysis_id => p_person_analysis_id
,p_pea_object_version_number => p_pea_object_version_number
);
(p_module_name => 'DELETE_SIT'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_sit;
ROLLBACK TO delete_sit;
END delete_sit;