[Home] [Help]
27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ff_functions ffn
32: where ffn.function_id = p_function_id
33: and pbg.business_group_id (+) = ffn.business_group_id;
34: --
35: -- Declare local variables
97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ff_functions ffn
102: where ffn.function_id = p_function_id
103: and pbg.business_group_id (+) = ffn.business_group_id;
104: --
105: -- Declare local variables
213: --
214: exception
215: when app_exception.application_exception then
216: if hr_multi_message.exception_add
217: (p_associated_column1 => 'FF_FUNCTIONS.LEGISLATION_CODE'
218: ) then
219: raise;
220: end if;
221: when others then
265: --
266: exception
267: when app_exception.application_exception then
268: if hr_multi_message.exception_add
269: (p_associated_column1 => 'FF_FUNCTIONS.CLASS'
270: ) then
271: raise;
272: end if;
273: end chk_class;
306: --
307: exception
308: when app_exception.application_exception then
309: if hr_multi_message.exception_add
310: (p_associated_column1 => 'FF_FUNCTIONS.DATA_TYPE'
311: ) then
312: raise;
313: end if;
314: end chk_data_type;
352: --
353: exception
354: when app_exception.application_exception then
355: if hr_multi_message.exception_add
356: (p_associated_column1 => 'FF_FUNCTIONS.NAME'
357: ) then
358: raise;
359: end if;
360: end chk_name;
396: --
397: exception
398: when app_exception.application_exception then
399: if hr_multi_message.exception_add
400: (p_associated_column1 => 'FF_FUNCTIONS.ALIAS_NAME'
401: ) then
402: raise;
403: end if;
404: end chk_alias_name;