[Home] [Help]
170: --
171: -- Ensure name does not clash with anywhere which will be able to 'see' the
172: -- formula being validated.
173: --
174: select null into dummy from dual where exists
175: (select null
176: from ff_formulas_f a
177: where a.formula_name = p_item_name
178: and a.formula_type_id = p_formula_type_id
228: -- set error tracking information
229: hr_utility.set_location('ffdict.is_used_in_formula',2);
230: -- Check if there any rows in FDIU for this item but take into account
231: -- the business group of the formula
232: select 'X' into dummy from dual where exists
233: (select null
234: from ff_formulas_f a,
235: ff_fdi_usages_f b
236: where a.formula_id = b.formula_id
308: --
309: -- Check if there any rows in FDIU for this item but take into account
310: -- the business group of the formula
311: --
312: select 'X' into dummy from dual where exists
313: (select null
314: from ff_fdi_usages_f b,
315: ff_formulas_f a
316: where b.alternative_item_name = p_tl_user_name
568: --
569: -- Check if there any rows in FDIU for this item but take into account
570: -- the business group of the formula
571: --
572: select 'X' into dummy from dual where exists
573: (select null
574: from ff_fdi_usages_f b,
575: ff_formulas_f a
576: where b.item_name = p_user_name
660: --
661: -- Check if there any rows in FDIU for this item but take into account
662: -- the business group of the formula.
663: --
664: select 'X' into dummy from dual where exists
665: (select null
666: from ff_fdi_usages_f b,
667: ff_formulas_f a
668: where b.item_name = p_item_name
744: -- Ensure name does not clash with anywhere which will be able to 'see' the
745: -- database item being validated.
746: --
747: begin
748: select null into dummy from dual where exists
749: (select /*+ ORDERED
750: INDEX(a FF_DATABASE_ITEMS_PK)
751: INDEX(b FF_USER_ENTITIES_PK) */ null
752: from ff_database_items a,
781: )
782: ));
783: exception
784: when no_data_found then
785: select null into dummy from dual where exists
786: (select /*+ ORDERED
787: INDEX(a FF_DATABASE_ITEMS_TL_N1)
788: INDEX(b FF_USER_ENTITIES_PK) */ null
789: from ff_database_items_tl a,
874: begin
875: --
876: -- Check for clash with other FF_DATABASE_ITEMS rows.
877: --
878: select null into dummy from dual where exists
879: (select /*+ ORDERED
880: INDEX(a FF_DATABASE_ITEMS_PK)
881: INDEX(b FF_USER_ENTITIES_PK) */ null
882: from ff_database_items a,
919:
920: --
921: -- No clash against FF_DATABASE_ITEMS so check against FF_DATABASE_ITEMS_TL.
922: --
923: select null into dummy from dual where exists
924: (select /*+ ORDERED
925: INDEX(a FF_DATABASE_ITEMS_TL_N1)
926: INDEX(b FF_USER_ENTITIES_PK) */ null
927: from ff_database_items_tl a,
1003: -- Ensure name does not clash with anywhere which will be able to 'see' the
1004: -- formula being validated.
1005: --
1006: begin
1007: select null into dummy from dual where exists
1008: (select null
1009: from ff_globals_f a
1010: where a.global_name = p_item_name
1011: and
1036: )
1037: ));
1038: exception
1039: when no_data_found then
1040: select null into dummy from dual where exists
1041: (select null
1042: from ff_globals_f a
1043: , ff_globals_f_tl b
1044: where b.global_name = p_item_name
1110: -- Ensure name does not clash with anywhere which will be able to 'see' the
1111: -- formula being validated.
1112: --
1113: begin
1114: select null into dummy from dual where exists
1115: (select null
1116: from ff_globals_f a
1117: where a.global_name = p_item_name
1118: and a.global_id <> p_global_id
1144: )
1145: ));
1146: exception
1147: when no_data_found then
1148: select null into dummy from dual where exists
1149: (select null
1150: from ff_globals_f a
1151: , ff_globals_f_tl b
1152: where b.global_name = p_item_name
1220: --
1221: -- Ensure name does not clash with anywhere which will be able to 'see' the
1222: -- formula being validated.
1223: --
1224: select null into dummy from dual where exists
1225: (select null
1226: from ff_user_entities a
1227: where a.user_entity_name = p_item_name
1228: and
1291: -- Check for functions which have same name as p_item_name and class of 'U'
1292: -- or functions which have alias the same as p_item_name
1293: -- within the business group criteria
1294: --
1295: select null into dummy from dual where exists
1296: (select null
1297: from ff_functions a
1298: where
1299: (
1352: -- set error tracking information
1353: hr_utility.set_location('ffdict.will_clash_with_context',1);
1354: -- Check if there any rows in FF_CONTEXTS for this name
1355: --
1356: select 'X' into dummy from dual where exists
1357: (select null from ff_contexts where context_name = upper(p_item_name));
1358: --
1359: -- Exception not raised, so item is a context - return TRUE.
1360: return TRUE;
2127: hr_utility.set_location('ffdict.validate_rcu',1);
2128: --
2129: -- Look for any compiled formulas which use database items based on this
2130: -- route.
2131: select 'X' into dummy from dual
2132: where exists
2133: (
2134: select /*+ ORDERED
2135: INDEX(C FF_USER_ENTITIES_FK1)
2197: -- set error tracking information
2198: hr_utility.set_location('ffdict.validate_rpv',3);
2199: -- Look for any compiled formulas which use database items based on this
2200: -- user entity. Need to consider business group and legislation
2201: select 'X' into dummy from dual
2202: where exists
2203: (
2204: select /*+ ORDERED
2205: INDEX(C FF_DATABASE_ITEMS_FK1)
2350: hr_utility.set_location('ffdict.create_global_dbitem',5);
2351: --
2352: select ff_routes_s.currval, ff_route_parameters_s.currval
2353: into l_route_id, l_route_parameter_id
2354: from sys.dual;
2355: else
2356: -- set error tracking information
2357: hr_utility.set_location('ffdict.create_global_dbitem',6);
2358: --
2485: hr_utility.set_location('ffdict.delete_ftcu_check',1);
2486: --
2487: -- Look for any compiled formulas belonging to the formula type passed
2488: -- which use the context
2489: select 'X' into dummy from dual
2490: where exists
2491: (
2492: select null from ff_formulas_f a,
2493: ff_fdi_usages_f b,