[Home] [Help]
614: Dummy group function added to recurring input
615: values to stop formula error (see input value
616: code below for more information).
617: mwcallag 18-JUN-1993 Descriptive and key flex deletion routines now
618: delete compilied DB items from ff_fdi_usages_f
619: mwcallag 14-JUN-1993 Application id removed from both
620: delete_flexfield_dict and create_flexfield_dict
621: mwcallag 03-JUN-1993 Create descriptive and key flexfield routines
622: delete old flexfields before creation attempted.
1077: formula_id
1078: from
1079: ff_user_entities a,
1080: ff_database_items fdbi,
1081: ff_fdi_usages_f fdi
1082: where fdi.usage = 'D'
1083: and fdi.item_name = fdbi.user_name
1084: and fdbi.user_entity_id = a.user_entity_id
1085: and a.user_entity_name = p_dbi_item_name
1127: p_legislation_code,
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:
2765: ) is
2766: --
2767: cursor get_formula_ids
2768: is
2769: select /* INDEX(fdi FF_FDI_USAGES_F_N50)*/
2770: distinct fdi.formula_id,
2771: fdi.effective_start_date
2772: from
2773: ff_user_entities ent,
2771: fdi.effective_start_date
2772: from
2773: ff_user_entities ent,
2774: ff_database_items dbi,
2775: ff_fdi_usages_f fdi
2776: where fdi.item_name = dbi.user_name
2777: and fdi.usage = 'D'
2778: and ent.user_entity_id = dbi.user_entity_id
2779: and ent.creator_type = p_creator_type
2800: and nvl(b.legislation_code, p_leg_code) = p_leg_code));
2801:
2802: if num > 0 then
2803:
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
2845: l_formula_ids dbms_sql.number_table;
2846: l_start_dates dbms_sql.date_table;
2847: begin
2848:
2849: delete ff_fdi_usages_f fdi
2850: where FDI.usage = 'D'
2851: and exists (select null
2852: from ff_formulas_f f
2853: where fdi.formula_id = f.formula_id
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
2899: ,p_start_dates dbms_sql.date_table
5492: ) is
5493: select fdi.rowid
5494: , fdi.formula_id
5495: , fdi.effective_start_date
5496: from ff_fdi_usages_f fdi
5497: where exists
5498: (select null
5499: from ff_database_items dbi
5500: where fdi.item_name = dbi.user_name
5611: exit when csr_affected_fdiu_rows%notfound;
5612:
5613: forall i in 1 .. l_rowids.count
5614: delete
5615: from ff_fdi_usages_f fdi
5616: where fdi.rowid = l_rowids(i)
5617: ;
5618:
5619: forall i in 1 .. l_rowids.count
7886: -- Get FF table owner
7887: l_ret_per := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
7888: l_industry, l_per_owner);
7889:
7890: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7891: sql_cur := dbms_sql.open_cursor;
7892: dbms_sql.parse(sql_cur,
7893: statem,
7894: dbms_sql.v7);
8974: begin
8975: --
8976: -- G_TRIGGERS_ALTERED is true for the bulk generation of balance,
8977: -- element, and input value names in HRDYNDBI. The validation assumes
8978: -- that FF_FDI_USAGES_F rows have been deleted.
8979: --
8980: if g_triggers_altered then
8981: --
8982: -- Format the translated name.