APPS.FF_DATA_DICT dependencies on FF_FUNCTIONS

Line 3278: -- INSTALLATION PROCEDURE FOR : FF_FUNCTIONS

3274: END install_routes;
3275:
3276:
3277: --****************************************************************************
3278: -- INSTALLATION PROCEDURE FOR : FF_FUNCTIONS
3279: --****************************************************************************
3280:
3281: PROCEDURE install_functions(p_phase IN number)
3282: ----------------------------------------------

Line 3325: -- FF_FUNCTIONS

3321: PROCEDURE crt_exc (exception_type IN varchar2)
3322: ----------------------------------------------
3323: IS
3324: -- Reports any exceptions during the delivery of startup data to
3325: -- FF_FUNCTIONS
3326:
3327: BEGIN
3328: -- When the installation procedures encounter an error that cannot
3329: -- be handled, an exception is raised and all work is rolled back

Line 3341: hr_legislation.insert_hr_stu_exceptions('ff_functions'

3337:
3338:
3339: rollback to new_function_name;
3340:
3341: hr_legislation.insert_hr_stu_exceptions('ff_functions'
3342: , 0
3343: , exception_type
3344: , stu_rec.name);
3345:

Line 3395: delete from ff_functions

3391:
3392: -- Delete from live account using the cascade delete
3393:
3394:
3395: delete from ff_functions
3396: where name = stu_rec.name
3397: and nvl(legislation_code,'X')=nvl(stu_rec.c_leg_code,'X');
3398:
3399: END IF;

Line 3424: from ff_functions a

3420: -- already been created by a user.
3421:
3422: select distinct null
3423: into l_null_return
3424: from ff_functions a
3425: where a.name = stu_rec.name
3426: and a.business_group_id is not null
3427: and exists (select null from per_business_groups b
3428: where b.business_group_id = a.business_group_id

Line 3453: from ff_functions

3449:
3450: BEGIN
3451: select distinct null
3452: into l_null_return
3453: from ff_functions
3454: where name = stu_rec.name
3455: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
3456: and (
3457: legislation_code is null

Line 3499: select ff_functions_s.nextval

3495:
3496: FOR each_func IN distinct_function(stu_rec.name, stu_rec.c_leg_code) LOOP
3497:
3498:
3499: select ff_functions_s.nextval
3500: into l_new_surrogate_key
3501: from dual;
3502:
3503:

Line 3505: insert into ff_functions

3501: from dual;
3502:
3503:
3504: BEGIN
3505: insert into ff_functions
3506: (function_id
3507: ,business_group_id
3508: ,legislation_code
3509: ,class

Line 3538: hr_utility.trace('ins ff_functions');

3534:
3535:
3536: EXCEPTION WHEN OTHERS THEN
3537: hr_legislation.hrrunprc_trace_on;
3538: hr_utility.trace('ins ff_functions');
3539: hr_utility.trace('function name ' ||
3540: each_func.name);
3541: hr_utility.trace('function_id ' ||
3542: to_char(l_new_surrogate_key));