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.PER_ES_ORG_INFO dependencies on HR_ES_UTILITY

Line 65: hr_es_utility.validate_cif(p_org_information5);

61: FETCH get_business_group into l_business_group_id;
62: CLOSE get_business_group;
63: --
64: IF p_org_info_type_code='ES_STATUTORY_INFO' THEN
65: hr_es_utility.validate_cif(p_org_information5);
66: hr_es_utility.unique_cif(null,p_org_information5,l_business_group_id,p_effective_date);
67: hr_es_utility.validate_cac(p_org_information8);
68: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
69: END IF;

Line 66: hr_es_utility.unique_cif(null,p_org_information5,l_business_group_id,p_effective_date);

62: CLOSE get_business_group;
63: --
64: IF p_org_info_type_code='ES_STATUTORY_INFO' THEN
65: hr_es_utility.validate_cif(p_org_information5);
66: hr_es_utility.unique_cif(null,p_org_information5,l_business_group_id,p_effective_date);
67: hr_es_utility.validate_cac(p_org_information8);
68: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
69: END IF;
70: --

Line 67: hr_es_utility.validate_cac(p_org_information8);

63: --
64: IF p_org_info_type_code='ES_STATUTORY_INFO' THEN
65: hr_es_utility.validate_cif(p_org_information5);
66: hr_es_utility.unique_cif(null,p_org_information5,l_business_group_id,p_effective_date);
67: hr_es_utility.validate_cac(p_org_information8);
68: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
69: END IF;
70: --
71: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN

Line 68: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);

64: IF p_org_info_type_code='ES_STATUTORY_INFO' THEN
65: hr_es_utility.validate_cif(p_org_information5);
66: hr_es_utility.unique_cif(null,p_org_information5,l_business_group_id,p_effective_date);
67: hr_es_utility.validate_cac(p_org_information8);
68: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
69: END IF;
70: --
71: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
72: hr_es_utility.validate_cac(p_org_information1);

Line 72: hr_es_utility.validate_cac(p_org_information1);

68: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
69: END IF;
70: --
71: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
72: hr_es_utility.validate_cac(p_org_information1);
73: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
74: --
75: l_chk := 'N';
76: OPEN csr_chk_contribution_ac_type(l_business_group_id,p_org_information1,p_org_information4,p_effective_date);

Line 73: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

69: END IF;
70: --
71: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
72: hr_es_utility.validate_cac(p_org_information1);
73: hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
74: --
75: l_chk := 'N';
76: OPEN csr_chk_contribution_ac_type(l_business_group_id,p_org_information1,p_org_information4,p_effective_date);
77: FETCH csr_chk_contribution_ac_type into l_chk;

Line 147: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

143: END IF;
144: END IF;
145: --
146: IF p_org_info_type_code in('ES_WORK_CENTER_REF','ES_SECTION_REF') THEN
147: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
148: END IF;
149:
150: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
151: hr_es_utility.unique_ss(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

Line 151: hr_es_utility.unique_ss(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

147: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
148: END IF;
149:
150: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
151: hr_es_utility.unique_ss(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
152: END IF;
153: --
154: -- Validation for Benefit Uplift Formulas -- Employer level.
155: --

Line 254: hr_es_utility.validate_cif(p_org_information5);

250: CLOSE get_business_group;
251: --
252: IF p_org_info_type_code = 'ES_STATUTORY_INFO' THEN
253: IF p_org_information5 IS NOT NULL THEN
254: hr_es_utility.validate_cif(p_org_information5);
255: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
256: END IF;
257: IF p_org_information8 IS NOT NULL THEN
258: hr_es_utility.validate_cac(p_org_information8);

Line 255: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);

251: --
252: IF p_org_info_type_code = 'ES_STATUTORY_INFO' THEN
253: IF p_org_information5 IS NOT NULL THEN
254: hr_es_utility.validate_cif(p_org_information5);
255: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
256: END IF;
257: IF p_org_information8 IS NOT NULL THEN
258: hr_es_utility.validate_cac(p_org_information8);
259: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);

Line 258: hr_es_utility.validate_cac(p_org_information8);

254: hr_es_utility.validate_cif(p_org_information5);
255: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
256: END IF;
257: IF p_org_information8 IS NOT NULL THEN
258: hr_es_utility.validate_cac(p_org_information8);
259: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
260: END IF;
261: END IF;
262: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN

Line 259: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);

255: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
256: END IF;
257: IF p_org_information8 IS NOT NULL THEN
258: hr_es_utility.validate_cac(p_org_information8);
259: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
260: END IF;
261: END IF;
262: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
263: IF p_org_information1 IS NOT NULL THEN

Line 264: hr_es_utility.validate_cac(p_org_information1);

260: END IF;
261: END IF;
262: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
263: IF p_org_information1 IS NOT NULL THEN
264: hr_es_utility.validate_cac(p_org_information1);
265: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
266: END IF;
267: --
268: l_chk := 'N';

Line 265: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

261: END IF;
262: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
263: IF p_org_information1 IS NOT NULL THEN
264: hr_es_utility.validate_cac(p_org_information1);
265: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
266: END IF;
267: --
268: l_chk := 'N';
269: OPEN csr_chk_contribution_ac_type(l_business_group_id,p_org_information1,p_org_information4,p_effective_date);

Line 340: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

336: END IF;
337: END IF;
338: --
339: IF p_org_info_type_code in('ES_WORK_CENTER_REF','ES_SECTION_REF') THEN
340: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
341: END IF;
342: --
343: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
344: hr_es_utility.unique_ss(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

Line 344: hr_es_utility.unique_ss(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

340: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
341: END IF;
342: --
343: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
344: hr_es_utility.unique_ss(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
345: END IF;
346: --
347: -- Validation for Benefit Uplift Formulas -- Employer level.
348: --