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

Line 823: where target1.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

819:
820: cursor c_rl_package_type is
821: select target1.ORG_INFORMATION6 Type_of_Package
822: from hr_organization_information target1
823: where target1.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
824: and target1.org_information_context = 'Prov Reporting Est';
825:
826: l_trans_number varchar2(240);
827: l_reporting_year varchar2(240);

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

930: l_Informatique_tag := 'N';
931: l_Comptabilite_tag := 'N';
932:
933: l_taxation_year
934: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
935:
936: /* commented for bug 9142143
937: l_payroll_actid
938: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/

Line 938: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/

934: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
935:
936: /* commented for bug 9142143
937: l_payroll_actid
938: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/
939:
940: select max(paa1.payroll_action_id)
941: into l_payroll_actid
942: from pay_assignment_actions paa,

Line 947: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

943: pay_assignment_actions paa1,
944: pay_action_interlocks int
945: where int.locking_action_id = paa.assignment_action_id
946: AND paa1.assignment_action_id = int.locked_action_id
947: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
948:
949: get_report_parameters(
950: l_payroll_actid,
951: l_year_start,

Line 1377: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id),

1373: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1374: SELECT
1375: pai_arch.locked_action_id,
1376: paa_mag.assignment_id,
1377: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id),
1378: pay_ca_rl2_can_mag.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)
1379: FROM
1380: per_all_people_f ppf,
1381: per_all_assignments_f paf,

Line 1397: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)

1393: pai_mag.locked_action_id = pai_arch.locking_action_id AND
1394: pai_arch.locked_action_id = paa_arch.assignment_action_id AND
1395: paf.assignment_id = paa_arch.assignment_id AND
1396: ppf.person_id = paf.person_id AND
1397: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1398: between
1399: paf.effective_start_date and paf.effective_end_date AND
1400: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1401: between

Line 1400: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)

1396: ppf.person_id = paf.person_id AND
1397: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1398: between
1399: paf.effective_start_date and paf.effective_end_date AND
1400: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1401: between
1402: ppf.effective_start_date and ppf.effective_end_date AND
1403: pact.action_information_category = 'CAEOY RL2 EMPLOYEE INFO' AND
1404: paa_arch.assignment_action_id = pact.action_context_id AND

Line 1717: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));

1713: lN_NASConjoint1 := 43;
1714: lN_NASConjoint2 := 44;
1715: lCode_dereleve := 45;
1716:
1717: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
1718: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1719:
1720: open c_get_report_type(l_transfer_pay_actid);
1721: fetch c_get_report_type

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

1714: lN_NASConjoint2 := 44;
1715: lCode_dereleve := 45;
1716:
1717: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
1718: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1719:
1720: open c_get_report_type(l_transfer_pay_actid);
1721: fetch c_get_report_type
1722: into l_rep_type,

Line 1729: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value

1725: close c_get_report_type;
1726:
1727: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1728: || to_char(l_mag_asg_action_id));
1729: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1730: ('TRANSFER_PAYROLL_ACTION_ID')));
1731:
1732: OPEN cur_parameters(l_mag_asg_action_id);
1733: FETCH cur_parameters

Line 1746: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

1742: hr_utility.trace('XML Employee: l_asg_id = ' || to_char(l_asg_id));
1743: hr_utility.trace('XML Employee: l_date_earned = '|| to_char(l_date_earned));
1744: hr_utility.trace('XML Employee: l_province = '|| l_province);
1745:
1746: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1747:
1748: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;
1749:
1750: open c_employee_infor(l_arch_action_id);

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

2734: lProvince := 10;
2735: lCodePostal := 11;
2736:
2737: l_taxation_year
2738: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
2739:
2740: /* commented for bug 9142143
2741: l_payroll_actid
2742: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/

Line 2742: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/

2738: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
2739:
2740: /* commented for bug 9142143
2741: l_payroll_actid
2742: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/
2743:
2744: select max(paa1.payroll_action_id)
2745: into l_payroll_actid
2746: from pay_assignment_actions paa,

Line 2751: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

2747: pay_assignment_actions paa1,
2748: pay_action_interlocks int
2749: where int.locking_action_id = paa.assignment_action_id
2750: AND paa1.assignment_action_id = int.locked_action_id
2751: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
2752:
2753: get_report_parameters(
2754: l_payroll_actid,
2755: l_year_start,