eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL1_MAG dependencies on PAY_CA_RL1_MAG

Line 1: PACKAGE BODY pay_ca_rl1_mag AS

1: PACKAGE BODY pay_ca_rl1_mag AS
2: /* $Header: pycarlmg.pkb 120.73.12010000.3 2008/09/02 07:09:17 sapalani ship $ */
3:
4: -- Name : get_report_parameters
5:

Line 33: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 10);

29: p_business_group_id IN OUT NOCOPY NUMBER
30: ) IS
31: BEGIN
32: --hr_utility.trace_on('Y','RL1MAG');
33: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 10);
34:
35: SELECT ppa.start_date,
36: ppa.effective_date,
37: ppa.business_group_id,

Line 46: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 20);

42: p_report_type
43: FROM pay_payroll_actions ppa
44: WHERE payroll_action_id = p_pactid;
45:
46: hr_utility.set_location('pay_ca_rl1_mag.get_report_parameters', 20);
47:
48: END get_report_parameters;
49:
50: FUNCTION convert_special_char( p_data varchar2)

Line 143: pay_ca_rl1_mag.get_parameter('PRE_ORGANIZATION_ID',

139: ppa.report_qualifier = 'CAEOYRL1' AND
140: ppa.report_category = 'CAEOYRL1' AND
141: ppa.effective_date = p_effective_date AND
142: p_transmitter_org_id =
143: pay_ca_rl1_mag.get_parameter('PRE_ORGANIZATION_ID',
144: ppa.legislative_parameters);
145:
146: l_transmitter_number VARCHAR2(30);
147: l_transmitter_name VARCHAR2(100);

Line 172: l_transmitter_org_id := pay_ca_rl1_mag.get_parameter('TRANSMITTER_PRE',

168: FETCH cur_ppa
169: INTO l_legislative_parameters;
170: CLOSE cur_ppa;
171:
172: l_transmitter_org_id := pay_ca_rl1_mag.get_parameter('TRANSMITTER_PRE',
173: l_legislative_parameters);
174:
175: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
176: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));

Line 265: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 10);

261: p_report_type VARCHAR2(30);
262:
263: BEGIN
264: -- hr_utility.trace_on(null,'PDF');
265: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 10);
266:
267: get_report_parameters(
268: p_pactid,
269: p_year_start,

Line 275: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 20);

271: p_report_type,
272: p_business_group_id
273: );
274:
275: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor', 20);
276:
277:
278: p_sqlstr := 'select distinct to_number(fai1.value)
279: from ff_archive_items fai1,

Line 294: and fai2.value = pay_ca_rl1_mag.get_parameter(''REPORTING_YEAR'',ppa1.legislative_parameters)

290: and ppa.report_type = ''RL1''
291: and ppa.payroll_action_id = paa.payroll_action_id
292: and fdi2.user_name = ''CAEOY_TAXATION_YEAR''
293: and fai2.user_entity_id = fdi2.user_entity_id
294: and fai2.value = pay_ca_rl1_mag.get_parameter(''REPORTING_YEAR'',ppa1.legislative_parameters)
295: and paa.payroll_action_id= fai2.context1
296: and paa.action_status = ''C''
297: and paa.assignment_action_id = fai1.context1
298: and fai1.user_entity_id = fdi1.user_entity_id

Line 301: pay_ca_rl1_mag.get_parameter(''TRANSMITTER_PRE'', ppa1.legislative_parameters )

297: and paa.assignment_action_id = fai1.context1
298: and fai1.user_entity_id = fdi1.user_entity_id
299: and fdi1.user_name = ''CAEOY_PERSON_ID''
300: and decode(hoi.org_information3, ''Y'', hoi.organization_id, hoi.org_information20) =
301: pay_ca_rl1_mag.get_parameter(''TRANSMITTER_PRE'', ppa1.legislative_parameters )
302: and hoi.org_information_context =''Prov Reporting Est''
303: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )
304: order by to_number(fai1.value)' ;
305:

Line 303: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )

299: and fdi1.user_name = ''CAEOY_PERSON_ID''
300: and decode(hoi.org_information3, ''Y'', hoi.organization_id, hoi.org_information20) =
301: pay_ca_rl1_mag.get_parameter(''TRANSMITTER_PRE'', ppa1.legislative_parameters )
302: and hoi.org_information_context =''Prov Reporting Est''
303: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )
304: order by to_number(fai1.value)' ;
305:
306: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor',40);
307:

Line 306: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor',40);

302: and hoi.org_information_context =''Prov Reporting Est''
303: and hoi.organization_id = pay_ca_rl1_mag.get_parameter(''PRE_ORGANIZATION_ID'', ppa.legislative_parameters )
304: order by to_number(fai1.value)' ;
305:
306: hr_utility.set_location( 'pay_ca_rl1_mag.range_cursor',40);
307:
308: END range_cursor;
309:
310: -------------------------------------------------------------------------------

Line 399: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',10);

395:
396: -- hr_utility.trace_on('Y','RL1MAG');
397:
398: l_prev_payact := -1;
399: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',10);
400:
401: get_report_parameters(
402: p_pactid,
403: l_year_start,

Line 413: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',20);

409: validate_transmitter_info(p_pactid,
410: l_business_group_id,
411: l_year_end);
412:
413: hr_utility.set_location( 'pay_ca_rl1_mag.create_assignement_act',20);
414:
415: --IF l_report_type = 'PYRL1MAG' THEN
416:
417: OPEN c_all_asg;

Line 426: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 30);

422: l_effective_end_date,
423: l_assignment_action_id,
424: l_payroll_act;
425:
426: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 30);
427:
428: EXIT WHEN c_all_asg%NOTFOUND;
429:
430: /* Added by ssmukher for validating the

Line 457: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 40);

453: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
454: hr_utility.trace('Person Id : '|| to_char(l_person_id));
455: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
456: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
457: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 40);
458:
459: SELECT pay_assignment_actions_s.nextval
460: INTO lockingactid
461: FROM dual;

Line 463: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 50);

459: SELECT pay_assignment_actions_s.nextval
460: INTO lockingactid
461: FROM dual;
462:
463: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 50);
464: hr_nonrun_asact.insact(lockingactid,
465: l_assignment_id,
466: p_pactid,
467: p_chunk,

Line 470: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 60);

466: p_pactid,
467: p_chunk,
468: l_tax_unit_id);
469:
470: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 60);
471: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
472: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 70);
473: hr_utility.trace('Interlock Created - ');
474: hr_utility.trace('Locking Action : '|| to_char(lockingactid));

Line 472: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 70);

468: l_tax_unit_id);
469:
470: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 60);
471: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
472: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 70);
473: hr_utility.trace('Interlock Created - ');
474: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
475: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
476: END LOOP;

Line 4752: END pay_ca_rl1_mag;

4748:
4749: END archive_ca_deinit;
4750: /******************************************** *************************************************************/
4751:
4752: END pay_ca_rl1_mag;