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

Line 1797: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,

1793: pjwa.itax_organization_id itx_org_id,
1794: pjwa.itax_category itx_type,
1795: pjwa.itax_yea_category itx_inc_flag,
1796: nvl(nvl(pap.prl_information1,g_bg_itax_dpnt_ref_type),'CTR_EE') dpnt_ref_type,
1797: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,
1798: pp.person_id,
1799: pp.sex,
1800: pp.date_of_birth,
1801: pjwa.leaving_reason,

Line 1932: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,

1928: pjwa.itax_organization_id itx_org_id,
1929: pjwa.itax_category itx_type,
1930: pjwa.itax_yea_category itx_inc_flag,
1931: nvl(nvl(pap.prl_information1,g_bg_itax_dpnt_ref_type),'CTR_EE') dpnt_ref_type,
1932: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,
1933: pp.person_id,
1934: pp.sex,
1935: pp.date_of_birth,
1936: pjwa.leaving_reason,

Line 5517: g_arch_option := pay_core_utils.get_parameter('ARCHIVE_OPTION',l_csr_action.legislative_parameters);

5513: g_effective_som := trunc(g_effective_date,'MM');
5514: g_effective_eom := add_months(g_effective_som,1) - 1;
5515: g_business_group_id := l_csr_action.business_group_id;
5516: g_legislation_code := l_csr_action.legislation_code;
5517: g_arch_option := pay_core_utils.get_parameter('ARCHIVE_OPTION',l_csr_action.legislative_parameters);
5518: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',l_csr_action.legislative_parameters));
5519: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
5520: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
5521: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);

Line 5518: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',l_csr_action.legislative_parameters));

5514: g_effective_eom := add_months(g_effective_som,1) - 1;
5515: g_business_group_id := l_csr_action.business_group_id;
5516: g_legislation_code := l_csr_action.legislation_code;
5517: g_arch_option := pay_core_utils.get_parameter('ARCHIVE_OPTION',l_csr_action.legislative_parameters);
5518: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',l_csr_action.legislative_parameters));
5519: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
5520: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
5521: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
5522: g_upd_force := pay_core_utils.get_parameter('UPD_FORCE',l_csr_action.legislative_parameters);

Line 5519: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));

5515: g_business_group_id := l_csr_action.business_group_id;
5516: g_legislation_code := l_csr_action.legislation_code;
5517: g_arch_option := pay_core_utils.get_parameter('ARCHIVE_OPTION',l_csr_action.legislative_parameters);
5518: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',l_csr_action.legislative_parameters));
5519: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
5520: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
5521: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
5522: g_upd_force := pay_core_utils.get_parameter('UPD_FORCE',l_csr_action.legislative_parameters);
5523: --

Line 5520: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));

5516: g_legislation_code := l_csr_action.legislation_code;
5517: g_arch_option := pay_core_utils.get_parameter('ARCHIVE_OPTION',l_csr_action.legislative_parameters);
5518: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',l_csr_action.legislative_parameters));
5519: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
5520: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
5521: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
5522: g_upd_force := pay_core_utils.get_parameter('UPD_FORCE',l_csr_action.legislative_parameters);
5523: --
5524: -- fetch latest pact

Line 5521: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);

5517: g_arch_option := pay_core_utils.get_parameter('ARCHIVE_OPTION',l_csr_action.legislative_parameters);
5518: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',l_csr_action.legislative_parameters));
5519: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
5520: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
5521: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
5522: g_upd_force := pay_core_utils.get_parameter('UPD_FORCE',l_csr_action.legislative_parameters);
5523: --
5524: -- fetch latest pact
5525: g_payroll_action_id_o := null;

Line 5522: g_upd_force := pay_core_utils.get_parameter('UPD_FORCE',l_csr_action.legislative_parameters);

5518: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',l_csr_action.legislative_parameters));
5519: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
5520: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
5521: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);
5522: g_upd_force := pay_core_utils.get_parameter('UPD_FORCE',l_csr_action.legislative_parameters);
5523: --
5524: -- fetch latest pact
5525: g_payroll_action_id_o := null;
5526: open csr_arch_pact;