APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_FORMULAS_F

Line 3414: type t_formula_names_tab is table of ff_formulas_f.formula_name%TYPE index by binary_integer;

3410: procedure migrate_formulas is
3411: --
3412: type t_jp_formula_names_tab is table of VARCHAR2(200) index by binary_integer;
3413:
3414: type t_formula_names_tab is table of ff_formulas_f.formula_name%TYPE index by binary_integer;
3415:
3416: type t_formula_desc_tab is table of ff_formulas_f.description%TYPE index by binary_integer;
3417:
3418: l_jp_formula_names_tab t_jp_formula_names_tab;

Line 3416: type t_formula_desc_tab is table of ff_formulas_f.description%TYPE index by binary_integer;

3412: type t_jp_formula_names_tab is table of VARCHAR2(200) index by binary_integer;
3413:
3414: type t_formula_names_tab is table of ff_formulas_f.formula_name%TYPE index by binary_integer;
3415:
3416: type t_formula_desc_tab is table of ff_formulas_f.description%TYPE index by binary_integer;
3417:
3418: l_jp_formula_names_tab t_jp_formula_names_tab;
3419: l_formula_names_tab t_formula_names_tab;
3420: l_formula_desc_tab t_formula_desc_tab;

Line 3780: UPDATE ff_formulas_f

3776: --
3777:
3778: FORALL l_tab_cnt IN 1..l_jp_formula_names_tab.COUNT
3779:
3780: UPDATE ff_formulas_f
3781: SET formula_name = l_formula_names_tab(l_tab_cnt),
3782: description = l_formula_desc_tab(l_tab_cnt)
3783: WHERE formula_name LIKE hr_jp_standard_pkg.hextochar(l_jp_formula_names_tab(l_tab_cnt),'AL32UTF8')
3784: AND legislation_code = 'JP';

Line 3786: UPDATE ff_formulas_f

3782: description = l_formula_desc_tab(l_tab_cnt)
3783: WHERE formula_name LIKE hr_jp_standard_pkg.hextochar(l_jp_formula_names_tab(l_tab_cnt),'AL32UTF8')
3784: AND legislation_code = 'JP';
3785:
3786: UPDATE ff_formulas_f
3787: SET description = description || 'Obsoleted'
3788: WHERE ASCII(description) > 127
3789: AND legislation_code = 'JP';
3790:

Line 4645: FROM ff_formulas_f f,

4641: DELETE ff_compiled_info_f
4642: WHERE formula_id in (
4643: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4644: distinct f.formula_id
4645: FROM ff_formulas_f f,
4646: per_business_groups_perf bg,
4647: ff_fdi_usages_f fdu,
4648: ff_database_items fdt,
4649: ff_user_entities fue,

Line 4673: FROM ff_formulas_f f,

4669: DELETE ff_fdi_usages_f
4670: WHERE formula_id in (
4671: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4672: distinct f.formula_id
4673: FROM ff_formulas_f f,
4674: per_business_groups_perf bg,
4675: ff_fdi_usages_f fdu,
4676: ff_database_items fdt,
4677: ff_user_entities fue,

Line 4977: FROM ff_formulas_f

4973: hr_utility.set_location(l_proc, 80);
4974:
4975: SELECT COUNT(1)
4976: INTO l_count
4977: FROM ff_formulas_f
4978: WHERE legislation_code = 'JP'
4979: AND ASCII(SUBSTR(formula_name,3,1)) > 127
4980: AND description NOT LIKE '%Obsoleted';
4981: