[Home] [Help]
1: PACKAGE BODY PAY_CA_RL2_AMEND_MAG AS
2: /* $Header: pycarl2amd.pkb 120.16.12020000.9 2012/12/31 08:15:45 sgotlasw ship $ */
3:
4: -- Name : get_report_parameters
5:
110: p_legislative_param IN OUT NOCOPY VARCHAR2
111: ) IS
112: BEGIN
113: --hr_utility.trace_on('Y','RL2AMD');
114: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 10);
115:
116: SELECT ppa.start_date,
117: ppa.effective_date,
118: ppa.business_group_id,
125: p_legislative_param
126: FROM pay_payroll_actions ppa
127: WHERE payroll_action_id = p_pactid;
128:
129: hr_utility.set_location('pay_ca_rl2_amend_mag.get_report_parameters', 20);
130:
131: END get_report_parameters;
132:
133: ---------------------------------------------------------------------------
295: p_legislative_param pay_payroll_actions.legislative_parameters%type;
296:
297: BEGIN
298:
299: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 10);
300:
301: get_report_parameters(
302: p_pactid,
303: p_year_start,
306: p_business_group_id,
307: p_legislative_param
308: );
309:
310: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 20);
311: p_sqlstr := 'select distinct to_number(emp.person_id)
312: from pay_ca_eoy_rl2_employee_info_v emp,
313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,
333: and hoi.org_information_context =''Prov Reporting Est''
334: and to_char(hoi.organization_id) = pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',ppa_arch.legislative_parameters)
335: order by to_number(emp.person_id)' ;
336:
337: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor',30);
338:
339: END range_cursor;
340:
341: -------------------------------------------------------------------------------
555:
556:
557: -- Get the report parameters. These define the report being run.
558: l_prev_payact := -1;
559: hr_utility.set_location( 'pay_ca_rl2_amend_mag.create_assignment_act',10);
560:
561: get_report_parameters(
562: p_pactid,
563: l_year_start,
572: l_year_end);
573:
574: --Open the appropriate cursor
575:
576: hr_utility.set_location( 'pay_ca_rl2_amend_mag.create_assignment_act',20);
577: hr_utility.trace('Report type '||l_report_type);
578: IF l_report_type = 'RL2_AMEND_MAG' THEN
579:
580: OPEN c_all_asg(l_legislative_param,
588: l_effective_end_date,
589: l_assignment_action_id,
590: l_payroll_act;
591:
592: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 30);
593:
594: EXIT WHEN c_all_asg%NOTFOUND;
595:
596: --Create the assignment action for the record
640: hr_utility.trace('Person Id : '|| to_char(l_person_id));
641: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
642: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
643:
644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);
645:
646: /* Create an assignment action for this person */
647:
648: select pay_assignment_actions_s.nextval
647:
648: select pay_assignment_actions_s.nextval
649: into lockingactid
650: from dual;
651: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 50);
652: hr_utility.trace('New RL2 Amend Action = ' ||
653: to_char(lockingactid));
654:
655: open get_latest_rl2_amend_dtls(l_person_id,
723: set aa.serial_number = to_char(l_person_id)
724: where aa.assignment_action_id = lockingactid;
725:
726: --Added to lock the Amend Archiver
727: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
728: hr_nonrun_asact.insint(lockingactid
729: ,ln_asg_act_to_lock);
730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
731: hr_utility.trace('Locking Action'||lockingactid);
726: --Added to lock the Amend Archiver
727: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
728: hr_nonrun_asact.insint(lockingactid
729: ,ln_asg_act_to_lock);
730: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
731: hr_utility.trace('Locking Action'||lockingactid);
732: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
733: hr_utility.trace('lv_flag_count = ' || to_char(lv_flag_count));
734: lv_flag_count := lv_flag_count + 1;
760: set aa.serial_number = to_char(l_person_id)
761: where aa.assignment_action_id = lockingactid;
762:
763: --Added to lock the previous mag Reports
764: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
765: hr_nonrun_asact.insint(lockingactid
766: ,ln_asg_act_to_lock);
767: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
768: hr_utility.trace('Locking Action'||lockingactid);
763: --Added to lock the previous mag Reports
764: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 60);
765: hr_nonrun_asact.insint(lockingactid
766: ,ln_asg_act_to_lock);
767: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 70);
768: hr_utility.trace('Locking Action'||lockingactid);
769: hr_utility.trace('Locked Action = ' || to_char(ln_asg_act_to_lock));
770:
771: end if; --c_paa_update_check%FOUND
3266: hr_utility.trace('l_seq_number ='|| l_seq_number);
3267: return l_seq_number;
3268: END; */
3269:
3270: END pay_ca_rl2_amend_mag;