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_JP_GENERIC_UPGRADE_PKG dependencies on PAY_CORE_UTILS

Line 900: pay_core_utils.get_legislation_rule(

896: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
897: --
898: -- Check RR_SPARSE legislation rule
899: --
900: pay_core_utils.get_legislation_rule(
901: 'RR_SPARSE',
902: 'JP',
903: l_rule_mode,
904: l_found);

Line 915: l_rule_mode := pay_core_utils.get_upgrade_status(l_business_group_id, 'ENABLE_RR_SPARSE');

911: into l_business_group_id
912: from per_all_assignments_f
913: where assignment_id = p_assignment_id;
914: --
915: l_rule_mode := pay_core_utils.get_upgrade_status(l_business_group_id, 'ENABLE_RR_SPARSE');
916: end if;
917: -- When RR_SPARSE, create "null" result values only
918: -- for 'E'(Entry) or 'R'(Reversal) run results.
919: -- No need to create for 'I'(Indirect) and 'V'(Reversed Indirect).

Line 1696: and pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', legislative_parameters) is null;

1692: and ppa.report_type = 'JPTW'
1693: and ppa.report_qualifier = 'JP'
1694: and ppa.report_category = 'ARCHIVE'
1695: -- and ppa.action_status <> 'P'
1696: and pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', legislative_parameters) is null;
1697: /*
1698: and not exists(
1699: select null
1700: from pay_action_information pai

Line 1735: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));

1731: --
1732: for l_pact in csr_pacts loop
1733: p_valid_upgrade := 'TRUE';
1734: --
1735: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1736: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1737: l_include_terminated_flag := 'Y';
1738: l_termination_date_from := null;
1739: l_termination_date_to := null;

Line 1736: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));

1732: for l_pact in csr_pacts loop
1733: p_valid_upgrade := 'TRUE';
1734: --
1735: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1736: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1737: l_include_terminated_flag := 'Y';
1738: l_termination_date_from := null;
1739: l_termination_date_to := null;
1740: l_rearchive_flag := 'Y';

Line 1743: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));

1739: l_termination_date_to := null;
1740: l_rearchive_flag := 'Y';
1741: l_inherit_archive_flag := 'Y';
1742: l_publication_period_status := 'O';
1743: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));
1744: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1745: --
1746: l_legislative_parameters := null;
1747: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));

Line 1744: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));

1740: l_rearchive_flag := 'Y';
1741: l_inherit_archive_flag := 'Y';
1742: l_publication_period_status := 'O';
1743: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));
1744: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1745: --
1746: l_legislative_parameters := null;
1747: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));
1748: concat_parameter('ITAX_ORGANIZATION_ID', fnd_number.number_to_canonical(l_itax_organization_id));

Line 1814: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y');

1810: and ppa.action_type = 'X'
1811: and ppa.report_type = 'JPTW'
1812: and ppa.report_qualifier = 'JP'
1813: and ppa.report_category = 'ARCHIVE'
1814: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y');
1815: begin
1816: hr_utility.set_location('Entering: ' || c_proc, 10);
1817: --
1818: open csr_upgrade_required;

Line 1896: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y'

1892: and ppa.action_type = 'X'
1893: and ppa.report_type = 'JPTW'
1894: and ppa.report_qualifier = 'JP'
1895: and ppa.report_category = 'ARCHIVE'
1896: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y'
1897: and person.action_context_id = paa.assignment_action_id
1898: and person.action_context_type = 'AAP'
1899: and person.action_information_category = 'JP_ITAX_PERSON'
1900: and arch.action_context_id = person.action_context_id

Line 2437: -- pay_core_utils.get_upgrade_status cannot be used for

2433: end if;
2434: end if;
2435: --
2436: -- Make sure the data update has not been performed already.
2437: -- pay_core_utils.get_upgrade_status cannot be used for
2438: -- legislative upgrade which requires business_group_id as mandatory parameter.
2439: -- There's possibility that business groups within "p_legislation_code" are not created yet at this point.
2440: --
2441: open csr_upgrade_status(l_upgrade_def.upgrade_definition_id);