259: ln_prev_asg_action_id NUMBER := 0;
260: ln_prev_assignment_id NUMBER := 0;
261: ld_prev_effective_date DATE ;
262: lv_report_type pay_payroll_actions.report_type%TYPE ;
263: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
264:
265:
266: lv_serial_number VARCHAR2(30);
267: ln_eoy_pactid number := 0;
277: ,cp_asg_set in number) is
278: select distinct paf.person_id
279: from hr_assignment_set_amendments asgset,
280: per_all_assignments_f paf,
281: pay_assignment_actions paa,
282: pay_payroll_actions ppa
283: where asgset.assignment_set_id = cp_asg_set
284: and asgset.include_or_exclude = 'I'
285: and paf.assignment_id = asgset.assignment_id
303: select ppa.report_type,
304: paa.assignment_id,
305: paa.assignment_action_id
306: from pay_payroll_actions ppa,
307: pay_assignment_actions paa
308: where to_number(paa.serial_number) = cp_person_id
309: and pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
310: ppa.legislative_parameters) = to_char(cp_pre_org_id)
311: and paa.action_status = 'C'
379:
380: if lv_report_type in ('RL1', 'CAEOY_RL1_AMEND_PP') then
381:
382: /* Create an assignment action for this person */
383: select pay_assignment_actions_s.nextval
384: into ln_rl1amend_asg_action
385: from dual;
386: hr_utility.trace('New RL1 Amendment Action = ' ||
387: to_char(ln_rl1amend_asg_action));
385: from dual;
386: hr_utility.trace('New RL1 Amendment Action = ' ||
387: to_char(ln_rl1amend_asg_action));
388:
389: /* Insert into pay_assignment_actions. */
390: -- hr_utility.trace('creating asg. action');
391: hr_nonrun_asact.insact(ln_rl1amend_asg_action
392: ,ln_primary_assignment_id
393: ,p_payroll_action_id
400: table */
401:
402: -- hr_utility.trace('updating asg. action');
403:
404: update pay_assignment_actions aa
405: set aa.serial_number = to_char(p_person_id)
406: where aa.assignment_action_id = ln_rl1amend_asg_action;
407:
408: /* Interlock the YEPP or Previous RL1 Amendment Archiver