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: -- Bug 7508536

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: -- Bug 7508536
72: -- 1) Allow sharing of CAC numbers at the following levels -

Line 76: hr_es_utility.validate_cac(p_org_information1);

72: -- 1) Allow sharing of CAC numbers at the following levels -
73: -- a) Amongst Work Centres
74: -- b) Between Work Centre and Legal Employer.
75: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
76: hr_es_utility.validate_cac(p_org_information1);
77: -- hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
78: --
79: --
80: -- Bug 7508536

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

73: -- a) Amongst Work Centres
74: -- b) Between Work Centre and Legal Employer.
75: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
76: hr_es_utility.validate_cac(p_org_information1);
77: -- hr_es_utility.unique_cac(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
78: --
79: --
80: -- Bug 7508536
81: -- 2) Allow sharing of Contribution Account Types

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

151: END IF;
152: END IF;
153: --
154: IF p_org_info_type_code in('ES_WORK_CENTER_REF','ES_SECTION_REF') THEN
155: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
156: END IF;
157:
158: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
159: hr_es_utility.unique_ss(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

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

155: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
156: END IF;
157:
158: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
159: hr_es_utility.unique_ss(null,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
160: END IF;
161: --
162: -- Validation for Benefit Uplift Formulas -- Employer level.
163: --

Line 262: hr_es_utility.validate_cif(p_org_information5);

258: CLOSE get_business_group;
259: --
260: IF p_org_info_type_code = 'ES_STATUTORY_INFO' THEN
261: IF p_org_information5 IS NOT NULL THEN
262: hr_es_utility.validate_cif(p_org_information5);
263: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
264: END IF;
265: IF p_org_information8 IS NOT NULL THEN
266: hr_es_utility.validate_cac(p_org_information8);

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

259: --
260: IF p_org_info_type_code = 'ES_STATUTORY_INFO' THEN
261: IF p_org_information5 IS NOT NULL THEN
262: hr_es_utility.validate_cif(p_org_information5);
263: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
264: END IF;
265: IF p_org_information8 IS NOT NULL THEN
266: hr_es_utility.validate_cac(p_org_information8);
267: 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 266: hr_es_utility.validate_cac(p_org_information8);

262: hr_es_utility.validate_cif(p_org_information5);
263: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
264: END IF;
265: IF p_org_information8 IS NOT NULL THEN
266: hr_es_utility.validate_cac(p_org_information8);
267: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
268: END IF;
269: END IF;
270: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN

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

263: hr_es_utility.unique_cif(p_org_information_id,p_org_information5,l_business_group_id,p_effective_date);
264: END IF;
265: IF p_org_information8 IS NOT NULL THEN
266: hr_es_utility.validate_cac(p_org_information8);
267: hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information8,l_business_group_id,p_effective_date);
268: END IF;
269: END IF;
270: IF p_org_info_type_code = 'ES_WORK_CENTER_DETAILS' THEN
271: -- Bug 7508536

Line 276: hr_es_utility.validate_cac(p_org_information1);

272: -- 1) Allow sharing of CAC numbers at the following levels -
273: -- a) Amongst Work Centres
274: -- b) Between Work Centre and Legal Employer.
275: IF p_org_information1 IS NOT NULL THEN
276: hr_es_utility.validate_cac(p_org_information1);
277: -- hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
278: END IF;
279: --
280: -- Bug 7508536

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

273: -- a) Amongst Work Centres
274: -- b) Between Work Centre and Legal Employer.
275: IF p_org_information1 IS NOT NULL THEN
276: hr_es_utility.validate_cac(p_org_information1);
277: -- hr_es_utility.unique_cac(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
278: END IF;
279: --
280: -- Bug 7508536
281: -- 2) Allow sharing of Contribution Account Types

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

351: END IF;
352: END IF;
353: --
354: IF p_org_info_type_code in('ES_WORK_CENTER_REF','ES_SECTION_REF') THEN
355: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
356: END IF;
357: --
358: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
359: 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 359: hr_es_utility.unique_ss(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);

355: hr_es_utility.validate_wc_sec_ref(p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
356: END IF;
357: --
358: IF p_org_info_type_code in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS') then
359: hr_es_utility.unique_ss(p_org_information_id,p_org_info_type_code,p_org_information1,l_business_group_id,p_effective_date);
360: END IF;
361: --
362: -- Validation for Benefit Uplift Formulas -- Employer level.
363: --