249: ln_prev_asg_action_id NUMBER := 0;
250: ln_prev_assignment_id NUMBER := 0;
251: ld_prev_effective_date DATE ;
252: lv_report_type pay_payroll_actions.report_type%TYPE ;
253: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
254:
255:
256: lv_serial_number VARCHAR2(30);
257: ln_eoy_pactid number := 0;
267: ,cp_asg_set in number) is
268: select distinct paf.person_id
269: from hr_assignment_set_amendments asgset,
270: per_all_assignments_f paf,
271: pay_assignment_actions paa,
272: pay_payroll_actions ppa
273: where asgset.assignment_set_id = cp_asg_set
274: and asgset.include_or_exclude = 'I'
275: and paf.assignment_id = asgset.assignment_id
293: select ppa.report_type,
294: paa.assignment_id,
295: paa.assignment_action_id
296: from pay_payroll_actions ppa,
297: pay_assignment_actions paa
298: where to_number(paa.serial_number) = cp_person_id
299: and pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',
300: ppa.legislative_parameters) = to_char(cp_pre_org_id)
301: and paa.action_status = 'C'
369:
370: if lv_report_type in ('RL2', 'CAEOY_RL2_AMEND_PP') then
371:
372: /* Create an assignment action for this person */
373: select pay_assignment_actions_s.nextval
374: into ln_rl2amend_asg_action
375: from dual;
376: hr_utility.trace('New RL2 Amendment Action = ' ||
377: to_char(ln_rl2amend_asg_action));
375: from dual;
376: hr_utility.trace('New RL2 Amendment Action = ' ||
377: to_char(ln_rl2amend_asg_action));
378:
379: /* Insert into pay_assignment_actions. */
380: -- hr_utility.trace('creating asg. action');
381: hr_nonrun_asact.insact(ln_rl2amend_asg_action
382: ,ln_primary_assignment_id
383: ,p_payroll_action_id
390: table */
391:
392: -- hr_utility.trace('updating asg. action');
393:
394: update pay_assignment_actions aa
395: set aa.serial_number = to_char(p_person_id)
396: where aa.assignment_action_id = ln_rl2amend_asg_action;
397:
398: /* Interlock the YEPP or Previous RL2 Amendment Archiver