[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_row(
p_row_id in out nocopy varchar2,
p_assignment_id in out nocopy number,
p_effective_start_date date,
p_effective_end_date date,
p_business_group_id number,
p_recruiter_id number,
p_grade_id number,
p_position_id number,
p_job_id number,
p_assignment_status_type_id number,
p_payroll_id number,
p_location_id number,
p_person_referred_by_id number,
p_supervisor_id number,
p_special_ceiling_step_id number,
p_person_id number,
p_recruitment_activity_id number,
p_source_organization_id number,
p_organization_id number,
p_people_group_id number,
p_soft_coding_keyflex_id number,
p_vacancy_id number,
p_assignment_sequence number,
p_assignment_type varchar2,
p_primary_flag varchar2,
p_application_id number,
p_assignment_number varchar2,
p_change_reason varchar2,
p_comment_id number,
p_date_probation_end date,
p_default_code_comb_id number,
p_frequency varchar2,
p_internal_address_line varchar2,
p_manager_flag varchar2,
p_normal_hours number,
p_period_of_service_id number,
p_probation_period number,
p_probation_unit varchar2,
p_set_of_books_id number,
p_source_type varchar2,
p_time_normal_finish varchar2,
p_time_normal_start varchar2,
p_request_id number,
p_program_application_id number,
p_program_id number,
p_program_update_date date,
p_ass_attribute_category varchar2,
p_ass_attribute1 varchar2,
p_ass_attribute2 varchar2,
p_ass_attribute3 varchar2,
p_ass_attribute4 varchar2,
p_ass_attribute5 varchar2,
p_ass_attribute6 varchar2,
p_ass_attribute7 varchar2,
p_ass_attribute8 varchar2,
p_ass_attribute9 varchar2,
p_ass_attribute10 varchar2,
p_ass_attribute11 varchar2,
p_ass_attribute12 varchar2,
p_ass_attribute13 varchar2,
p_ass_attribute14 varchar2,
p_ass_attribute15 varchar2,
p_ass_attribute16 varchar2,
p_ass_attribute17 varchar2,
p_ass_attribute18 varchar2,
p_ass_attribute19 varchar2,
p_ass_attribute20 varchar2,
p_ass_attribute21 varchar2,
p_ass_attribute22 varchar2,
p_ass_attribute23 varchar2,
p_ass_attribute24 varchar2,
p_ass_attribute25 varchar2,
p_ass_attribute26 varchar2,
p_ass_attribute27 varchar2,
p_ass_attribute28 varchar2,
p_ass_attribute29 varchar2,
p_ass_attribute30 varchar2,
p_sal_review_period number,
p_sal_review_period_frequency varchar2,
p_perf_review_period number,
p_perf_review_period_frequency varchar2,
p_pay_basis_id number,
p_employment_category varchar2,
p_bargaining_unit_code varchar2,
p_labour_union_member_flag varchar2,
p_hourly_salaried_code varchar2,
p_contract_id number default null,
p_cagr_id_flex_num number default null,
p_cagr_grade_def_id number default null,
p_establishment_id number default null,
p_collective_agreement_id number default null,
p_notice_period number default null,
p_notice_period_uom varchar2 default null,
p_employee_category varchar2 default null,
p_work_at_home varchar2 default null,
p_job_post_source_name varchar2 default null,
p_placement_date_start date default null,
p_vendor_id number default null,
p_vendor_employee_number varchar2 default null,
p_vendor_assignment_number varchar2 default null,
p_assignment_category varchar2 default null,
p_title varchar2 default null,
p_project_title varchar2 default null,
p_grade_ladder_pgm_id number default null,
p_supervisor_assignment_id number default null,
p_vendor_site_id number default null,
p_po_header_id number default null,
p_po_line_id number default null,
p_projected_assignment_end date default null
) is
l_assignment_status_id number; --discards irc_status_type out params
l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';
select *
from per_all_assignments_f
where assignment_id = P_ASSIGNMENT_ID
and effective_start_date = P_EFFECTIVE_START_DATE
and effective_end_date = P_EFFECTIVE_END_DATE;
select legislation_code
from per_business_groups
where business_group_id = P_BUSINESS_GROUP_ID;
select per_assignments_s.nextval
from sys.dual;
select rowid
from per_assignments_f
where assignment_id = P_ASSIGNMENT_ID
and effective_start_date = P_EFFECTIVE_START_DATE
and effective_end_date = P_EFFECTIVE_END_DATE;
hr_utility.set_location('In the insert row',21);
insert into per_assignments_f (
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,
assignment_sequence,
assignment_type,
primary_flag,
application_id,
assignment_number,
change_reason,
comment_id,
date_probation_end,
default_code_comb_id,
frequency,
internal_address_line,
manager_flag,
normal_hours,
period_of_service_id,
probation_period,
probation_unit,
set_of_books_id,
source_type,
time_normal_finish,
time_normal_start,
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,
sal_review_period,
sal_review_period_frequency,
perf_review_period,
perf_review_period_frequency,
pay_basis_id,
employment_category,
bargaining_unit_code,
labour_union_member_flag,
hourly_salaried_code,
contract_id,
cagr_id_flex_num,
cagr_grade_def_id,
establishment_id,
collective_agreement_id,
notice_period,
notice_period_uom,
work_at_home,
employee_category,
job_post_source_name,
period_of_placement_date_start,
vendor_id,
vendor_employee_number,
vendor_assignment_number,
assignment_category,
title,
project_title,
grade_ladder_pgm_id,
supervisor_assignment_id,
vendor_site_id,
po_header_id,
po_line_id,
projected_assignment_end)
values (
p_assignment_id,
p_effective_start_date,
p_effective_end_date,
p_business_group_id,
p_recruiter_id,
p_grade_id,
p_position_id,
p_job_id,
p_assignment_status_type_id,
p_payroll_id,
p_location_id,
p_person_referred_by_id,
p_supervisor_id,
p_special_ceiling_step_id,
p_person_id,
p_recruitment_activity_id,
p_source_organization_id,
p_organization_id,
p_people_group_id,
p_soft_coding_keyflex_id,
p_vacancy_id,
p_assignment_sequence,
p_assignment_type,
p_primary_flag,
p_application_id,
p_assignment_number,
p_change_reason,
p_comment_id,
p_date_probation_end,
p_default_code_comb_id,
p_frequency,
p_internal_address_line,
p_manager_flag,
p_normal_hours,
p_period_of_service_id,
p_probation_period,
p_probation_unit,
p_set_of_books_id,
p_source_type,
p_time_normal_finish,
p_time_normal_start,
p_request_id,
p_program_application_id,
p_program_id,
p_program_update_date,
p_ass_attribute_category,
p_ass_attribute1,
p_ass_attribute2,
p_ass_attribute3,
p_ass_attribute4,
p_ass_attribute5,
p_ass_attribute6,
p_ass_attribute7,
p_ass_attribute8,
p_ass_attribute9,
p_ass_attribute10,
p_ass_attribute11,
p_ass_attribute12,
p_ass_attribute13,
p_ass_attribute14,
p_ass_attribute15,
p_ass_attribute16,
p_ass_attribute17,
p_ass_attribute18,
p_ass_attribute19,
p_ass_attribute20,
p_ass_attribute21,
p_ass_attribute22,
p_ass_attribute23,
p_ass_attribute24,
p_ass_attribute25,
p_ass_attribute26,
p_ass_attribute27,
p_ass_attribute28,
p_ass_attribute29,
p_ass_attribute30,
p_sal_review_period,
p_sal_review_period_frequency,
p_perf_review_period,
p_perf_review_period_frequency,
p_pay_basis_id,
p_employment_category,
p_bargaining_unit_code,
p_labour_union_member_flag,
p_hourly_salaried_code,
p_contract_id,
p_cagr_id_flex_num,
p_cagr_grade_def_id,
p_establishment_id,
p_collective_agreement_id,
p_notice_period,
p_notice_period_uom,
p_work_at_home,
p_employee_category,
p_job_post_source_name,
p_placement_date_start,
p_vendor_id,
p_vendor_employee_number,
p_vendor_assignment_number,
p_assignment_category,
p_title,
p_project_title,
p_grade_ladder_pgm_id,
p_supervisor_assignment_id,
p_vendor_site_id,
p_po_header_id,
p_po_line_id,
p_projected_assignment_end
);
'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
p_action => 'INSERT');
hr_assignment.update_assgn_context_value (p_business_group_id,
p_person_id,
p_assignment_id,
p_effective_start_date);
end insert_row;
procedure delete_row(p_row_id varchar2) is
begin
delete from per_assignments_f a
where a.rowid = chartorowid(P_ROW_ID);
end delete_row;
p_program_update_date date,
p_ass_attribute_category varchar2,
p_ass_attribute1 varchar2,
p_ass_attribute2 varchar2,
p_ass_attribute3 varchar2,
p_ass_attribute4 varchar2,
p_ass_attribute5 varchar2,
p_ass_attribute6 varchar2,
p_ass_attribute7 varchar2,
p_ass_attribute8 varchar2,
p_ass_attribute9 varchar2,
p_ass_attribute10 varchar2,
p_ass_attribute11 varchar2,
p_ass_attribute12 varchar2,
p_ass_attribute13 varchar2,
p_ass_attribute14 varchar2,
p_ass_attribute15 varchar2,
p_ass_attribute16 varchar2,
p_ass_attribute17 varchar2,
p_ass_attribute18 varchar2,
p_ass_attribute19 varchar2,
p_ass_attribute20 varchar2,
p_ass_attribute21 varchar2,
p_ass_attribute22 varchar2,
p_ass_attribute23 varchar2,
p_ass_attribute24 varchar2,
p_ass_attribute25 varchar2,
p_ass_attribute26 varchar2,
p_ass_attribute27 varchar2,
p_ass_attribute28 varchar2,
p_ass_attribute29 varchar2,
p_ass_attribute30 varchar2,
p_sal_review_period number,
p_sal_review_period_frequency varchar2,
p_perf_review_period number,
p_perf_review_period_frequency varchar2,
p_pay_basis_id number,
p_employment_category varchar2,
p_bargaining_unit_code varchar2,
p_labour_union_member_flag varchar2,
p_hourly_salaried_code varchar2,
p_contract_id number,
p_cagr_id_flex_num number,
p_cagr_grade_def_id number,
p_establishment_id number,
p_collective_agreement_id number,
p_notice_period number,
p_notice_period_uom varchar2,
p_employee_category varchar2,
p_work_at_home varchar2,
p_job_post_source_name varchar2,
p_placement_date_start date,
p_vendor_id number,
p_vendor_employee_number varchar2,
p_vendor_assignment_number varchar2,
p_assignment_category varchar2,
p_title varchar2,
p_project_title varchar2,
p_grade_ladder_pgm_id number,
p_supervisor_assignment_id number,
p_vendor_site_id number,
p_po_header_id number,
p_po_line_id number,
p_projected_assignment_end date
) is
--
cursor ASS_CUR is
select *
from per_assignments_f a
where a.rowid = chartorowid(P_ROW_ID)
FOR UPDATE OF ASSIGNMENT_ID NOWAIT;
and ((ass_rec.program_update_date = p_program_update_date)
or (ass_rec.program_update_date is null
and (p_program_update_date is null)))
and ((ass_rec.sal_review_period = p_sal_review_period)
or (ass_rec.sal_review_period is null
and (p_sal_review_period is null)))
and ((ass_rec.sal_review_period_frequency = p_sal_review_period_frequency)
or (ass_rec.sal_review_period_frequency is null
and (p_sal_review_period_frequency is null)))
and ((ass_rec.perf_review_period = p_perf_review_period)
or (ass_rec.perf_review_period is null
and (p_perf_review_period is null)))
and ((ass_rec.perf_review_period_frequency = p_perf_review_period_frequency)
or (ass_rec.perf_review_period_frequency is null
and (p_perf_review_period_frequency is null)))
and ((ass_rec.pay_basis_id = p_pay_basis_id)
or (ass_rec.pay_basis_id is null
and (p_pay_basis_id is null)))) then
if ( ((ass_rec.ass_attribute_category = p_ass_attribute_category)
or (ass_rec.ass_attribute_category is null
and (p_ass_attribute_category is null)))
and ((ass_rec.ass_attribute1 = p_ass_attribute1)
or (ass_rec.ass_attribute1 is null
and (p_ass_attribute1 is null)))
and ((ass_rec.ass_attribute2 = p_ass_attribute2)
or (ass_rec.ass_attribute2 is null
and (p_ass_attribute2 is null)))
and ((ass_rec.ass_attribute3 = p_ass_attribute3)
or (ass_rec.ass_attribute3 is null
and (p_ass_attribute3 is null)))
and ((ass_rec.ass_attribute4 = p_ass_attribute4)
or (ass_rec.ass_attribute4 is null
and (p_ass_attribute4 is null)))
and ((ass_rec.ass_attribute5 = p_ass_attribute5)
or (ass_rec.ass_attribute5 is null
and (p_ass_attribute5 is null)))
and ((ass_rec.ass_attribute6 = p_ass_attribute6)
or (ass_rec.ass_attribute6 is null
and (p_ass_attribute6 is null)))
and ((ass_rec.ass_attribute7 = p_ass_attribute7)
or (ass_rec.ass_attribute7 is null
and (p_ass_attribute7 is null)))
and ((ass_rec.ass_attribute8 = p_ass_attribute8)
or (ass_rec.ass_attribute8 is null
and (p_ass_attribute8 is null)))
and ((ass_rec.ass_attribute9 = p_ass_attribute9)
or (ass_rec.ass_attribute9 is null
and (p_ass_attribute9 is null)))
and ((ass_rec.ass_attribute10 = p_ass_attribute10)
or (ass_rec.ass_attribute10 is null
and (p_ass_attribute10 is null)))
and ((ass_rec.ass_attribute11 = p_ass_attribute11)
or (ass_rec.ass_attribute11 is null
and (p_ass_attribute11 is null)))
and ((ass_rec.ass_attribute12 = p_ass_attribute12)
or (ass_rec.ass_attribute12 is null
and (p_ass_attribute12 is null)))
and ((ass_rec.ass_attribute13 = p_ass_attribute13)
or (ass_rec.ass_attribute13 is null
and (p_ass_attribute13 is null)))
and ((ass_rec.ass_attribute14 = p_ass_attribute14)
or (ass_rec.ass_attribute14 is null
and (p_ass_attribute14 is null)))
and ((ass_rec.ass_attribute15 = p_ass_attribute15)
or (ass_rec.ass_attribute15 is null
and (p_ass_attribute15 is null)))
and ((ass_rec.ass_attribute16 = p_ass_attribute16)
or (ass_rec.ass_attribute16 is null
and (p_ass_attribute16 is null)))
and ((ass_rec.ass_attribute17 = p_ass_attribute17)
or (ass_rec.ass_attribute17 is null
and (p_ass_attribute17 is null)))
and ((ass_rec.ass_attribute18 = p_ass_attribute18)
or (ass_rec.ass_attribute18 is null
and (p_ass_attribute18 is null)))
and ((ass_rec.ass_attribute19 = p_ass_attribute19)
or (ass_rec.ass_attribute19 is null
and (p_ass_attribute19 is null)))
and ((ass_rec.ass_attribute20 = p_ass_attribute20)
or (ass_rec.ass_attribute20 is null
and (p_ass_attribute20 is null)))
and ((ass_rec.ass_attribute21 = p_ass_attribute21)
or (ass_rec.ass_attribute21 is null
and (p_ass_attribute21 is null)))
and ((ass_rec.ass_attribute22 = p_ass_attribute22)
or (ass_rec.ass_attribute22 is null
and (p_ass_attribute22 is null)))
and ((ass_rec.ass_attribute23 = p_ass_attribute23)
or (ass_rec.ass_attribute23 is null
and (p_ass_attribute23 is null)))
and ((ass_rec.ass_attribute24 = p_ass_attribute24)
or (ass_rec.ass_attribute24 is null
and (p_ass_attribute24 is null)))
and ((ass_rec.ass_attribute25 = p_ass_attribute25)
or (ass_rec.ass_attribute25 is null
and (p_ass_attribute25 is null)))
and ((ass_rec.ass_attribute26 = p_ass_attribute26)
or (ass_rec.ass_attribute26 is null
and (p_ass_attribute26 is null)))
and ((ass_rec.ass_attribute27 = p_ass_attribute27)
or (ass_rec.ass_attribute27 is null
and (p_ass_attribute27 is null)))
and ((ass_rec.ass_attribute28 = p_ass_attribute28)
or (ass_rec.ass_attribute28 is null
and (p_ass_attribute28 is null)))
and ((ass_rec.ass_attribute29 = p_ass_attribute29)
or (ass_rec.ass_attribute29 is null
and (p_ass_attribute29 is null)))
and ((ass_rec.ass_attribute30 = p_ass_attribute30)
or (ass_rec.ass_attribute30 is null
and (p_ass_attribute30 is null)))
and ((ass_rec.employment_category = p_employment_category)
or (ass_rec.employment_category is null
and (p_employment_category is null)))
and ((ass_rec.bargaining_unit_code = p_bargaining_unit_code)
or (ass_rec.bargaining_unit_code is null
and (p_bargaining_unit_code is null)))
and ((ass_rec.labour_union_member_flag = p_labour_union_member_flag)
or (ass_rec.labour_union_member_flag is null
and (p_labour_union_member_flag is null)))
and ((ass_rec.hourly_salaried_code = p_hourly_salaried_code)
or (ass_rec.hourly_salaried_code is null
and (p_hourly_salaried_code is null)))
and ((ass_rec.vendor_id = p_vendor_id)
or (ass_rec.vendor_id is null
and (p_vendor_id is null)))
and ((ass_rec.vendor_site_id = p_vendor_site_id)
or (ass_rec.vendor_site_id is null
and (p_vendor_site_id is null)))
and ((ass_rec.po_header_id = p_po_header_id)
or (ass_rec.po_header_id is null
and (p_po_header_id is null)))
and ((ass_rec.po_line_id = p_po_line_id)
or (ass_rec.po_line_id is null
and (p_po_line_id is null)))
and ((ass_rec.projected_assignment_end = p_projected_assignment_end)
or (ass_rec.projected_assignment_end is null
and (p_projected_assignment_end is null)))
) then
return; -- Row successfully locked, no changes
procedure update_row(
p_row_id varchar2,
p_assignment_id number,
p_effective_start_date date,
p_effective_end_date date,
p_business_group_id number,
p_recruiter_id number,
p_grade_id number,
p_position_id number,
p_job_id number,
p_assignment_status_type_id number,
p_payroll_id number,
p_location_id number,
p_person_referred_by_id number,
p_supervisor_id number,
p_special_ceiling_step_id number,
p_person_id number,
p_recruitment_activity_id number,
p_source_organization_id number,
p_organization_id number,
p_people_group_id number,
p_soft_coding_keyflex_id number,
p_vacancy_id number,
p_assignment_sequence number,
p_assignment_type varchar2,
p_primary_flag varchar2,
p_application_id number,
p_assignment_number varchar2,
p_change_reason varchar2,
p_comment_id number,
p_date_probation_end date,
p_default_code_comb_id number,
p_frequency varchar2,
p_internal_address_line varchar2,
p_manager_flag varchar2,
p_normal_hours number,
p_period_of_service_id number,
p_probation_period number,
p_probation_unit varchar2,
p_set_of_books_id number,
p_source_type varchar2,
p_time_normal_finish varchar2,
p_time_normal_start varchar2,
p_request_id number,
p_program_application_id number,
p_program_id number,
p_program_update_date date,
p_ass_attribute_category varchar2,
p_ass_attribute1 varchar2,
p_ass_attribute2 varchar2,
p_ass_attribute3 varchar2,
p_ass_attribute4 varchar2,
p_ass_attribute5 varchar2,
p_ass_attribute6 varchar2,
p_ass_attribute7 varchar2,
p_ass_attribute8 varchar2,
p_ass_attribute9 varchar2,
p_ass_attribute10 varchar2,
p_ass_attribute11 varchar2,
p_ass_attribute12 varchar2,
p_ass_attribute13 varchar2,
p_ass_attribute14 varchar2,
p_ass_attribute15 varchar2,
p_ass_attribute16 varchar2,
p_ass_attribute17 varchar2,
p_ass_attribute18 varchar2,
p_ass_attribute19 varchar2,
p_ass_attribute20 varchar2,
p_ass_attribute21 varchar2,
p_ass_attribute22 varchar2,
p_ass_attribute23 varchar2,
p_ass_attribute24 varchar2,
p_ass_attribute25 varchar2,
p_ass_attribute26 varchar2,
p_ass_attribute27 varchar2,
p_ass_attribute28 varchar2,
p_ass_attribute29 varchar2,
p_ass_attribute30 varchar2,
p_sal_review_period number,
p_sal_review_period_frequency varchar2,
p_perf_review_period number,
p_perf_review_period_frequency varchar2,
p_pay_basis_id number,
p_employment_category varchar2,
p_dt_update_mode varchar2,
p_session_date date,
p_bargaining_unit_code varchar2,
p_labour_union_member_flag varchar2,
p_hourly_salaried_code varchar2,
p_contract_id number default null,
p_cagr_id_flex_num number default null,
p_cagr_grade_def_id number default null,
p_establishment_id number default null,
p_collective_agreement_id number default null,
p_notice_period number default null,
p_notice_period_uom varchar2 default null,
p_employee_category varchar2 default null,
p_work_at_home varchar2 default null,
p_job_post_source_name varchar2 default null,
p_placement_date_start date default null,
p_vendor_id number default null,
p_vendor_employee_number varchar2 default null,
p_vendor_assignment_number varchar2 default null,
p_assignment_category varchar2 default null,
p_title varchar2 default null,
p_project_title varchar2 default null,
p_grade_ladder_pgm_id number default null,
p_supervisor_assignment_id number default null,
p_vendor_site_id number default null,
p_po_header_id number default null,
p_po_line_id number default null,
p_projected_assignment_end date default null
) is
l_assignment_status_id number; --discards out params from irc_asg_st
l_dt_update_mode varchar2(240);
l_proc varchar2(10) := 'insert_row';
select *
from per_all_assignments_f
where assignment_id = P_ASSIGNMENT_ID
and effective_start_date = P_EFFECTIVE_START_DATE
and effective_end_date = P_EFFECTIVE_END_DATE;
select pav.organization_id,
pbg.legislation_code,
pav.location_id
from per_assignments_f pav,
per_business_groups pbg
where c_row_id = pav.rowid
and pav.business_group_id = pbg.business_group_id;
select paf.location_id
from PER_ASSIGNMENTS_F paf
where paf.assignment_id = p_assignment_id
and p_session_date between paf.effective_start_date
and paf.effective_end_date;
SELECT status
FROM fnd_product_installations
WHERE application_id = 801
AND p_primary_flag = 'Y';
select min(change_date)
from per_pay_proposals
where assignment_id = p_assignment_id;
select vendor_id,vendor_site_id from
per_all_assignments_f paf
where paf.assignment_id = p_assignment_id
and nvl(p_session_date,sysdate) between paf.effective_start_date
and paf.effective_end_date;
hr_utility.set_location('per_assignments_f_pkg.update_row',1);
'per_assignments_f_pkg.update_row');
hr_utility.set_location('per_assignments_f_pkg.update_row',10);
hr_utility.set_location('per_assignments_f_pkg.update_row',20);
hr_utility.set_location('per_assignments_f_pkg.update_row',30);
'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
select assignment_status_type_id into l_previous_asg_status
from per_assignments_f
where rowid = chartorowid(P_ROW_ID);
update per_assignments_f a
set a.assignment_id = P_ASSIGNMENT_ID,
a.effective_start_date = P_EFFECTIVE_START_DATE,
a.effective_end_date = P_EFFECTIVE_END_DATE,
a.business_group_id = P_BUSINESS_GROUP_ID,
a.recruiter_id = P_RECRUITER_ID,
a.grade_id = P_GRADE_ID,
a.position_id = P_POSITION_ID,
a.job_id = P_JOB_ID,
a.assignment_status_type_id = P_ASSIGNMENT_STATUS_TYPE_ID,
a.payroll_id = P_PAYROLL_ID,
a.location_id = P_LOCATION_ID,
a.person_referred_by_id = P_PERSON_REFERRED_BY_ID,
a.supervisor_id = P_SUPERVISOR_ID,
a.special_ceiling_step_id = P_SPECIAL_CEILING_STEP_ID,
a.person_id = P_PERSON_ID,
a.recruitment_activity_id = P_RECRUITMENT_ACTIVITY_ID,
a.source_organization_id = P_SOURCE_ORGANIZATION_ID,
a.organization_id = P_ORGANIZATION_ID,
a.people_group_id = P_PEOPLE_GROUP_ID,
a.soft_coding_keyflex_id = P_SOFT_CODING_KEYFLEX_ID,
a.vacancy_id = P_VACANCY_ID,
a.assignment_sequence = P_ASSIGNMENT_SEQUENCE,
a.assignment_type = P_ASSIGNMENT_TYPE,
a.primary_flag = P_PRIMARY_FLAG,
a.application_id = P_APPLICATION_ID,
a.assignment_number = P_ASSIGNMENT_NUMBER,
a.change_reason = P_CHANGE_REASON,
a.comment_id = P_COMMENT_ID,
a.date_probation_end = P_DATE_PROBATION_END,
a.default_code_comb_id = P_DEFAULT_CODE_COMB_ID,
a.frequency = P_FREQUENCY,
a.internal_address_line = P_INTERNAL_ADDRESS_LINE,
a.manager_flag = P_MANAGER_FLAG,
a.normal_hours = P_NORMAL_HOURS,
a.period_of_service_id = P_PERIOD_OF_SERVICE_ID,
a.probation_period = P_PROBATION_PERIOD,
a.probation_unit = P_PROBATION_UNIT,
a.set_of_books_id = P_SET_OF_BOOKS_ID,
a.source_type = P_SOURCE_TYPE,
a.time_normal_finish = P_TIME_NORMAL_FINISH,
a.time_normal_start = P_TIME_NORMAL_START,
a.request_id = P_REQUEST_ID,
a.program_application_id = P_PROGRAM_APPLICATION_ID,
a.program_id = P_PROGRAM_ID,
a.program_update_date = P_PROGRAM_UPDATE_DATE,
a.ass_attribute_category = P_ASS_ATTRIBUTE_CATEGORY,
a.ass_attribute1 = P_ASS_ATTRIBUTE1,
a.ass_attribute2 = P_ASS_ATTRIBUTE2,
a.ass_attribute3 = P_ASS_ATTRIBUTE3,
a.ass_attribute4 = P_ASS_ATTRIBUTE4,
a.ass_attribute5 = P_ASS_ATTRIBUTE5,
a.ass_attribute6 = P_ASS_ATTRIBUTE6,
a.ass_attribute7 = P_ASS_ATTRIBUTE7,
a.ass_attribute8 = P_ASS_ATTRIBUTE8,
a.ass_attribute9 = P_ASS_ATTRIBUTE9,
a.ass_attribute10 = P_ASS_ATTRIBUTE10,
a.ass_attribute11 = P_ASS_ATTRIBUTE11,
a.ass_attribute12 = P_ASS_ATTRIBUTE12,
a.ass_attribute13 = P_ASS_ATTRIBUTE13,
a.ass_attribute14 = P_ASS_ATTRIBUTE14,
a.ass_attribute15 = P_ASS_ATTRIBUTE15,
a.ass_attribute16 = P_ASS_ATTRIBUTE16,
a.ass_attribute17 = P_ASS_ATTRIBUTE17,
a.ass_attribute18 = P_ASS_ATTRIBUTE18,
a.ass_attribute19 = P_ASS_ATTRIBUTE19,
a.ass_attribute20 = P_ASS_ATTRIBUTE20,
a.ass_attribute21 = P_ASS_ATTRIBUTE21,
a.ass_attribute22 = P_ASS_ATTRIBUTE22,
a.ass_attribute23 = P_ASS_ATTRIBUTE23,
a.ass_attribute24 = P_ASS_ATTRIBUTE24,
a.ass_attribute25 = P_ASS_ATTRIBUTE25,
a.ass_attribute26 = P_ASS_ATTRIBUTE26,
a.ass_attribute27 = P_ASS_ATTRIBUTE27,
a.ass_attribute28 = P_ASS_ATTRIBUTE28,
a.ass_attribute29 = P_ASS_ATTRIBUTE29,
a.ass_attribute30 = P_ASS_ATTRIBUTE30,
a.sal_review_period = P_SAL_REVIEW_PERIOD,
a.sal_review_period_frequency = P_SAL_REVIEW_PERIOD_FREQUENCY,
a.perf_review_period = P_PERF_REVIEW_PERIOD,
a.perf_review_period_frequency = P_PERF_REVIEW_PERIOD_FREQUENCY,
a.pay_basis_id = P_PAY_BASIS_ID,
a.employment_category = P_EMPLOYMENT_CATEGORY,
a.bargaining_unit_code = P_BARGAINING_UNIT_CODE,
a.labour_union_member_flag = P_LABOUR_UNION_MEMBER_FLAG,
a.hourly_salaried_code = P_HOURLY_SALARIED_CODE,
a.collective_agreement_id = P_COLLECTIVE_AGREEMENT_ID,
a.cagr_grade_def_id = P_CAGR_GRADE_DEF_ID,
a.establishment_id = P_ESTABLISHMENT_ID,
a.contract_id = P_CONTRACT_ID,
a.cagr_id_flex_num = P_CAGR_ID_FLEX_NUM,
a.notice_period = P_NOTICE_PERIOD,
a.notice_period_uom = P_NOTICE_PERIOD_UOM,
a.work_at_home = P_WORK_AT_HOME,
a.employee_category = P_EMPLOYEE_CATEGORY,
a.job_post_source_name = P_JOB_POST_SOURCE_NAME,
a.period_of_placement_date_start = p_placement_date_start,
a.vendor_id = p_vendor_id,
a.vendor_employee_number = p_vendor_employee_number,
a.vendor_assignment_number = p_vendor_assignment_number,
a.assignment_category = p_assignment_category,
a.title = p_title,
a.project_title = p_project_title,
a.grade_ladder_pgm_id = p_grade_ladder_pgm_id,
a.supervisor_assignment_id = p_supervisor_assignment_id,
a.vendor_site_id = p_vendor_site_id,
a.po_header_id = p_po_header_id,
a.po_line_id = p_po_line_id,
a.projected_assignment_end = p_projected_assignment_end
where a.rowid = chartorowid(P_ROW_ID);
l_dt_update_mode := NULL;
l_dt_update_mode := p_dt_update_mode;
p_mode => l_dt_update_mode,
p_location_id => l_location_id,
p_return_code => l_return_code,
p_return_text => l_return_text);
p_action => 'UPDATE');
end update_row;
select assignment_extra_info_id, object_version_number
from per_assignment_extra_info
where assignment_id = p_assignment_id
and information_type = 'PROMOTION'
and fnd_date.canonical_to_date(aei_information1) = p_promotion_date;
hr_assignment_extra_info_api.delete_assignment_extra_info(
p_assignment_extra_info_id => l_promotion_rec.assignment_extra_info_id
,p_object_version_number => l_promotion_rec.object_version_number
);