APPS.FF_DATA_DICT dependencies on FF_FUNCTIONS

Line 3329: -- INSTALLATION PROCEDURE FOR : FF_FUNCTIONS

3325: END install_routes;
3326:
3327:
3328: --****************************************************************************
3329: -- INSTALLATION PROCEDURE FOR : FF_FUNCTIONS
3330: --****************************************************************************
3331:
3332: PROCEDURE install_functions(p_phase IN number)
3333: ----------------------------------------------

Line 3376: -- FF_FUNCTIONS

3372: PROCEDURE crt_exc (exception_type IN varchar2)
3373: ----------------------------------------------
3374: IS
3375: -- Reports any exceptions during the delivery of startup data to
3376: -- FF_FUNCTIONS
3377:
3378: BEGIN
3379: -- When the installation procedures encounter an error that cannot
3380: -- be handled, an exception is raised and all work is rolled back

Line 3392: hr_legislation.insert_hr_stu_exceptions('ff_functions'

3388:
3389:
3390: rollback to new_function_name;
3391:
3392: hr_legislation.insert_hr_stu_exceptions('ff_functions'
3393: , 0
3394: , exception_type
3395: , stu_rec.name);
3396:

Line 3446: delete from ff_functions

3442:
3443: -- Delete from live account using the cascade delete
3444:
3445:
3446: delete from ff_functions
3447: where name = stu_rec.name
3448: and nvl(legislation_code,'X')=nvl(stu_rec.c_leg_code,'X');
3449:
3450: END IF;

Line 3475: from ff_functions a

3471: -- already been created by a user.
3472:
3473: select distinct null
3474: into l_null_return
3475: from ff_functions a
3476: where a.name = stu_rec.name
3477: and a.business_group_id is not null
3478: and exists (select null from per_business_groups b
3479: where b.business_group_id = a.business_group_id

Line 3504: from ff_functions

3500:
3501: BEGIN
3502: select distinct null
3503: into l_null_return
3504: from ff_functions
3505: where name = stu_rec.name
3506: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
3507: and (
3508: legislation_code is null

Line 3550: select ff_functions_s.nextval

3546:
3547: FOR each_func IN distinct_function(stu_rec.name, stu_rec.c_leg_code) LOOP
3548:
3549:
3550: select ff_functions_s.nextval
3551: into l_new_surrogate_key
3552: from dual;
3553:
3554:

Line 3556: insert into ff_functions

3552: from dual;
3553:
3554:
3555: BEGIN
3556: insert into ff_functions
3557: (function_id
3558: ,business_group_id
3559: ,legislation_code
3560: ,class

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

3585:
3586:
3587: EXCEPTION WHEN OTHERS THEN
3588: hr_legislation.hrrunprc_trace_on;
3589: hr_utility.trace('ins ff_functions');
3590: hr_utility.trace('function name ' ||
3591: each_func.name);
3592: hr_utility.trace('function_id ' ||
3593: to_char(l_new_surrogate_key));