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 712: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');

708: lALangue := 22;
709: lNoConcepteur := 23;
710:
711: l_taxation_year
712: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
713: l_context1
714: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
715:
716: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);

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

710:
711: l_taxation_year
712: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
713: l_context1
714: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
715:
716: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
717: hr_utility.trace('XML Transmitter: l_context1 = ' || to_char(l_context1));
718:

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

1063: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1064: SELECT
1065: pai.locked_action_id, -- Archiver asg_action_id
1066: paa.assignment_id,
1067: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id),
1068: -- date_earned
1069: fai.value -- Jurisdiction
1070: FROM
1071: ff_archive_items fai,

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

1081: ppa.payroll_action_id = paa.payroll_action_id AND
1082: pai.locking_action_id = paa.assignment_action_id AND
1083: paf.assignment_id = paa.assignment_id AND
1084: ppf.person_id = paf.person_id AND
1085: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1086: between
1087: paf.effective_start_date and paf.effective_end_date AND
1088: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1089: between

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

1084: ppf.person_id = paf.person_id AND
1085: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1086: between
1087: paf.effective_start_date and paf.effective_end_date AND
1088: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1089: between
1090: ppf.effective_start_date and ppf.effective_end_date AND
1091: fai.context1 = pai.locked_action_id AND
1092: fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT' AND

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

1092: fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT' AND
1093: fai.user_entity_id = fdi.user_entity_id AND
1094: paa_arch.assignment_action_id = fai.context1 AND
1095: --paa_arch.payroll_action_id =
1096: -- to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')) AND
1097: paa_arch.assignment_action_id = pai.locked_action_id
1098: ORDER BY
1099: ppf.last_name,ppf.first_name,ppf.middle_names;
1100:

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

1255: BEGIN
1256: -- hr_utility.trace_on(null,'PDF');
1257: hr_utility.trace('inside xml_employee_record');
1258: /*******************************************************************************/
1259: --l_rep_type:=pay_magtape_generic.get_parameter_value('REPORT_TYPE'); --
1260: l_payroll_actid
1261: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1262: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1263: SELECT ppa.report_type

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

1257: hr_utility.trace('inside xml_employee_record');
1258: /*******************************************************************************/
1259: --l_rep_type:=pay_magtape_generic.get_parameter_value('REPORT_TYPE'); --
1260: l_payroll_actid
1261: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1262: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1263: SELECT ppa.report_type
1264: INTO l_rep_type
1265: from pay_payroll_actions ppa

Line 1370: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1366: --SIN1 :=93;
1367: --SIN2 :=94;
1368: --SIN3 :=95;
1369:
1370: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1371: ('TRANSFER_ACT_ID'));
1372:
1373: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1374: || to_char(l_mag_asg_action_id));

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

1405: || to_char(l_date_earned));
1406: hr_utility.trace('XML Employee: l_province = ' || l_province);
1407:
1408: l_taxation_year
1409: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1410:
1411: l_authorization_header := 'No d''autorisation :';
1412:
1413: if( pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR')='2006' ) then

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

4186: lProvince := 12;
4187: lCodePostal := 13;
4188:
4189: l_taxation_year
4190: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
4191: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
4192:
4193: hr_utility.trace ('l_cvontext1 ='||l_context1);
4194:

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

4187: lCodePostal := 13;
4188:
4189: l_taxation_year
4190: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
4191: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
4192:
4193: hr_utility.trace ('l_cvontext1 ='||l_context1);
4194:
4195: tab_employer(lAnnee) := '' || l_taxation_year || '' || EOL;