[Home] [Help]
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
179: and
180: ( startup_mode = 'MASTER'
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
236: and (b.item_name = p_item_name or
237: b.alternative_item_name = p_item_name)
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
316: and a.formula_id = b.formula_id
317: and a.effective_start_date = b.effective_start_date
318: and
389: , b.effective_end_date
390: , a.business_group_id
391: , a.legislation_code
392: from ff_fdi_usages_f b,
393: ff_formulas_f a
394: where b.alternative_item_name = p_tl_user_name
395: and a.formula_id = b.formula_id
396: and a.effective_start_date = b.effective_start_date
397: and a.effective_end_date = b.effective_end_date
430: , b.effective_end_date
431: , a.business_group_id
432: , a.legislation_code
433: from ff_fdi_usages_f b,
434: ff_formulas_f a
435: where b.item_name = p_tl_user_name
436: and a.formula_id = b.formula_id
437: and a.effective_start_date = b.effective_start_date
438: and a.effective_end_date = b.effective_end_date
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
576: and a.formula_id = b.formula_id
577: and a.effective_start_date = b.effective_start_date
578: and
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
668: and b.usage <> 'D'
669: and a.formula_id = b.formula_id
670: and a.effective_start_date = b.effective_start_date
1428: rgeflg varchar2(1);
1429: --
1430: cursor csr_formula_clash(p_startup_mode varchar2) is
1431: select 'X'
1432: from ff_formulas_f ff
1433: where upper(ff.formula_name) = upper(p_formula_name)
1434: and ff.formula_type_id = p_formula_type_id
1435: and p_effective_start_date between ff.effective_start_date
1436: and ff.effective_end_date
1455: and ff.legislation_code = p_leg_code))));
1456: --
1457: cursor csr_new_end_date(p_startup_mode varchar2) is
1458: select (min(ff.effective_start_date)-1)
1459: from ff_formulas_f ff
1460: where ff.formula_name = p_formula_name
1461: and ff.formula_type_id = p_formula_type_id
1462: and p_effective_end_date between ff.effective_start_date
1463: and ff.effective_end_date
1483: --
1484: l_dummy varchar2(1);
1485: l_effective_end_date date := null;
1486: l_startup_mode varchar2(10);
1487: l_name ff_formulas_f.formula_name%type := p_formula_name;
1488: l_pdummy varchar2(80);
1489: --
1490: begin
1491: --
2200: (
2201: select /*+ ORDERED
2202: INDEX(C FF_DATABASE_ITEMS_FK1)
2203: INDEX(A FF_FDI_USAGES_F_N50)
2204: INDEX(B FF_FORMULAS_F_PK) */ null
2205: from ff_database_items c,
2206: ff_fdi_usages_f a,
2207: ff_formulas_f b
2208: where a.formula_id = b.formula_id
2203: INDEX(A FF_FDI_USAGES_F_N50)
2204: INDEX(B FF_FORMULAS_F_PK) */ null
2205: from ff_database_items c,
2206: ff_fdi_usages_f a,
2207: ff_formulas_f b
2208: where a.formula_id = b.formula_id
2209: and a.item_name = c.user_name
2210: and a.usage = 'D'
2211: and c.user_entity_id = p_user_entity_id
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,
2491: ff_contexts c
2492: where a.formula_type_id = p_ftype_id
2493: and a.formula_id = b.formula_id