APPS.PAY_CA_RL2_MAG dependencies on PAY_MAGTAPE_GENERIC

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

948: l_Informatique_tag := 'N';
949: l_Comptabilite_tag := 'N';
950:
951: l_taxation_year
952: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
953: l_payroll_actid
954: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
955:
956: get_report_parameters(

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

950:
951: l_taxation_year
952: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
953: l_payroll_actid
954: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
955:
956: get_report_parameters(
957: l_payroll_actid,
958: l_year_start,

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

1501: CURSOR cur_parameters(p_mag_asg_action_id NUMBER) IS
1502: SELECT
1503: pai.locked_action_id, -- Archiver asg_action_id
1504: paa.assignment_id,
1505: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1506: -- date_earned
1507: FROM
1508: pay_action_interlocks pai,
1509: pay_assignment_actions paa,

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

1518: AND ppa.payroll_action_id = paa.payroll_action_id
1519: AND pai.locked_action_id = pact.action_context_id
1520: AND pact.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
1521: AND pact.assignment_id = paa.assignment_id
1522: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1523: between paf.effective_start_date and paf.effective_end_date
1524: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1525: between ppf.effective_start_date and ppf.effective_end_date
1526: ORDER BY

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

1520: AND pact.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
1521: AND pact.assignment_id = paa.assignment_id
1522: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1523: between paf.effective_start_date and paf.effective_end_date
1524: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1525: between ppf.effective_start_date and ppf.effective_end_date
1526: ORDER BY
1527: ppf.last_name,ppf.first_name,ppf.middle_names;
1528: -----------------------------------------------------------------------

Line 1545: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1541:
1542: ----------------------------------------------------------------------------------
1543:
1544: BEGIN
1545: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1546: ('TRANSFER_ACT_ID'));
1547: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1548:
1549: open c_get_report_type(l_transfer_pay_actid);

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

1543:
1544: BEGIN
1545: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1546: ('TRANSFER_ACT_ID'));
1547: l_transfer_pay_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1548:
1549: open c_get_report_type(l_transfer_pay_actid);
1550: fetch c_get_report_type
1551: into l_rep_type,

Line 1593: l_print_instruction := pay_magtape_generic.get_parameter_value('print_instruction');

1589: then
1590: l_taxation_year
1591: := pay_ca_rl2_mag.get_parameter('TAX_YEAR',
1592: l_legislative_parameters);
1593: l_print_instruction := pay_magtape_generic.get_parameter_value('print_instruction');
1594: else
1595: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1596: end if;
1597:

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

1591: := pay_ca_rl2_mag.get_parameter('TAX_YEAR',
1592: l_legislative_parameters);
1593: l_print_instruction := pay_magtape_generic.get_parameter_value('print_instruction');
1594: else
1595: l_taxation_year := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
1596: end if;
1597:
1598: fetch_rl2_xml(l_arch_action_id,
1599: l_asg_id,

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

4769: lProvince := 10;
4770: lCodePostal := 11;
4771:
4772: l_taxation_year
4773: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
4774: l_payroll_actid
4775: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
4776:
4777: get_report_parameters(

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

4771:
4772: l_taxation_year
4773: := pay_magtape_generic.get_parameter_value('REPORTING_YEAR');
4774: l_payroll_actid
4775: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
4776:
4777: get_report_parameters(
4778: l_payroll_actid,
4779: l_year_start,