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_CAN_MAG dependencies on PAY_CA_RL1_CAN_MAG

Line 1: PACKAGE BODY pay_ca_rl1_can_mag AS

1: PACKAGE BODY pay_ca_rl1_can_mag AS
2: /* $Header: pycarlcmg.pkb 120.12.12020000.6 2012/12/19 06:24:26 sbachu ship $ */
3:
4: -- Name : get_report_parameters
5:

Line 34: hr_utility.set_location('pay_ca_rl1_can_mag.get_report_parameters', 10);

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

Line 49: hr_utility.set_location('pay_ca_rl1_can_mag.get_report_parameters', 20);

45: p_legislative_parameters
46: FROM pay_payroll_actions ppa
47: WHERE payroll_action_id = p_pactid;
48:
49: hr_utility.set_location('pay_ca_rl1_can_mag.get_report_parameters', 20);
50:
51: END get_report_parameters;
52:
53: FUNCTION convert_special_char( p_data varchar2)

Line 146: pay_ca_rl1_can_mag.get_parameter('PRE_ORGANIZATION_ID',

142: 'RL1_XML_MAG', 'RL1',
143: 'RL1_AMEND_MAG', 'CAEOY_RL1_AMEND_PP') AND
144: ppa.effective_date = p_effective_date AND
145: p_transmitter_org_id =
146: pay_ca_rl1_can_mag.get_parameter('PRE_ORGANIZATION_ID',
147: ppa.legislative_parameters);
148:
149: l_transmitter_number VARCHAR2(30);
150: l_transmitter_name VARCHAR2(100);

Line 185: l_transmitter_org_id := pay_ca_rl1_can_mag.get_parameter('TRANSMITTER_PRE',

181: FETCH cur_ppa
182: INTO l_legislative_parameters;
183: CLOSE cur_ppa;
184:
185: l_transmitter_org_id := pay_ca_rl1_can_mag.get_parameter('TRANSMITTER_PRE',
186: l_legislative_parameters);
187:
188: hr_utility.trace('l_transmitter_org_id = ' || to_char(l_transmitter_org_id));
189: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));

Line 193: l_mag_pactid := pay_ca_rl1_can_mag.get_parameter('PAY_ACT',

189: hr_utility.trace('p_bg_id = ' || to_char(p_bg_id));
190: hr_utility.trace('p_payroll_action_id = ' || to_char(p_payroll_action_id));
191: hr_utility.trace('p_effective_date = ' || to_char(p_effective_date));
192:
193: l_mag_pactid := pay_ca_rl1_can_mag.get_parameter('PAY_ACT',
194: l_legislative_parameters);
195:
196: OPEN c_ppa_report_type(l_mag_pactid);
197: FETCH c_ppa_report_type

Line 388: hr_utility.set_location( 'pay_ca_rl1_can_mag.range_cursor', 10);

384: p_report_type VARCHAR2(30);
385:
386: BEGIN
387: -- hr_utility.trace_on(null,'PDF');
388: hr_utility.set_location( 'pay_ca_rl1_can_mag.range_cursor', 10);
389:
390: p_sqlstr := 'select distinct paaf.person_id
391: from per_all_assignments_f paaf,
392: pay_payroll_actions ppa,

Line 399: to_number(pay_ca_rl1_can_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))

