1: PACKAGE BODY pay_ca_mag_roe AS
2: /* $Header: pycaremg.pkb 120.0 2005/05/29 03:42:11 appldev noship $ */
3:
4: -----------------------------------------------------------------------------
5: -- Name :: get_report_parameters
68: where payroll_action_id = p_pactid;
69:
70: begin
71: hr_utility.set_location
72: ('pay_ca_mag_roe.get_report_parameters', 10);
73:
74: open cur_ppa;
75:
76: fetch cur_ppa
81:
82: close cur_ppa;
83:
84: hr_utility.set_location
85: ('pay_ca_mag_roe.get_report_parameters', 20);
86: end;
87:
88: hr_utility.set_location
89: ('pay_ca_mag_roe.get_report_parameters', 30);
85: ('pay_ca_mag_roe.get_report_parameters', 20);
86: end;
87:
88: hr_utility.set_location
89: ('pay_ca_mag_roe.get_report_parameters', 30);
90: end get_report_parameters;
91:
92:
93: --
116:
117: begin
118:
119: --hr_utility.trace_on(1,'ORACLE');
120: hr_utility.set_location( 'pay_ca_mag_roe.range_cursor', 10);
121:
122: get_report_parameters(
123: p_pactid,
124: p_start_date,
126: p_person_id,
127: p_assignment_set
128: );
129:
130: hr_utility.set_location( 'pay_ca_mag_roe.range_cursor', 20);
131:
132: l_roe_date_uid := FUN_USER_ENTITY_ID('ROE_DATE');
133: l_roe_asg_id_uid := FUN_USER_ENTITY_ID('ROE_ASSIGNMENT_ID');
134:
198: paf.effective_end_date';
199: end if;
200:
201: --end if;
202: hr_utility.set_location( 'pay_ca_mag_roe.range_cursor', 30);
203: end;
204: end range_cursor;
205:
206: --
361: p_assignment_set number;
362: begin
363: -- Get the report parameters. These define the report being run.
364:
365: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',10);
366:
367: get_report_parameters(
368: p_pactid,
369: p_start_date,
373: );
374:
375:
376:
377: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',20);
378:
379: for cur_ass_id in 1..4 loop
380:
381: if cur_ass_id = 1 then
379: for cur_ass_id in 1..4 loop
380:
381: if cur_ass_id = 1 then
382: l_roe_date_id := fun_user_entity_id('ROE_DATE');
383: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',30);
384: elsif cur_ass_id = 2 then
385: l_roe_assignment_id := fun_user_entity_id('ROE_ASSIGNMENT_ID');
386: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',40);
387: elsif cur_ass_id = 3 then
382: l_roe_date_id := fun_user_entity_id('ROE_DATE');
383: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',30);
384: elsif cur_ass_id = 2 then
385: l_roe_assignment_id := fun_user_entity_id('ROE_ASSIGNMENT_ID');
386: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',40);
387: elsif cur_ass_id = 3 then
388: l_roe_gre_id := fun_user_entity_id('ROE_GRE_ID');
389: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',50);
390: elsif cur_ass_id = 4 then
385: l_roe_assignment_id := fun_user_entity_id('ROE_ASSIGNMENT_ID');
386: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',40);
387: elsif cur_ass_id = 3 then
388: l_roe_gre_id := fun_user_entity_id('ROE_GRE_ID');
389: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',50);
390: elsif cur_ass_id = 4 then
391: l_roe_payroll_id := fun_user_entity_id('ROE_PAYROLL_ID');
392: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',70);
393: end if;
388: l_roe_gre_id := fun_user_entity_id('ROE_GRE_ID');
389: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',50);
390: elsif cur_ass_id = 4 then
391: l_roe_payroll_id := fun_user_entity_id('ROE_PAYROLL_ID');
392: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',70);
393: end if;
394:
395: end loop;
396:
467:
468: end create_assignment_act;
469:
470:
471: end pay_ca_mag_roe;