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_MAGTAPE_GENERIC

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

816:
817: cursor c_rl_package_type is
818: select target1.ORG_INFORMATION6 Type_of_Package
819: from hr_organization_information target1
820: where target1.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
821: and target1.org_information_context = 'Prov Reporting Est';
822:
823: l_final_xml CLOB;
824: l_final_xml_string VARCHAR2(32000);

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

897: lNoConcepteur := 23;
898:
899:
900: l_taxation_year
901: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
902:
903: /* commented for bug 9142143
904: l_context1
905: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

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

901: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
902:
903: /* commented for bug 9142143
904: l_context1
905: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
906: */
907: select max(paa1.payroll_action_id)
908: into l_context1
909: from pay_assignment_actions paa,

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

910: pay_assignment_actions paa1,
911: pay_action_interlocks int
912: where int.locking_action_id = paa.assignment_action_id
913: AND paa1.assignment_action_id = int.locked_action_id
914: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
915:
916: hr_utility.trace('XML Transmitter: l_taxation_year = ' || l_taxation_year);
917: hr_utility.trace('XML Transmitter: l_context1 = ' || to_char(l_context1));
918: --hr_utility.trace('XML Transmitter: l_pre_id = ' || l_pre_id);

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

1341: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1342: SELECT
1343: pai_arch.locked_action_id,
1344: paa_mag.assignment_id,
1345: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id),
1346: fai.value,
1347: get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)
1348: FROM
1349: ff_archive_items fai,

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

1363: pai_mag.locked_action_id = pai_arch.locking_action_id AND
1364: pai_arch.locked_action_id = paa_arch.assignment_action_id AND
1365: paf.assignment_id = paa_arch.assignment_id AND
1366: ppf.person_id = paf.person_id AND
1367: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1368: between
1369: paf.effective_start_date and paf.effective_end_date AND
1370: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1371: between

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

1366: ppf.person_id = paf.person_id AND
1367: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1368: between
1369: paf.effective_start_date and paf.effective_end_date AND
1370: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id)
1371: between
1372: ppf.effective_start_date and ppf.effective_end_date AND
1373: fai.context1 = pai_arch.locked_action_id AND
1374: fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT' AND

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

1549: BEGIN
1550: -- hr_utility.trace_on(null,'PDF');
1551: hr_utility.trace('inside xml_employee_record');
1552:
1553: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1554: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1555:
1556: SELECT ppa.report_type
1557: INTO l_rep_type

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

1662: lBoxO_CA := 94;
1663: lBoxO_CB := 95;
1664: lBoxO_CC := 96;
1665: --
1666: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
1667:
1668: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1669: || to_char(l_mag_asg_action_id));
1670:

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

1686: hr_utility.trace('XML Employee: l_province = ' || l_province);
1687: hr_utility.trace('XML Employee: l_pre_id = ' || to_char(l_pre_id));
1688:
1689: l_taxation_year
1690: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1691:
1692: l_authorization_header := 'No d''autorisation :';
1693:
1694: l_year := pay_ca_archive_utils.get_archive_value(l_arch_pay_actid, 'CAEOY_TAXATION_YEAR');

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

3105: lProvince := 12;
3106: lCodePostal := 13;
3107:
3108: l_taxation_year
3109: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
3110:
3111: /* commented for bug 9142143
3112: l_context1
3113: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

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

3109: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
3110:
3111: /* commented for bug 9142143
3112: l_context1
3113: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3114: */
3115: select max(paa1.payroll_action_id)
3116: into l_context1
3117: from pay_assignment_actions paa,

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

3118: pay_assignment_actions paa1,
3119: pay_action_interlocks int
3120: where int.locking_action_id = paa.assignment_action_id
3121: AND paa1.assignment_action_id = int.locked_action_id
3122: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3123:
3124: --l_pre_id := to_number(pay_magtape_generic.get_parameter_value('PRE_ID'));
3125: --l_pre_id_t := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PRE_ID'));
3126:

Line 3124: --l_pre_id := to_number(pay_magtape_generic.get_parameter_value('PRE_ID'));

3120: where int.locking_action_id = paa.assignment_action_id
3121: AND paa1.assignment_action_id = int.locked_action_id
3122: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3123:
3124: --l_pre_id := to_number(pay_magtape_generic.get_parameter_value('PRE_ID'));
3125: --l_pre_id_t := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PRE_ID'));
3126:
3127: --hr_utility.trace('l_pre_id = ' || l_pre_id);
3128: --hr_utility.trace('l_pre_id_t = ' || l_pre_id_t);

Line 3125: --l_pre_id_t := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PRE_ID'));

3121: AND paa1.assignment_action_id = int.locked_action_id
3122: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3123:
3124: --l_pre_id := to_number(pay_magtape_generic.get_parameter_value('PRE_ID'));
3125: --l_pre_id_t := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PRE_ID'));
3126:
3127: --hr_utility.trace('l_pre_id = ' || l_pre_id);
3128: --hr_utility.trace('l_pre_id_t = ' || l_pre_id_t);
3129: