APPS.HRDYNDBI dependencies on FF_COMPILED_INFO_F

Line 238: Fixed FF_COMPILED_INFO_F delete code so

234: fresh installs of hrglobal
235: divicker 115.121 09-JUN-2005 4363933 Add sleep to prevent too many
236: executions of worker complete loop
237: arashid 115.120 25-MAY-2005 4387272
238: Fixed FF_COMPILED_INFO_F delete code so
239: that all the affected FF_COMPILED_INFO_F
240: rows are deleted. The changes are made
241: for the partial delete cases:
242: delete_compiled_formula

Line 239: that all the affected FF_COMPILED_INFO_F

235: divicker 115.121 09-JUN-2005 4363933 Add sleep to prevent too many
236: executions of worker complete loop
237: arashid 115.120 25-MAY-2005 4387272
238: Fixed FF_COMPILED_INFO_F delete code so
239: that all the affected FF_COMPILED_INFO_F
240: rows are deleted. The changes are made
241: for the partial delete cases:
242: delete_compiled_formula
243: delete_compiled_formula_priv

Line 1132: delete ff_compiled_info_f where formula_id = r_sel_ffci.formula_id;

1128: p_business_group_id,
1129: p_startup_mode) loop
1130:
1131: delete ff_fdi_usages_f where formula_id = r_sel_ffci.formula_id;
1132: delete ff_compiled_info_f where formula_id = r_sel_ffci.formula_id;
1133:
1134: end loop;
1135:
1136: delete ff_user_entities a

Line 2808: delete from ff_compiled_info_f fci

2804: delete from ff_fdi_usages_f fdi
2805: where fdi.formula_id = form.formula_id
2806: and form.effective_start_date = fdi.effective_start_date;
2807:
2808: delete from ff_compiled_info_f fci
2809: where fci.formula_id = form.formula_id
2810: and form.effective_start_date = fci.effective_start_date;
2811:
2812: end if;

Line 2894: Bulk delete FF_COMPILED_INFO_F using FORMULA_ID and

2890: NAME
2891: ff_compiled_info_del
2892:
2893: DESCRIPTION
2894: Bulk delete FF_COMPILED_INFO_F using FORMULA_ID and
2895: EFFECTIVE_START_DATE from FF_FDI_USAGES_F.
2896: */
2897: procedure ff_compiled_info_del
2898: (p_formula_ids dbms_sql.number_table

Line 2924: from ff_compiled_info_f

2920: end if;
2921:
2922: forall j in l_lower_limit .. l_upper_limit
2923: delete
2924: from ff_compiled_info_f
2925: where formula_id = p_formula_ids(j)
2926: and effective_start_date = p_start_dates(j)
2927: ;
2928:

Line 5621: from ff_compiled_info_f fci

5617: ;
5618:
5619: forall i in 1 .. l_rowids.count
5620: delete
5621: from ff_compiled_info_f fci
5622: where fci.formula_id = l_formula_ids(i)
5623: and fci.effective_start_date = l_start_dates(i)
5624: ;
5625:

Line 7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';

7893: statem,
7894: dbms_sql.v7);
7895: ignore := dbms_sql.execute(sql_cur);
7896: dbms_sql.close_cursor(sql_cur);
7897: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7898: sql_cur := dbms_sql.open_cursor;
7899: dbms_sql.parse(sql_cur,
7900: statem,
7901: dbms_sql.v7);