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