395: where ppa.payroll_action_id = paa.payroll_action_id
396: and paa.assignment_id = paaf.assignment_id
397: and ppa1.payroll_action_id = :payroll_action_id
398: and ppa.payroll_action_id =
399: to_number(pay_ca_rl1_can_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))
400: and paaf.person_id =
401: nvl(pay_ca_rl1_can_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
402: order by paaf.person_id';
403: -- order by paaf.person_id clause added for bug 9211063

Line 401: nvl(pay_ca_rl1_can_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)

397: and ppa1.payroll_action_id = :payroll_action_id
398: and ppa.payroll_action_id =
399: to_number(pay_ca_rl1_can_mag.get_parameter(''PAY_ACT'', ppa1.legislative_parameters))
400: and paaf.person_id =
401: nvl(pay_ca_rl1_can_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
402: order by paaf.person_id';
403: -- order by paaf.person_id clause added for bug 9211063
404:
405: hr_utility.set_location( 'pay_ca_rl1_can_mag.range_cursor',20);

Line 405: hr_utility.set_location( 'pay_ca_rl1_can_mag.range_cursor',20);

401: nvl(pay_ca_rl1_can_mag.get_parameter(''PER_ID'',ppa1.legislative_parameters),paaf.person_id)
402: order by paaf.person_id';
403: -- order by paaf.person_id clause added for bug 9211063
404:
405: hr_utility.set_location( 'pay_ca_rl1_can_mag.range_cursor',20);
406:
407: END range_cursor;
408:
409: -------------------------------------------------------------------------------

Line 475: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

471: and paa.assignment_id = paaf.assignment_id
472: and ppa1.payroll_action_id = p_pactid
473: and paaf.person_id between p_stperson and p_endperson
474: and ppa.payroll_action_id =
475: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
476: and ppa2.report_type in ('RL1','CAEOY_RL1_AMEND_PP')
477: and int.locking_action_id = paa.assignment_action_id
478: and paa1.assignment_action_id = int.locked_action_id
479: and ppa2.payroll_action_id = paa1.payroll_action_id

Line 486: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

482: not in (select paa2.assignment_action_id
483: from pay_action_interlocks pai, pay_assignment_actions paa2
484: where paa2.assignment_action_id = pai.locked_action_id
485: and paa2.payroll_action_id =
486: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
487: )
488: -- and paaf.effective_start_date condition added for bug 9142143
489: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
490: from per_all_assignments_f paaf2

Line 516: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

512: and paa.assignment_id = paaf.assignment_id
513: and ppa1.payroll_action_id = p_pactid
514: and paaf.person_id between p_stperson and p_endperson
515: and ppa.payroll_action_id =
516: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
517: and ppa2.report_type in ('RL1','CAEOY_RL1_AMEND_PP')
518: and int.locking_action_id = paa.assignment_action_id
519: and paa1.assignment_action_id = int.locked_action_id
520: and ppa2.payroll_action_id = paa1.payroll_action_id

Line 534: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

530: not in (select paa2.assignment_action_id
531: from pay_action_interlocks pai, pay_assignment_actions paa2
532: where paa2.assignment_action_id = pai.locked_action_id
533: and paa2.payroll_action_id =
534: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
535: )
536: -- and paaf.effective_start_date condition added for bug 9142143
537: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
538: from per_all_assignments_f paaf2

Line 548: hr_utility.set_location( 'pay_ca_rl1_can_mag.create_assignement_act',10);

544:
545: -- hr_utility.trace_on('Y','RL1MAG');
546:
547: l_prev_payact := -1;
548: hr_utility.set_location( 'pay_ca_rl1_can_mag.create_assignement_act',10);
549:
550: get_report_parameters(
551: p_pactid,
552: l_year_start,

Line 564: hr_utility.set_location( 'pay_ca_rl1_can_mag.create_assignement_act',20);

560: l_business_group_id,
561: l_year_end);
562:
563:
564: hr_utility.set_location( 'pay_ca_rl1_can_mag.create_assignement_act',20);
565:
566: l_asg_set_id := to_number(pay_ca_rl1_can_mag.get_parameter('ASG_SET_ID',l_legislative_parameters));
567: hr_utility.trace('Assignment Set Id : '|| to_char(l_asg_set_id));
568:

Line 566: l_asg_set_id := to_number(pay_ca_rl1_can_mag.get_parameter('ASG_SET_ID',l_legislative_parameters));

562:
563:
564: hr_utility.set_location( 'pay_ca_rl1_can_mag.create_assignement_act',20);
565:
566: l_asg_set_id := to_number(pay_ca_rl1_can_mag.get_parameter('ASG_SET_ID',l_legislative_parameters));
567: hr_utility.trace('Assignment Set Id : '|| to_char(l_asg_set_id));
568:
569: IF l_asg_set_id IS NOT NULL THEN
570: OPEN c_all_asg_in_asgset;

Line 575: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 23);

571: ELSE
572: OPEN c_all_asg;
573: END IF;
574:
575: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 23);
576:
577: LOOP
578: IF l_asg_set_id IS NOT NULL THEN
579: FETCH c_all_asg_in_asgset INTO l_person_id,

Line 586: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 25);

582: l_effective_end_date,
583: l_assignment_action_id,
584: l_payroll_act;
585:
586: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 25);
587:
588: EXIT WHEN c_all_asg_in_asgset%NOTFOUND;
589: ELSE
590: FETCH c_all_asg INTO l_person_id,

Line 597: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 30);

593: l_effective_end_date,
594: l_assignment_action_id,
595: l_payroll_act;
596:
597: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 30);
598:
599: EXIT WHEN c_all_asg%NOTFOUND;
600: END IF;
601:

Line 631: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 40);

627: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
628: hr_utility.trace('Person Id : '|| to_char(l_person_id));
629: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
630: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
631: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 40);
632:
633: SELECT pay_assignment_actions_s.nextval
634: INTO lockingactid
635: FROM dual;

Line 637: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 50);

633: SELECT pay_assignment_actions_s.nextval
634: INTO lockingactid
635: FROM dual;
636:
637: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 50);
638: hr_nonrun_asact.insact(lockingactid,
639: l_assignment_id,
640: p_pactid,
641: p_chunk,

Line 644: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 60);

640: p_pactid,
641: p_chunk,
642: l_tax_unit_id);
643:
644: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 60);
645:
646: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
647:
648: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 70);

Line 648: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 70);

644: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 60);
645:
646: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
647:
648: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 70);
649: hr_utility.trace('Interlock Created - ');
650: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
651: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
652: END LOOP;

Line 3270: END pay_ca_rl1_can_mag;

3266: pay_core_files.write_to_magtape_lob(l_final_xml_string);
3267: END;
3268: END xml_employer_record;
3269:
3270: END pay_ca_rl1_can_mag;