APPS.FII_FA_CAT_C dependencies on FII_FA_CAT_SEGMENTS

Line 350: INSERT INTO FII_FA_CAT_SEGMENTS(

346: End if;
347:
348: end;
349:
350: INSERT INTO FII_FA_CAT_SEGMENTS(
351: flex_structure_id,
352: major_seg_name,
353: major_val_type_code,
354: major_table_name,

Line 394: FII_UTIL.Write_Log('calling FND_STATS for FII_FA_CAT_SEGMENTS');

390: g_fii_login_id
391: );
392:
393: If g_debug_flag = 'Y' then
394: FII_UTIL.Write_Log('calling FND_STATS for FII_FA_CAT_SEGMENTS');
395: End if;
396:
397: FND_STATS.gather_table_stats
398: (ownname => g_fii_schema,

Line 399: tabname => 'FII_FA_CAT_SEGMENTS');

395: End if;
396:
397: FND_STATS.gather_table_stats
398: (ownname => g_fii_schema,
399: tabname => 'FII_FA_CAT_SEGMENTS');
400:
401: If g_debug_flag = 'Y' then
402: FII_MESSAGE.Func_Succ(l_calling_fn);
403: End if;

Line 938: FROM FII_FA_CAT_SEGMENTS;

934: minor_table_name,
935: minor_value_column_name,
936: minor_id_column_name,
937: dependant_value_set_flag
938: FROM FII_FA_CAT_SEGMENTS;
939:
940: l_calling_fn varchar2(40) := 'FII_FA_CAT_ID_C.INSERT_NEW_CAT';
941:
942: BEGIN

Line 1025: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_SEGMENTS', g_fii_schema, g_retcode);

1021: -- only call get_cat_segments when called in initial mode
1022: -----------------------------------------------------------------
1023:
1024: if (g_mode = 'L') then
1025: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_SEGMENTS', g_fii_schema, g_retcode);
1026:
1027: g_phase := 'INSERT INTO FII_FA_CAT_SEGMENTS';
1028:
1029: GET_CAT_SEGMENTS;

Line 1027: g_phase := 'INSERT INTO FII_FA_CAT_SEGMENTS';

1023:
1024: if (g_mode = 'L') then
1025: FII_UTIL.TRUNCATE_TABLE('FII_FA_CAT_SEGMENTS', g_fii_schema, g_retcode);
1026:
1027: g_phase := 'INSERT INTO FII_FA_CAT_SEGMENTS';
1028:
1029: GET_CAT_SEGMENTS;
1030: end if;
1031:

Line 1034: -- FII_FA_CAT_SEGMENTS table to process the CAT IDs

1030: end if;
1031:
1032: ----------------------------------------------------
1033: -- Looping through each group of COA_IDs in the
1034: -- FII_FA_CAT_SEGMENTS table to process the CAT IDs
1035: ----------------------------------------------------
1036:
1037: FOR sss IN sss_list LOOP
1038: