The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
assignment_id,
effective_start_date,
effective_end_date,
business_group_id,
recruiter_id,
grade_id,
position_id,
job_id,
assignment_status_type_id,
payroll_id,
location_id,
person_referred_by_id,
supervisor_id,
special_ceiling_step_id,
person_id,
recruitment_activity_id,
source_organization_id,
organization_id,
people_group_id,
soft_coding_keyflex_id,
vacancy_id,
pay_basis_id,
assignment_sequence,
assignment_type,
primary_flag,
application_id,
assignment_number,
change_reason,
comment_id,
null,
date_probation_end,
default_code_comb_id,
employment_category,
frequency,
internal_address_line,
manager_flag,
normal_hours,
perf_review_period,
perf_review_period_frequency,
period_of_service_id,
probation_period,
probation_unit,
sal_review_period,
sal_review_period_frequency,
set_of_books_id,
source_type,
time_normal_finish,
time_normal_start,
bargaining_unit_code,
labour_union_member_flag,
hourly_salaried_code,
request_id,
program_application_id,
program_id,
program_update_date,
ass_attribute_category,
ass_attribute1,
ass_attribute2,
ass_attribute3,
ass_attribute4,
ass_attribute5,
ass_attribute6,
ass_attribute7,
ass_attribute8,
ass_attribute9,
ass_attribute10,
ass_attribute11,
ass_attribute12,
ass_attribute13,
ass_attribute14,
ass_attribute15,
ass_attribute16,
ass_attribute17,
ass_attribute18,
ass_attribute19,
ass_attribute20,
ass_attribute21,
ass_attribute22,
ass_attribute23,
ass_attribute24,
ass_attribute25,
ass_attribute26,
ass_attribute27,
ass_attribute28,
ass_attribute29,
ass_attribute30,
title,
object_version_number ,
contract_id,
establishment_id,
collective_agreement_id,
cagr_grade_def_id,
cagr_id_flex_num,
notice_period,
notice_period_uom,
employee_category,
work_at_home,
job_post_source_name,
posting_content_id,
period_of_placement_date_start,
vendor_id,
vendor_employee_number,
vendor_assignment_number,
assignment_category,
project_title,
applicant_rank,
grade_ladder_pgm_id,
supervisor_assignment_id,
vendor_site_id,
po_header_id,
po_line_id,
projected_assignment_end
from per_all_assignments_f
where assignment_id = p_assignment_id
and p_effective_date between effective_start_date
and effective_end_date;
p_delete out nocopy boolean,
p_future_change out nocopy boolean,
p_delete_next_change out nocopy boolean) is
--
l_proc varchar2(72) := g_package||'find_dt_del_modes';
select asg.payroll_id,
asg.person_id
from per_all_assignments_f asg
where asg.assignment_id = p_base_key_value
and p_effective_date between asg.effective_start_date
and asg.effective_end_date;
p_delete => p_delete,
p_future_change => p_future_change,
p_delete_next_change => p_delete_next_change);
p_update out nocopy boolean,
p_update_override out nocopy boolean,
p_update_change_insert out nocopy boolean) is
--
Begin
--
-- Call the corresponding datetrack api
--
dt_api.find_dt_upd_modes
(p_effective_date => p_effective_date,
p_base_table_name => 'per_all_assignments_f',
p_base_key_column => 'assignment_id',
p_base_key_value => p_base_key_value,
p_correction => p_correction,
p_update => p_update,
p_update_override => p_update_override,
p_update_change_insert => p_update_change_insert);
update per_all_assignments_f asg
set asg.effective_end_date = p_new_effective_end_date,
asg.object_version_number = l_object_version_number
where asg.assignment_id = p_base_key_value
and p_effective_date between asg.effective_start_date
and asg.effective_end_date;
select
assignment_id,
effective_start_date,
effective_end_date,
business_group_id,
recruiter_id,
grade_id,
position_id,
job_id,
assignment_status_type_id,
payroll_id,
location_id,
person_referred_by_id,
supervisor_id,
special_ceiling_step_id,
person_id,
recruitment_activity_id,
source_organization_id,
organization_id,
people_group_id,
soft_coding_keyflex_id,
vacancy_id,
pay_basis_id,
assignment_sequence,
assignment_type,
primary_flag,
application_id,
assignment_number,
change_reason,
comment_id,
null,
date_probation_end,
default_code_comb_id,
employment_category,
frequency,
internal_address_line,
manager_flag,
normal_hours,
perf_review_period,
perf_review_period_frequency,
period_of_service_id,
probation_period,
probation_unit,
sal_review_period,
sal_review_period_frequency,
set_of_books_id,
source_type,
time_normal_finish,
time_normal_start,
bargaining_unit_code,
labour_union_member_flag,
hourly_salaried_code,
request_id,
program_application_id,
program_id,
program_update_date,
ass_attribute_category,
ass_attribute1,
ass_attribute2,
ass_attribute3,
ass_attribute4,
ass_attribute5,
ass_attribute6,
ass_attribute7,
ass_attribute8,
ass_attribute9,
ass_attribute10,
ass_attribute11,
ass_attribute12,
ass_attribute13,
ass_attribute14,
ass_attribute15,
ass_attribute16,
ass_attribute17,
ass_attribute18,
ass_attribute19,
ass_attribute20,
ass_attribute21,
ass_attribute22,
ass_attribute23,
ass_attribute24,
ass_attribute25,
ass_attribute26,
ass_attribute27,
ass_attribute28,
ass_attribute29,
ass_attribute30,
title,
object_version_number,
contract_id,
establishment_id,
collective_agreement_id,
cagr_grade_def_id,
cagr_id_flex_num,
notice_period,
notice_period_uom,
employee_category,
work_at_home,
job_post_source_name,
posting_content_id,
period_of_placement_date_start,
vendor_id,
vendor_employee_number,
vendor_assignment_number,
assignment_category,
project_title,
applicant_rank,
grade_ladder_pgm_id,
supervisor_assignment_id,
vendor_site_id,
po_header_id,
po_line_id,
projected_assignment_end
from per_all_assignments_f
where assignment_id = p_assignment_id
and p_effective_date between effective_start_date
and effective_end_date
for update nowait;
select hc.comment_text
from hr_comments hc
where hc.comment_id = per_asg_shd.g_old_rec.comment_id;
If (p_datetrack_mode <> 'INSERT') then
--
-- We must select and lock the current row.
--
Open C_Sel1;
(p_datetrack_mode = 'UPDATE' or
p_datetrack_mode = 'CORRECTION' or
p_datetrack_mode = 'UPDATE_OVERRIDE' or
p_datetrack_mode = 'UPDATE_CHANGE_INSERT')) then
Open C_Sel3;
p_program_update_date in date,
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_title in varchar2,
p_object_version_number in number,
p_contract_id in number,
p_establishment_id in number,
p_collective_agreement_id in number,
p_cagr_grade_def_id in number,
p_cagr_id_flex_num in number,
p_notice_period in number,
p_notice_period_uom in varchar2,
p_employee_category in varchar2,
p_work_at_home in varchar2,
p_job_post_source_name in varchar2,
p_posting_content_id in number,
p_placement_date_start in date,
p_vendor_id in number,
p_vendor_employee_number in varchar2,
p_vendor_assignment_number in varchar2,
p_assignment_category in varchar2,
p_project_title in varchar2,
p_applicant_rank in number,
p_grade_ladder_pgm_id in number,
p_supervisor_assignment_id in number,
p_vendor_site_id in number,
p_po_header_id in number,
p_po_line_id in number,
p_projected_assignment_end in date
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.program_update_date := p_program_update_date;