DBA Data[Home] [Help]

APPS.PAY_CA_MAG_ROE dependencies on HR_UTILITY

Line 37: hr_utility.set_location('func_user_entity_id',1);

33: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
34:
35: begin
36:
37: hr_utility.set_location('func_user_entity_id',1);
38:
39: open cur_user_entity_id;
40: fetch cur_user_entity_id
41: into l_user_entity_id;

Line 71: hr_utility.set_location

67: from pay_payroll_actions ppa
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:

Line 84: hr_utility.set_location

80: p_assignment_set;
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

Line 88: hr_utility.set_location

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);
90: end get_report_parameters;
91:
92:

Line 119: --hr_utility.trace_on(1,'ORACLE');

115: l_roe_asg_id_uid ff_user_entities.user_entity_id%TYPE;
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,

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 418: hr_utility.set_location('cur_assignment_action',10);

414: fetch cur_assignment_action into l_assignment_id, l_gre_id,l_payroll_id;
415: exit when cur_assignment_action%notfound;
416: end if;
417:
418: hr_utility.set_location('cur_assignment_action',10);
419:
420: for j in cur_locked_action_id(l_assignment_id,
421: l_gre_id,
422: l_payroll_id) loop

Line 444: hr_utility.set_location('assignment action creation',30);

440:
441: hr_nonrun_asact.insact(lockingactid,l_assignment_id,
442: p_pactid,p_chunk,l_gre_id);
443:
444: hr_utility.set_location('assignment action creation',30);
445:
446:
447: hr_nonrun_asact.insint(lockingactid, l_locked_action_id);
448:

Line 449: hr_utility.set_location('Assignment action interlock',40);

445:
446:
447: hr_nonrun_asact.insint(lockingactid, l_locked_action_id);
448:
449: hr_utility.set_location('Assignment action interlock',40);
450:
451: else
452:
453: close cur_already_locked;