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_MAGTAPE_GENERIC

Line 911: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

907: lALangue := 22;
908: lNoConcepteur := 23;
909:
910: l_taxation_year
911: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
912: l_context1
913: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
914:
915: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);

Line 913: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

909:
910: l_taxation_year
911: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
912: l_context1
913: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
914:
915: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
916: hr_utility.trace('XML Transmitter: l_context1 = ' || to_char(l_context1));
917:

Line 1434: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id),

1430: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1431: SELECT
1432: pai.locked_action_id, -- Archiver asg_action_id
1433: paa.assignment_id,
1434: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id),
1435: -- date_earned
1436: fai.value -- Jurisdiction
1437: FROM
1438: ff_archive_items fai,

Line 1452: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)

1448: ppa.payroll_action_id = paa.payroll_action_id AND
1449: pai.locking_action_id = paa.assignment_action_id AND
1450: paf.assignment_id = paa.assignment_id AND
1451: ppf.person_id = paf.person_id AND
1452: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1453: between
1454: paf.effective_start_date and paf.effective_end_date AND
1455: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1456: between

Line 1455: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)

1451: ppf.person_id = paf.person_id AND
1452: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1453: between
1454: paf.effective_start_date and paf.effective_end_date AND
1455: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1456: between
1457: ppf.effective_start_date and ppf.effective_end_date AND
1458: fai.context1 = pai.locked_action_id AND
1459: fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT' AND

Line 1463: -- to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')) AND

1459: fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT' AND
1460: fai.user_entity_id = fdi.user_entity_id AND
1461: paa_arch.assignment_action_id = fai.context1 AND
1462: --paa_arch.payroll_action_id =
1463: -- to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')) AND
1464: paa_arch.assignment_action_id = pai.locked_action_id
1465: ORDER BY
1466: ppf.last_name,ppf.first_name,ppf.middle_names;
1467:

Line 1472: --l_rep_type:=pay_magtape_generic.get_parameter_value('REPORT_TYPE'); --

1468: BEGIN
1469: --hr_utility.trace_on(null,'PDF');
1470: hr_utility.trace('inside xml_employee_record');
1471: /*******************************************************************************/
1472: --l_rep_type:=pay_magtape_generic.get_parameter_value('REPORT_TYPE'); --
1473: l_payroll_actid
1474: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1475: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1476: SELECT ppa.report_type

Line 1474: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));

1470: hr_utility.trace('inside xml_employee_record');
1471: /*******************************************************************************/
1472: --l_rep_type:=pay_magtape_generic.get_parameter_value('REPORT_TYPE'); --
1473: l_payroll_actid
1474: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1475: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1476: SELECT ppa.report_type
1477: INTO l_rep_type
1478: from pay_payroll_actions ppa

Line 1482: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1478: from pay_payroll_actions ppa
1479: where payroll_action_id=l_payroll_actid;
1480: hr_utility.trace('report_type='||l_rep_type);
1481: /******************************* ************************************/
1482: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1483: ('TRANSFER_ACT_ID'));
1484:
1485: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1486: || to_char(l_mag_asg_action_id));

Line 1524: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

1520: || to_char(l_date_earned));
1521: hr_utility.trace('XML Employee: l_province = ' || l_province);
1522:
1523: l_taxation_year
1524: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1525: if l_rep_type in ('RL1PAPERPDF','PAYCARL1AMPDF','PAYCARL1CLPDF') then
1526: l_print_instruction := pay_magtape_generic.get_parameter_value('print_instruction');
1527: end if;
1528:

Line 1526: l_print_instruction := pay_magtape_generic.get_parameter_value('print_instruction');

1522:
1523: l_taxation_year
1524: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1525: if l_rep_type in ('RL1PAPERPDF','PAYCARL1AMPDF','PAYCARL1CLPDF') then
1526: l_print_instruction := pay_magtape_generic.get_parameter_value('print_instruction');
1527: end if;
1528:
1529: fetch_rl1_xml(l_arch_action_id,
1530: l_arch_pay_actid,

Line 4227: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

4223: lProvince := 12;
4224: lCodePostal := 13;
4225:
4226: l_taxation_year
4227: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
4228: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
4229:
4230: hr_utility.trace ('l_cvontext1 ='||l_context1);
4231:

Line 4228: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

4224: lCodePostal := 13;
4225:
4226: l_taxation_year
4227: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
4228: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
4229:
4230: hr_utility.trace ('l_cvontext1 ='||l_context1);
4231:
4232: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;