APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_MAGTAPE_GENERIC

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

941: l_Informatique_tag := 'N';
942: l_Comptabilite_tag := 'N';
943:
944: l_taxation_year
945: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
946: l_payroll_actid
947: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
948:
949: get_report_parameters(

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

943:
944: l_taxation_year
945: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
946: l_payroll_actid
947: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
948:
949: get_report_parameters(
950: l_payroll_actid,
951: l_year_start,

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

1361: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1362: SELECT
1363: pai.locked_action_id, -- Archiver asg_action_id
1364: paa.assignment_id,
1365: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1366: -- date_earned
1367: FROM
1368: pay_action_interlocks pai,
1369: pay_assignment_actions paa,

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

1378: AND ppa.payroll_action_id = paa.payroll_action_id
1379: AND pai.locked_action_id = pact.action_context_id
1380: AND pact.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
1381: AND pact.assignment_id = paa.assignment_id
1382: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1383: between paf.effective_start_date and paf.effective_end_date
1384: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1385: between ppf.effective_start_date and ppf.effective_end_date
1386: ORDER BY

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

1380: AND pact.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
1381: AND pact.assignment_id = paa.assignment_id
1382: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1383: between paf.effective_start_date and paf.effective_end_date
1384: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1385: between ppf.effective_start_date and ppf.effective_end_date
1386: ORDER BY
1387: ppf.last_name,ppf.first_name,ppf.middle_names;
1388:

Line 1734: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1730: l_sequence_no := 48;
1731: l_origi_slipno := 49;
1732:
1733:
1734: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1735: ('TRANSFER_ACT_ID'));
1736: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1737:
1738: open c_get_report_type(l_transfer_pay_actid);

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

1732:
1733:
1734: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1735: ('TRANSFER_ACT_ID'));
1736: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1737:
1738: open c_get_report_type(l_transfer_pay_actid);
1739: fetch c_get_report_type
1740: into l_rep_type,

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

1743: close c_get_report_type;
1744:
1745: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1746: || to_char(l_mag_asg_action_id));
1747: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1748: ('TRANSFER_PAYROLL_ACTION_ID')));
1749:
1750: OPEN cur_parameters(l_mag_asg_action_id);
1751: FETCH cur_parameters

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

1762: hr_utility.trace('XML Employee: l_date_earned = '
1763: || to_char(l_date_earned));
1764: hr_utility.trace('XML Employee: l_province = ' || l_province);
1765:
1766: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1767:
1768: --Annee
1769: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;
1770:

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

2907: lProvince := 10;
2908: lCodePostal := 11;
2909:
2910: l_taxation_year
2911: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
2912: l_payroll_actid
2913: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
2914:
2915: get_report_parameters(

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

2909:
2910: l_taxation_year
2911: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
2912: l_payroll_actid
2913: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
2914:
2915: get_report_parameters(
2916: l_payroll_actid,
2917: l_year_start,