[Home] [Help]
611: Dummy group function added to recurring input
612: values to stop formula error (see input value
613: code below for more information).
614: mwcallag 18-JUN-1993 Descriptive and key flex deletion routines now
615: delete compilied DB items from ff_fdi_usages_f
616: mwcallag 14-JUN-1993 Application id removed from both
617: delete_flexfield_dict and create_flexfield_dict
618: mwcallag 03-JUN-1993 Create descriptive and key flexfield routines
619: delete old flexfields before creation attempted.
1074: formula_id
1075: from
1076: ff_user_entities a,
1077: ff_database_items fdbi,
1078: ff_fdi_usages_f fdi
1079: where fdi.usage = 'D'
1080: and fdi.item_name = fdbi.user_name
1081: and fdbi.user_entity_id = a.user_entity_id
1082: and a.user_entity_name = p_dbi_item_name
1124: p_legislation_code,
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:
2762: ) is
2763: --
2764: cursor get_formula_ids
2765: is
2766: select /* INDEX(fdi FF_FDI_USAGES_F_N50)*/
2767: distinct fdi.formula_id,
2768: fdi.effective_start_date
2769: from
2770: ff_user_entities ent,
2768: fdi.effective_start_date
2769: from
2770: ff_user_entities ent,
2771: ff_database_items dbi,
2772: ff_fdi_usages_f fdi
2773: where fdi.item_name = dbi.user_name
2774: and fdi.usage = 'D'
2775: and ent.user_entity_id = dbi.user_entity_id
2776: and ent.creator_type = p_creator_type
2797: and nvl(b.legislation_code, p_leg_code) = p_leg_code));
2798:
2799: if num > 0 then
2800:
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
2842: l_formula_ids dbms_sql.number_table;
2843: l_start_dates dbms_sql.date_table;
2844: begin
2845:
2846: delete ff_fdi_usages_f fdi
2847: where FDI.usage = 'D'
2848: and exists (select null
2849: from ff_formulas_f f
2850: where fdi.formula_id = f.formula_id
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
2896: ,p_start_dates dbms_sql.date_table
5489: ) is
5490: select fdi.rowid
5491: , fdi.formula_id
5492: , fdi.effective_start_date
5493: from ff_fdi_usages_f fdi
5494: where exists
5495: (select null
5496: from ff_database_items dbi
5497: where fdi.item_name = dbi.user_name
5608: exit when csr_affected_fdiu_rows%notfound;
5609:
5610: forall i in 1 .. l_rowids.count
5611: delete
5612: from ff_fdi_usages_f fdi
5613: where fdi.rowid = l_rowids(i)
5614: ;
5615:
5616: forall i in 1 .. l_rowids.count
7809: -- Get FF table owner
7810: l_ret_per := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
7811: l_industry, l_per_owner);
7812:
7813: statem := 'truncate table ' || l_per_owner || '.' || 'ff_fdi_usages_f';
7814: sql_cur := dbms_sql.open_cursor;
7815: dbms_sql.parse(sql_cur,
7816: statem,
7817: dbms_sql.v7);
8897: begin
8898: --
8899: -- G_TRIGGERS_ALTERED is true for the bulk generation of balance,
8900: -- element, and input value names in HRDYNDBI. The validation assumes
8901: -- that FF_FDI_USAGES_F rows have been deleted.
8902: --
8903: if g_triggers_altered then
8904: --
8905: -- Format the translated name.