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 894: pay_core_utils.get_legislation_rule(

890: hr_utility.trace(sql%rowcount || ' rows inserted into pay_element_entry_values_f');
891: --
892: -- Check RR_SPARSE legislation rule
893: --
894: pay_core_utils.get_legislation_rule(
895: 'RR_SPARSE',
896: 'JP',
897: l_rule_mode,
898: l_found);

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

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

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

1686: and ppa.report_type = 'JPTW'
1687: and ppa.report_qualifier = 'JP'
1688: and ppa.report_category = 'ARCHIVE'
1689: -- and ppa.action_status <> 'P'
1690: and pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', legislative_parameters) is null;
1691: /*
1692: and not exists(
1693: select null
1694: from pay_action_information pai

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

1725: --
1726: for l_pact in csr_pacts loop
1727: p_valid_upgrade := 'TRUE';
1728: --
1729: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1730: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1731: l_include_terminated_flag := 'Y';
1732: l_termination_date_from := null;
1733: l_termination_date_to := null;

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

1726: for l_pact in csr_pacts loop
1727: p_valid_upgrade := 'TRUE';
1728: --
1729: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1730: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1731: l_include_terminated_flag := 'Y';
1732: l_termination_date_from := null;
1733: l_termination_date_to := null;
1734: l_rearchive_flag := 'Y';

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

1733: l_termination_date_to := null;
1734: l_rearchive_flag := 'Y';
1735: l_inherit_archive_flag := 'Y';
1736: l_publication_period_status := 'O';
1737: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));
1738: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1739: --
1740: l_legislative_parameters := null;
1741: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));

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

1734: l_rearchive_flag := 'Y';
1735: l_inherit_archive_flag := 'Y';
1736: l_publication_period_status := 'O';
1737: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));
1738: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1739: --
1740: l_legislative_parameters := null;
1741: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));
1742: concat_parameter('ITAX_ORGANIZATION_ID', fnd_number.number_to_canonical(l_itax_organization_id));

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

1804: and ppa.action_type = 'X'
1805: and ppa.report_type = 'JPTW'
1806: and ppa.report_qualifier = 'JP'
1807: and ppa.report_category = 'ARCHIVE'
1808: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y');
1809: begin
1810: hr_utility.set_location('Entering: ' || c_proc, 10);
1811: --
1812: open csr_upgrade_required;

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

1886: and ppa.action_type = 'X'
1887: and ppa.report_type = 'JPTW'
1888: and ppa.report_qualifier = 'JP'
1889: and ppa.report_category = 'ARCHIVE'
1890: and pay_core_utils.get_parameter('UPGRADE_FLAG', ppa.legislative_parameters) = 'Y'
1891: and person.action_context_id = paa.assignment_action_id
1892: and person.action_context_type = 'AAP'
1893: and person.action_information_category = 'JP_ITAX_PERSON'
1894: and arch.action_context_id = person.action_context_id

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

2959: end if;
2960: end if;
2961: --
2962: -- Make sure the data update has not been performed already.
2963: -- pay_core_utils.get_upgrade_status cannot be used for
2964: -- legislative upgrade which requires business_group_id as mandatory parameter.
2965: -- There's possibility that business groups within "p_legislation_code" are not created yet at this point.
2966: --
2967: open csr_upgrade_status(l_upgrade_def.upgrade_definition_id);