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_AMEND_MAG dependencies on PAY_MAGTAPE_GENERIC

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

970: lALangue := 22;
971: lNoConcepteur := 23;
972:
973: l_taxation_year
974: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
975: l_context1
976: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
977:
978: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);

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

972:
973: l_taxation_year
974: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
975: l_context1
976: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
977:
978: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
979: hr_utility.trace('XML Transmitter: l_context1 = ' || to_char(l_context1));
980:

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

1409: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1410: SELECT
1411: pai.locked_action_id, -- Archiver asg_action_id
1412: paa.assignment_id,
1413: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id),
1414: -- date_earned
1415: fai.value -- Jurisdiction
1416: FROM
1417: ff_archive_items fai,

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

1427: ppa.payroll_action_id = paa.payroll_action_id AND
1428: pai.locking_action_id = paa.assignment_action_id AND
1429: paf.assignment_id = paa.assignment_id AND
1430: ppf.person_id = paf.person_id AND
1431: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1432: between
1433: paf.effective_start_date and paf.effective_end_date AND
1434: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1435: between

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

1430: ppf.person_id = paf.person_id AND
1431: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1432: between
1433: paf.effective_start_date and paf.effective_end_date AND
1434: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1435: between
1436: ppf.effective_start_date and ppf.effective_end_date AND
1437: fai.context1 = pai.locked_action_id AND
1438: fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT' AND

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

1438: fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT' AND
1439: fai.user_entity_id = fdi.user_entity_id AND
1440: paa_arch.assignment_action_id = fai.context1 AND
1441: --paa_arch.payroll_action_id =
1442: -- to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')) AND
1443: paa_arch.assignment_action_id = pai.locked_action_id
1444: ORDER BY
1445: ppf.last_name,ppf.first_name,ppf.middle_names;
1446:

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

1641: BEGIN
1642: -- hr_utility.trace_on(null,'PDF');
1643: hr_utility.trace('Inside the Employee record proc');
1644: /*******************************************************************************/
1645: --l_rep_type:=pay_magtape_generic.get_parameter_value('REPORT_TYPE'); --
1646: l_payroll_actid
1647: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1648: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1649: SELECT ppa.report_type

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

1643: hr_utility.trace('Inside the Employee record proc');
1644: /*******************************************************************************/
1645: --l_rep_type:=pay_magtape_generic.get_parameter_value('REPORT_TYPE'); --
1646: l_payroll_actid
1647: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1648: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1649: SELECT ppa.report_type
1650: INTO l_rep_type
1651: from pay_payroll_actions ppa

Line 1767: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1763: --Added for bug 13567075 /*sbachu*/
1764: l_FraisGarde := 98;
1765: l_DeductionForce := 99;
1766:
1767: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1768: ('TRANSFER_ACT_ID'));
1769:
1770: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1771: || to_char(l_mag_asg_action_id));

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

1790: || to_char(l_date_earned));
1791: hr_utility.trace('XML Employee: l_province = ' || l_province);
1792:
1793: l_taxation_year
1794: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1795:
1796: l_authorization_header := 'No d''autorisation :';
1797:
1798: l_year := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR');

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

3246: lProvince := 12;
3247: lCodePostal := 13;
3248:
3249: l_taxation_year
3250: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
3251: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3252:
3253: hr_utility.trace ('l_cvontext1 ='||l_context1);
3254:

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

3247: lCodePostal := 13;
3248:
3249: l_taxation_year
3250: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
3251: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3252:
3253: hr_utility.trace ('l_cvontext1 ='||l_context1);
3254:
3255: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;