APPS.FF_DATA_DICT dependencies on FF_GLOBALS_F

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

4361: -- these record definitions.
4362:
4363: CURSOR c_global_ad(p_global_id number)
4364: IS
4365: -- This cursor is used when deleting rows from ff_globals_f.
4366: -- FF_GLOBAL_F has an after delete trigger that removes user_entities
4367: -- that have a creator_id = the global_id of the row being removed.
4368: -- When deleting these UE, the BRD UE trigger potentially deletes
4369: -- database items. This trigger invalidates all formulae that can be

Line 4430: from ff_globals_f a

4426:
4427:
4428: select distinct null
4429: into l_null_return
4430: from ff_globals_f a
4431: where exists
4432: (select null
4433: from hr_s_globals_f b
4434: where a.global_id = b.global_id

Line 4490: from ff_globals_f

4486: BEGIN
4487:
4488: select distinct global_id
4489: into l_new_global_id
4490: from ff_globals_f
4491: where global_name = r_distinct.c_true_key
4492: and business_Group_id is null
4493: and ((legislation_code is NULL and r_distinct.legislation_code is NULL)
4494: or (r_distinct.legislation_code=legislation_code));

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

4502: from dual;
4503:
4504: WHEN TOO_MANY_ROWS THEN
4505: hr_legislation.hrrunprc_trace_on;
4506: hr_utility.trace('sel ff_globals_f TMR');
4507: hr_utility.trace('global_name ' ||
4508: r_distinct.c_true_key);
4509: hr_utility.trace(':lc: ' || ':' ||
4510: r_distinct.legislation_code || ':');

Line 4542: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'

4538: -- not be raised more than once.
4539:
4540: rollback to new_global_name;
4541:
4542: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'
4543: , r_distinct.c_surrogate_key
4544: , exception_type
4545: , r_distinct.c_true_key);
4546:

Line 4570: from ff_globals_f a

4566:
4567: -- A return code of TRUE indicates that the row is required.
4568: cursor get_ff_globals is
4569: select distinct null
4570: from ff_globals_f a
4571: where a.global_name = r_distinct.c_true_key
4572: and a.business_group_id is not null
4573: and exists (select null from per_business_groups b
4574: where b.business_group_id = a.business_group_id

Line 4580: from ff_globals_f

4576:
4577: --
4578: cursor c_valid_ownership is
4579: select distinct null
4580: from ff_globals_f
4581: where global_name = r_distinct.c_true_key
4582: and nvl(legislation_code,'X')<>nvl(r_distinct.legislation_code,'X')
4583: and (legislation_code is null
4584: or r_distinct.legislation_code is null );

Line 4764: from ff_globals_f

4760: DATA_TYPE,
4761: GLOBAL_NAME,
4762: GLOBAL_DESCRIPTION,
4763: GLOBAL_VALUE
4764: from ff_globals_f
4765: where global_id = l_new_global_id
4766: )
4767: UNION
4768: (select

Line 4777: from ff_globals_f

4773: DATA_TYPE,
4774: GLOBAL_NAME,
4775: GLOBAL_DESCRIPTION,
4776: GLOBAL_VALUE
4777: from ff_globals_f
4778: where global_id = l_new_global_id
4779: MINUS
4780: select
4781: EFFECTIVE_START_DATE,

Line 4822: delete from ff_globals_f

4818: where user_entity_id = (select user_entity_id
4819: from ff_user_entities
4820: where user_entity_name = r_distinct.c_true_key || '_GLOBAL_UE');
4821:
4822: delete from ff_globals_f
4823: where global_id = r_distinct.c_surrogate_key;
4824:
4825: FOR each_row IN c_each_row(r_distinct.c_surrogate_key)
4826: LOOP

Line 4832: insert into ff_globals_f

4828: r_each_row := each_row;
4829:
4830:
4831: BEGIN
4832: insert into ff_globals_f
4833: (GLOBAL_ID
4834: ,EFFECTIVE_START_DATE
4835: ,EFFECTIVE_END_DATE
4836: ,BUSINESS_GROUP_ID

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

4861: ,r_each_row.CREATION_DATE);
4862:
4863: EXCEPTION WHEN OTHERS THEN
4864: hr_legislation.hrrunprc_trace_on;
4865: hr_utility.trace('ins ff_globals_f');
4866: hr_utility.trace('GLOBAL_NAME ' ||
4867: r_each_row.GLOBAL_NAME);
4868: hr_utility.trace('GLOBAL_ID ' ||
4869: to_char(r_each_row.GLOBAL_ID));