DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on PAY_MAGTAPE_GENERIC

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

836: l_Informatique_tag := 'N';
837: l_Comptabilite_tag := 'N';
838:
839: l_taxation_year
840: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
841: l_payroll_actid
842: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
843:
844: get_report_parameters(

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

838:
839: l_taxation_year
840: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
841: l_payroll_actid
842: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
843:
844: get_report_parameters(
845: l_payroll_actid,
846: l_year_start,

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

1204: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1205: SELECT
1206: pai.locked_action_id, -- Archiver asg_action_id
1207: paa.assignment_id,
1208: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1209: -- date_earned
1210: FROM
1211: pay_action_interlocks pai,
1212: pay_assignment_actions paa,

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

1221: AND ppa.payroll_action_id = paa.payroll_action_id
1222: AND pai.locked_action_id = pact.action_context_id
1223: AND pact.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
1224: AND pact.assignment_id = paa.assignment_id
1225: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1226: between paf.effective_start_date and paf.effective_end_date
1227: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1228: between ppf.effective_start_date and ppf.effective_end_date
1229: ORDER BY

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

1223: AND pact.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
1224: AND pact.assignment_id = paa.assignment_id
1225: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1226: between paf.effective_start_date and paf.effective_end_date
1227: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1228: between ppf.effective_start_date and ppf.effective_end_date
1229: ORDER BY
1230: ppf.last_name,ppf.first_name,ppf.middle_names;
1231:

Line 1525: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1521: lCode_dereleve := 45;
1522: l_authorisation_no := 46;
1523: l_authorisation_tag := 47;
1524: l_sequence_no := 48;
1525: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1526: ('TRANSFER_ACT_ID'));
1527: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1528:
1529: open c_get_report_type(l_transfer_pay_actid);

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

1523: l_authorisation_tag := 47;
1524: l_sequence_no := 48;
1525: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1526: ('TRANSFER_ACT_ID'));
1527: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1528:
1529: open c_get_report_type(l_transfer_pay_actid);
1530: fetch c_get_report_type
1531: into l_rep_type,

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

1660:
1661: end if;
1662: hr_utility.trace('XML Employee: l_mag_asg_action_id = '
1663: || to_char(l_mag_asg_action_id));
1664: hr_utility.trace('XML Employee: Transfer Payroll Action Id '||to_number(pay_magtape_generic.get_parameter_value
1665: ('TRANSFER_PAYROLL_ACTION_ID')));
1666: IF l_rep_type <> 'RL2PAPERPDF' THEN
1667: OPEN cur_parameters(l_mag_asg_action_id);
1668: FETCH cur_parameters

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

1686: l_taxation_year
1687: := pay_ca_rl2_mag.get_parameter('TAX_YEAR',
1688: l_legislative_parameters);
1689: else
1690: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1691: end if;
1692:
1693: --Annee
1694: tab_employee(lAnnee) := '' || l_taxation_year || '' || EOL;

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

3145: lProvince := 10;
3146: lCodePostal := 11;
3147:
3148: l_taxation_year
3149: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
3150: l_payroll_actid
3151: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3152:
3153: get_report_parameters(

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

3147:
3148: l_taxation_year
3149: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
3150: l_payroll_actid
3151: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3152:
3153: get_report_parameters(
3154: l_payroll_actid,
3155: l_year_start,