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.PQP_NL_EXT_FUNCTIONS dependencies on HR_API

Line 106: AND new_val2 = nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))

102: SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
103: prmtr_02,prmtr_04,prmtr_05,business_group_id,object_version_number
104: FROM ben_ext_chg_evt_log
105: WHERE new_val1 = p_org_information1_o
106: AND new_val2 = nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
107: AND prmtr_01 = 'ORG'
108: AND prmtr_02 = p_org_information3_o
109: AND prmtr_04 = p_organization_id
110: AND chg_evt_cd = 'COAPPD';

Line 249: ELSIF nvl(p_org_information2,fnd_date.date_to_canonical(hr_api.g_eot)) <>

245: ,p_object_version_number => l_ovn
246: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
247: ); */
248:
249: ELSIF nvl(p_org_information2,fnd_date.date_to_canonical(hr_api.g_eot)) <>
250: nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)) THEN
251:
252: --fetch the sub category for the pension type
253: OPEN c_get_subcat(p_org_information3_o);

Line 250: nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)) THEN

246: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
247: ); */
248:
249: ELSIF nvl(p_org_information2,fnd_date.date_to_canonical(hr_api.g_eot)) <>
250: nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)) THEN
251:
252: --fetch the sub category for the pension type
253: OPEN c_get_subcat(p_org_information3_o);
254: FETCH c_get_subcat INTO l_sub_cat;

Line 688: AND new_val2 = nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))

684: SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
685: prmtr_02,business_group_id,object_version_number
686: FROM ben_ext_chg_evt_log
687: WHERE new_val1 = p_aei_information1_o
688: AND new_val2 = nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
689: AND prmtr_01 = 'ASG'
690: AND prmtr_02 = p_aei_information3_o
691: AND person_id = c_person_id
692: AND chg_evt_cd = 'COSIPD';

Line 734: ELSIF fnd_date.canonical_to_date(nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))) <>

730: ,p_old_val1 => p_aei_information1_o
731: ,p_old_val2 => p_aei_information2_o
732: );
733:
734: ELSIF fnd_date.canonical_to_date(nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))) <>
735: fnd_date.canonical_to_date(nvl(p_aei_information2,fnd_date.date_to_canonical(hr_api.g_eot))) THEN
736:
737: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
738: (p_ext_chg_evt_log_id => l_log_id

Line 735: fnd_date.canonical_to_date(nvl(p_aei_information2,fnd_date.date_to_canonical(hr_api.g_eot))) THEN

731: ,p_old_val2 => p_aei_information2_o
732: );
733:
734: ELSIF fnd_date.canonical_to_date(nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))) <>
735: fnd_date.canonical_to_date(nvl(p_aei_information2,fnd_date.date_to_canonical(hr_api.g_eot))) THEN
736:
737: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
738: (p_ext_chg_evt_log_id => l_log_id
739: ,p_chg_evt_cd => 'COSIPD'