DBA Data[Home] [Help]

APPS.PYNEGNET01 dependencies on FF_FORMULAS_F

Line 990: DELETE FROM ff_formulas_f

986: LOOP
987: if el_cnt in (3,9,10) then
988: lc_ff_name := element_name_list (el_cnt) || 'POST_VERTEX';
989: begin
990: DELETE FROM ff_formulas_f
991: WHERE formula_name = lc_ff_name;
992: EXCEPTION
993: WHEN NO_DATA_FOUND THEN NULL;
994: end;

Line 1042: INSERT INTO ff_formulas_f

1038: SELECT ff_formulas_s.NEXTVAL
1039: INTO ln_formula_id
1040: FROM sys.dual;
1041: --
1042: INSERT INTO ff_formulas_f
1043: (FORMULA_ID,
1044: EFFECTIVE_START_DATE,
1045: EFFECTIVE_END_DATE,
1046: BUSINESS_GROUP_ID,

Line 2172: update ff_formulas_f

2168: lc_text := REPLACE(lc_text,'{REPL2}',lc_repl2);
2169: lc_text := REPLACE(lc_text,'{REPL3}',lc_repl3);
2170: lc_ff_name := element_name_list (el_cnt) || 'POST_VERTEX';
2171: --
2172: update ff_formulas_f
2173: set formula_text = lc_text
2174: where formula_name = lc_ff_name and business_group_id is null;
2175: end if;
2176: