APPS.FF_DATA_DICT dependencies on FF_GLOBALS_F

Line 4314: -- This cursor is used when deleting rows from ff_globals_f.

4310: -- these record definitions.
4311:
4312: CURSOR c_global_ad(p_global_id number)
4313: IS
4314: -- This cursor is used when deleting rows from ff_globals_f.
4315: -- FF_GLOBAL_F has an after delete trigger that removes user_entities
4316: -- that have a creator_id = the global_id of the row being removed.
4317: -- When deleting these UE, the BRD UE trigger potentially deletes
4318: -- database items. This trigger invalidates all formulae that can be

Line 4379: from ff_globals_f a

4375:
4376:
4377: select distinct null
4378: into l_null_return
4379: from ff_globals_f a
4380: where exists
4381: (select null
4382: from hr_s_globals_f b
4383: where a.global_id = b.global_id

Line 4439: from ff_globals_f

4435: BEGIN
4436:
4437: select distinct global_id
4438: into l_new_global_id
4439: from ff_globals_f
4440: where global_name = r_distinct.c_true_key
4441: and business_Group_id is null
4442: and ((legislation_code is NULL and r_distinct.legislation_code is NULL)
4443: or (r_distinct.legislation_code=legislation_code));

Line 4455: hr_utility.trace('sel ff_globals_f TMR');

4451: from dual;
4452:
4453: WHEN TOO_MANY_ROWS THEN
4454: hr_legislation.hrrunprc_trace_on;
4455: hr_utility.trace('sel ff_globals_f TMR');
4456: hr_utility.trace('global_name ' ||
4457: r_distinct.c_true_key);
4458: hr_utility.trace(':lc: ' || ':' ||
4459: r_distinct.legislation_code || ':');

Line 4491: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'

4487: -- not be raised more than once.
4488:
4489: rollback to new_global_name;
4490:
4491: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'
4492: , r_distinct.c_surrogate_key
4493: , exception_type
4494: , r_distinct.c_true_key);
4495:

Line 4519: from ff_globals_f a

4515:
4516: -- A return code of TRUE indicates that the row is required.
4517: cursor get_ff_globals is
4518: select distinct null
4519: from ff_globals_f a
4520: where a.global_name = r_distinct.c_true_key
4521: and a.business_group_id is not null
4522: and exists (select null from per_business_groups b
4523: where b.business_group_id = a.business_group_id

Line 4529: from ff_globals_f

4525:
4526: --
4527: cursor c_valid_ownership is
4528: select distinct null
4529: from ff_globals_f
4530: where global_name = r_distinct.c_true_key
4531: and nvl(legislation_code,'X')<>nvl(r_distinct.legislation_code,'X')
4532: and (legislation_code is null
4533: or r_distinct.legislation_code is null );

Line 4713: from ff_globals_f

4709: DATA_TYPE,
4710: GLOBAL_NAME,
4711: GLOBAL_DESCRIPTION,
4712: GLOBAL_VALUE
4713: from ff_globals_f
4714: where global_id = l_new_global_id
4715: )
4716: UNION
4717: (select

Line 4726: from ff_globals_f

4722: DATA_TYPE,
4723: GLOBAL_NAME,
4724: GLOBAL_DESCRIPTION,
4725: GLOBAL_VALUE
4726: from ff_globals_f
4727: where global_id = l_new_global_id
4728: MINUS
4729: select
4730: EFFECTIVE_START_DATE,

Line 4771: delete from ff_globals_f

4767: where user_entity_id = (select user_entity_id
4768: from ff_user_entities
4769: where user_entity_name = r_distinct.c_true_key || '_GLOBAL_UE');
4770:
4771: delete from ff_globals_f
4772: where global_id = r_distinct.c_surrogate_key;
4773:
4774: FOR each_row IN c_each_row(r_distinct.c_surrogate_key)
4775: LOOP

Line 4781: insert into ff_globals_f

4777: r_each_row := each_row;
4778:
4779:
4780: BEGIN
4781: insert into ff_globals_f
4782: (GLOBAL_ID
4783: ,EFFECTIVE_START_DATE
4784: ,EFFECTIVE_END_DATE
4785: ,BUSINESS_GROUP_ID

Line 4814: hr_utility.trace('ins ff_globals_f');

4810: ,r_each_row.CREATION_DATE);
4811:
4812: EXCEPTION WHEN OTHERS THEN
4813: hr_legislation.hrrunprc_trace_on;
4814: hr_utility.trace('ins ff_globals_f');
4815: hr_utility.trace('GLOBAL_NAME ' ||
4816: r_each_row.GLOBAL_NAME);
4817: hr_utility.trace('GLOBAL_ID ' ||
4818: to_char(r_each_row.GLOBAL_ID));