DBA Data[Home] [Help]

APPS.FII_FA_CAT_C dependencies on FII_FA_CAT_DIMENSIONS

Line 477: from fii_fa_cat_dimensions dim1,

473: cursor c_major_id is
474: select distinct
475: dim1.major_value,
476: dim2.major_id
477: from fii_fa_cat_dimensions dim1,
478: fii_fa_cat_dimensions dim2
479: where dim1.major_id is null
480: and dim1.major_value = dim2.major_value(+);
481:

Line 478: fii_fa_cat_dimensions dim2

474: select distinct
475: dim1.major_value,
476: dim2.major_id
477: from fii_fa_cat_dimensions dim1,
478: fii_fa_cat_dimensions dim2
479: where dim1.major_id is null
480: and dim1.major_value = dim2.major_value(+);
481:
482: cursor c_minor_id is

Line 486: from fii_fa_cat_dimensions dim1,

482: cursor c_minor_id is
483: select distinct
484: dim1.minor_value,
485: dim2.minor_id
486: from fii_fa_cat_dimensions dim1,
487: fii_fa_cat_dimensions dim2
488: where dim1.minor_id is null
489: and dim1.minor_value = dim2.minor_value(+);
490:

Line 487: fii_fa_cat_dimensions dim2

483: select distinct
484: dim1.minor_value,
485: dim2.minor_id
486: from fii_fa_cat_dimensions dim1,
487: fii_fa_cat_dimensions dim2
488: where dim1.minor_id is null
489: and dim1.minor_value = dim2.minor_value(+);
490:
491: l_major_id_tbl num_tbl;

Line 534: 'INSERT INTO FII_FA_CAT_DIMENSIONS (

530: End if;
531:
532:
533: l_ins_stmt :=
534: 'INSERT INTO FII_FA_CAT_DIMENSIONS (
535: category_id,
536: flex_structure_id,
537: creation_date,
538: created_by,

Line 685: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' records into FII_FA_CAT_DIMENSIONS');

681:
682: execute immediate l_stmt;
683:
684: If g_debug_flag = 'Y' then
685: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' records into FII_FA_CAT_DIMENSIONS');
686: FII_UTIL.stop_timer;
687: FII_UTIL.print_timer('Duration');
688: FII_UTIL.Write_Log('');
689: End if;

Line 721: update fii_fa_cat_dimensions

717: end if;
718:
719:
720: forall i in 1..l_major_id_tbl.count
721: update fii_fa_cat_dimensions
722: set major_id = nvl(l_major_id_tbl(i), fii_fa_cat_dimensions_s.nextval)
723: where major_value = l_major_value_tbl(i);
724:
725: end if;

Line 722: set major_id = nvl(l_major_id_tbl(i), fii_fa_cat_dimensions_s.nextval)

718:
719:
720: forall i in 1..l_major_id_tbl.count
721: update fii_fa_cat_dimensions
722: set major_id = nvl(l_major_id_tbl(i), fii_fa_cat_dimensions_s.nextval)
723: where major_value = l_major_value_tbl(i);
724:
725: end if;
726:

Line 739: update fii_fa_cat_dimensions

735: l_minor_id_tbl;
736: close c_minor_id;
737:
738: forall i in 1..l_minor_id_tbl.count
739: update fii_fa_cat_dimensions
740: set minor_id = nvl(l_minor_id_tbl(i), fii_fa_cat_dimensions_s1.nextval)
741: where minor_value = l_minor_value_tbl(i);
742:
743: end if;

Line 740: set minor_id = nvl(l_minor_id_tbl(i), fii_fa_cat_dimensions_s1.nextval)

736: close c_minor_id;
737:
738: forall i in 1..l_minor_id_tbl.count
739: update fii_fa_cat_dimensions
740: set minor_id = nvl(l_minor_id_tbl(i), fii_fa_cat_dimensions_s1.nextval)
741: where minor_value = l_minor_value_tbl(i);
742:
743: end if;
744:

Line 791: -- running. So record this max cat id from fii_fa_cat_dimensions

787: -- Get the real max cat id that was inserted into CAT dimension
788: -- the g_new_max_cat_id recorded at the beginning of the program
789: -- may not necessary be the largest ID that was inserted.
790: -- New ids could have been created while the program is
791: -- running. So record this max cat id from fii_fa_cat_dimensions
792: --
793: -- Note that original g_new_max_cat_id is from FA_CATEGORIES_B,
794: --------------------------------------------------------------
795:

Line 796: g_phase := 'SELECT FROM fii_fa_cat_dimensions';

792: --
793: -- Note that original g_new_max_cat_id is from FA_CATEGORIES_B,
794: --------------------------------------------------------------
795:
796: g_phase := 'SELECT FROM fii_fa_cat_dimensions';
797:
798: SELECT MAX(category_id)
799: INTO l_tmp_max_cat_id
800: FROM fii_fa_cat_dimensions;

Line 800: FROM fii_fa_cat_dimensions;

796: g_phase := 'SELECT FROM fii_fa_cat_dimensions';
797:
798: SELECT MAX(category_id)
799: INTO l_tmp_max_cat_id
800: FROM fii_fa_cat_dimensions;
801:
802: If g_debug_flag = 'Y' then
803: FII_UTIL.Write_Log(l_calling_fn || ': l_tmp_max_cat_id: ' || to_char(l_tmp_max_cat_id));
804: End if;

Line 977: g_phase := 'TRUNCATE FII_FA_CAT_DIMENSIONS';

973: IF (g_mode = 'L') then
974:
975: --Clean up the CAT dimension table
976:
977: g_phase := 'TRUNCATE FII_FA_CAT_DIMENSIONS';
978:
979: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);
980:
981: --Update FII_CHANGE_LOG to reset MAX_CAT_ID

Line 979: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);

975: --Clean up the CAT dimension table
976:
977: g_phase := 'TRUNCATE FII_FA_CAT_DIMENSIONS';
978:
979: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);
980:
981: --Update FII_CHANGE_LOG to reset MAX_CAT_ID
982:
983: g_phase := 'UPDATE fii_change_log';

Line 1008: g_phase := 'Insert new CAT IDs into FII_FA_CAT_DIMENSIONS table';

1004: FROM fa_categories_b;
1005:
1006: IF (g_new_max_cat_id > g_max_cat_id) THEN
1007:
1008: g_phase := 'Insert new CAT IDs into FII_FA_CAT_DIMENSIONS table';
1009: If g_debug_flag = 'Y' then
1010: FII_UTIL.Write_Log(g_phase);
1011: FII_UTIL.Write_Log('');
1012: End if;

Line 1084: tabname => 'FII_FA_CAT_DIMENSIONS');

1080: -- Will seed this in RSG?
1081: -- Per DBI - needs to be done though, can take out later if needed
1082: FND_STATS.gather_table_stats
1083: (ownname => g_fii_schema,
1084: tabname => 'FII_FA_CAT_DIMENSIONS');
1085:
1086: If g_debug_flag = 'Y' then
1087: FII_MESSAGE.Func_Succ(l_calling_fn);
1088: End if;

Line 1098: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);

1094: if g_mode = 'L' then
1095:
1096: --program is run in Initial Load mode, truncate the table and reset LOG
1097:
1098: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_DIMENSIONS',g_fii_schema,g_retcode);
1099:
1100: UPDATE fii_change_log
1101: SET item_value = '0',
1102: last_update_date = sysdate,