APPS.HRDYNDBI dependencies on FF_COMPILED_INFO_F

Line 235: Fixed FF_COMPILED_INFO_F delete code so

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

Line 236: that all the affected FF_COMPILED_INFO_F

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

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

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

Line 2805: delete from ff_compiled_info_f fci

2801: delete from ff_fdi_usages_f fdi
2802: where fdi.formula_id = form.formula_id
2803: and form.effective_start_date = fdi.effective_start_date;
2804:
2805: delete from ff_compiled_info_f fci
2806: where fci.formula_id = form.formula_id
2807: and form.effective_start_date = fci.effective_start_date;
2808:
2809: end if;

Line 2891: Bulk delete FF_COMPILED_INFO_F using FORMULA_ID and

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

Line 2921: from ff_compiled_info_f

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

Line 5618: from ff_compiled_info_f fci

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

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

7816: statem,
7817: dbms_sql.v7);
7818: ignore := dbms_sql.execute(sql_cur);
7819: dbms_sql.close_cursor(sql_cur);
7820: statem := 'truncate table ' || l_per_owner || '.' || 'ff_compiled_info_f';
7821: sql_cur := dbms_sql.open_cursor;
7822: dbms_sql.parse(sql_cur,
7823: statem,
7824: dbms_sql.v7);