DBA Data[Home] [Help]

APPS.PAY_CA_MAG_ROE dependencies on PAY_CA_MAG_ROE

Line 1: PACKAGE BODY pay_ca_mag_roe AS

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

Line 72: ('pay_ca_mag_roe.get_report_parameters', 10);

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

Line 85: ('pay_ca_mag_roe.get_report_parameters', 20);

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);

Line 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: --

Line 120: hr_utility.set_location( 'pay_ca_mag_roe.range_cursor', 10);

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,

Line 130: hr_utility.set_location( 'pay_ca_mag_roe.range_cursor', 20);

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:

Line 202: hr_utility.set_location( 'pay_ca_mag_roe.range_cursor', 30);

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: --

Line 365: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',10);

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,

Line 377: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',20);

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

Line 383: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',30);

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

Line 386: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',40);

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

Line 389: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',50);

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;

Line 392: hr_utility.set_location( 'pay_ca_mag_roe.create_assignment_act',70);

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:

Line 471: end pay_ca_mag_roe;

467:
468: end create_assignment_act;
469:
470:
471: end pay_ca_mag_roe;