26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_wrkplc_vldtns def
31: where def.wrkplc_vldtn_id = p_wrkplc_vldtn_id
32: and pbg.business_group_id = def.business_group_id;
33: --
34: -- Declare local variables
90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_de_wrkplc_vldtns def
95: where def.wrkplc_vldtn_id = p_wrkplc_vldtn_id
96: and pbg.business_group_id = def.business_group_id;
97: --
98: -- Declare local variables
219: --
220:
221: Cursor Vldtn_Name is
222: Select Validation_Name
223: from Pqh_De_Wrkplc_Vldtns
224: Where Validation_Name like P_Rec.Validation_Name
225: and Business_Group_Id = P_Rec.Business_Group_Id;
226:
227: l_Validation_Name Pqh_De_Wrkplc_Vldtns.Validation_Name%TYPE;
223: from Pqh_De_Wrkplc_Vldtns
224: Where Validation_Name like P_Rec.Validation_Name
225: and Business_Group_Id = P_Rec.Business_Group_Id;
226:
227: l_Validation_Name Pqh_De_Wrkplc_Vldtns.Validation_Name%TYPE;
228: l_proc varchar2(72) := g_package || 'Unique_Validation_Name';
229:
230: Begin
231: hr_utility.set_location(l_proc, 10);
239: Close Vldtn_Name;
240: Exception
241: when app_exception.application_exception then
242: if hr_multi_message.exception_add
243: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Validation_Name'
244: ) then
245: hr_utility.set_location(' Leaving:'||l_proc,60);
246: raise;
247: end if;
260: End If;
261: Exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Employment_Type'
265: ) then
266: hr_utility.set_location(' Leaving:'||l_proc,60);
267: raise;
268: end if;
281: End If;
282: Exception
283: when app_exception.application_exception then
284: if hr_multi_message.exception_add
285: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.REMUNERATION_REGULATION') then
286: hr_utility.set_location(' Leaving:'||l_proc,60);
287: raise;
288: end if;
289: hr_utility.set_location(' Leaving:'||l_proc,70);
310: Close Del;
311: Exception
312: when app_exception.application_exception then
313: if hr_multi_message.exception_add
314: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID'
315: ) then
316: hr_utility.set_location(' Leaving:'||l_proc,60);
317: raise;
318: end if;