APPS.PER_FR_VALIDATE_DELETE_PKG dependencies on HR_ORGANIZATION_UNITS_PKG

Line 110: if hr_organization_units_pkg.get_org_class(X_Organization_Id, 'FR_SOCIETE') then

106:
107: BEGIN
108: hr_utility.set_location('pefrorrvd package entered', 1);
109:
110: if hr_organization_units_pkg.get_org_class(X_Organization_Id, 'FR_SOCIETE') then
111: open csr_estab_comp;
112: fetch csr_estab_comp into l_dummy;
113: hr_utility.set_location('FR societe!!', 10);
114: if csr_estab_comp%found then

Line 122: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CENTRE_URSSAF') then

118: end if;
119: close csr_estab_comp;
120: end if;
121:
122: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CENTRE_URSSAF') then
123: hr_utility.set_location('FR centre urssaf!!', 10);
124: open csr_estab_urssaf;
125: fetch csr_estab_urssaf into l_dummy;
126: if csr_estab_urssaf%found then

Line 144: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CENTRE_ASSEDIC') then

140: end if;
141: close csr_comp_urssaf;
142: end if;
143:
144: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CENTRE_ASSEDIC') then
145: hr_utility.set_location('FR centre assedic!!', 10);
146: open csr_estab_assedic;
147: fetch csr_estab_assedic into l_dummy;
148: if csr_estab_assedic%found then

Line 156: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_PENSION') then

152: end if;
153: close csr_estab_assedic;
154: end if;
155:
156: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_PENSION') then
157: hr_utility.set_location('FR pension!!', 9);
158: open csr_estab_pens;
159: hr_utility.set_location('FR pension!!', 10);
160: fetch csr_estab_pens into l_dummy;

Line 182: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_ASSURANCE') then

178: end if;
179: close csr_comp_pens;
180: end if;
181:
182: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_ASSURANCE') then
183: hr_utility.set_location('FR assurance!!', 10);
184: open csr_estab_insu;
185: fetch csr_estab_insu into l_dummy;
186: if csr_estab_insu%found then

Line 204: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_ETABLISSEMENT') then

200: end if;
201: close csr_comp_insu;
202: end if;
203:
204: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_ETABLISSEMENT') then
205: hr_utility.set_location('FR etablissement!!', 10);
206: open csr_comp_dads_estab;
207: fetch csr_comp_dads_estab into l_dummy;
208: if csr_comp_dads_estab%found then

Line 236: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CPAM' )then

232: end if;
233: close csr_assignments;
234: end if;
235:
236: if hr_organization_units_pkg.get_org_class(X_Organization_Id,'FR_CPAM' )then
237: hr_utility.set_location('FR cpam!!', 10);
238: open csr_cpam;
239: fetch csr_cpam into l_dummy;
240: if csr_cpam%found then