eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_CC_MGR_SUP_C dependencies on FII_CC_MGR_HIERARCHIES

Line 335: --Begin to update the table FII_CC_MGR_HIERARCHIES

331:
332: Populate_HIER_TMP;
333:
334: ----------------------------------------------------------
335: --Begin to update the table FII_CC_MGR_HIERARCHIES
336: --by diff FII_CC_MGR_HIER_GT and FII_CC_MGR_HIERARCHIES
337: --for incremental update
338: ----------------------------------------------------------
339:

Line 336: --by diff FII_CC_MGR_HIER_GT and FII_CC_MGR_HIERARCHIES

332: Populate_HIER_TMP;
333:
334: ----------------------------------------------------------
335: --Begin to update the table FII_CC_MGR_HIERARCHIES
336: --by diff FII_CC_MGR_HIER_GT and FII_CC_MGR_HIERARCHIES
337: --for incremental update
338: ----------------------------------------------------------
339:
340: FII_UTIL.start_timer;

Line 342: g_phase := 'DELETE FROM FII_CC_MGR_HIERARCHIES';

338: ----------------------------------------------------------
339:
340: FII_UTIL.start_timer;
341:
342: g_phase := 'DELETE FROM FII_CC_MGR_HIERARCHIES';
343:
344: DELETE FROM FII_CC_MGR_HIERARCHIES
345: WHERE (mgr_id, mgr_level, direct_id, direct_level,
346: emp_id, emp_level, next_level_is_leaf, is_leaf_flag) IN

Line 344: DELETE FROM FII_CC_MGR_HIERARCHIES

340: FII_UTIL.start_timer;
341:
342: g_phase := 'DELETE FROM FII_CC_MGR_HIERARCHIES';
343:
344: DELETE FROM FII_CC_MGR_HIERARCHIES
345: WHERE (mgr_id, mgr_level, direct_id, direct_level,
346: emp_id, emp_level, next_level_is_leaf, is_leaf_flag) IN
347: (SELECT mgr_id, mgr_level, direct_id, direct_level,
348: emp_id, emp_level, next_level_is_leaf, is_leaf_flag

Line 349: FROM FII_CC_MGR_HIERARCHIES

345: WHERE (mgr_id, mgr_level, direct_id, direct_level,
346: emp_id, emp_level, next_level_is_leaf, is_leaf_flag) IN
347: (SELECT mgr_id, mgr_level, direct_id, direct_level,
348: emp_id, emp_level, next_level_is_leaf, is_leaf_flag
349: FROM FII_CC_MGR_HIERARCHIES
350: MINUS
351: SELECT mgr_id, mgr_level, direct_id, direct_level,
352: emp_id, emp_level, next_level_is_leaf, is_leaf_flag
353: FROM FII_CC_MGR_HIER_GT

Line 357: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_CC_MGR_HIERARCHIES');

353: FROM FII_CC_MGR_HIER_GT
354: WHERE aggregation_flag = 'Y');
355:
356: if g_debug_flag = 'Y' then
357: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_CC_MGR_HIERARCHIES');
358: end if;
359:
360: g_phase := 'INSERT INTO FII_CC_MGR_HIERARCHIES';
361:

Line 360: g_phase := 'INSERT INTO FII_CC_MGR_HIERARCHIES';

356: if g_debug_flag = 'Y' then
357: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_CC_MGR_HIERARCHIES');
358: end if;
359:
360: g_phase := 'INSERT INTO FII_CC_MGR_HIERARCHIES';
361:
362: INSERT INTO FII_CC_MGR_HIERARCHIES
363: (mgr_id,
364: mgr_level,

Line 362: INSERT INTO FII_CC_MGR_HIERARCHIES

358: end if;
359:
360: g_phase := 'INSERT INTO FII_CC_MGR_HIERARCHIES';
361:
362: INSERT INTO FII_CC_MGR_HIERARCHIES
363: (mgr_id,
364: mgr_level,
365: direct_id,
366: direct_level,

Line 405: FROM FII_CC_MGR_HIERARCHIES);

401: G_FII_USER_ID,
402: SYSDATE,
403: G_FII_USER_ID,
404: G_FII_LOGIN_ID
405: FROM FII_CC_MGR_HIERARCHIES);
406:
407: ---------------------------------------------------------------
408:
409: if g_debug_flag = 'Y' then

Line 411: ' rows of data into FII_CC_MGR_HIERARCHIES table');

407: ---------------------------------------------------------------
408:
409: if g_debug_flag = 'Y' then
410: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
411: ' rows of data into FII_CC_MGR_HIERARCHIES table');
412: end if;
413:
414: --Call FND_STATS to collect statistics after re-populating the tables.
415:

Line 416: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';

412: end if;
413:
414: --Call FND_STATS to collect statistics after re-populating the tables.
415:
416: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
417: FND_STATS.gather_table_stats
418: (ownname => g_fii_schema,
419: tabname => 'FII_CC_MGR_HIERARCHIES');
420:

Line 419: tabname => 'FII_CC_MGR_HIERARCHIES');

415:
416: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
417: FND_STATS.gather_table_stats
418: (ownname => g_fii_schema,
419: tabname => 'FII_CC_MGR_HIERARCHIES');
420:
421: g_phase := 'gather_table_stats for MLOG$_FII_CC_MGR_HIERARCHI';
422: FND_STATS.gather_table_stats
423: (ownname => g_fii_schema,

Line 476: g_phase := 'Truncate table FII_CC_MGR_HIERARCHIES';

472: g_phase := 'call to populate the table FII_CC_MGR_HIER_GT';
473:
474: Populate_HIER_TMP;
475:
476: g_phase := 'Truncate table FII_CC_MGR_HIERARCHIES';
477:
478: TRUNCATE_TABLE ('FII_CC_MGR_HIERARCHIES');
479:
480: g_phase := 'Insert into table FII_CC_MGR_HIERARCHIES';

Line 478: TRUNCATE_TABLE ('FII_CC_MGR_HIERARCHIES');

474: Populate_HIER_TMP;
475:
476: g_phase := 'Truncate table FII_CC_MGR_HIERARCHIES';
477:
478: TRUNCATE_TABLE ('FII_CC_MGR_HIERARCHIES');
479:
480: g_phase := 'Insert into table FII_CC_MGR_HIERARCHIES';
481:
482: INSERT /*+ APPEND */ INTO FII_CC_MGR_HIERARCHIES

Line 480: g_phase := 'Insert into table FII_CC_MGR_HIERARCHIES';

476: g_phase := 'Truncate table FII_CC_MGR_HIERARCHIES';
477:
478: TRUNCATE_TABLE ('FII_CC_MGR_HIERARCHIES');
479:
480: g_phase := 'Insert into table FII_CC_MGR_HIERARCHIES';
481:
482: INSERT /*+ APPEND */ INTO FII_CC_MGR_HIERARCHIES
483: (MGR_ID,
484: MGR_LEVEL,

Line 482: INSERT /+ APPEND / INTO FII_CC_MGR_HIERARCHIES

478: TRUNCATE_TABLE ('FII_CC_MGR_HIERARCHIES');
479:
480: g_phase := 'Insert into table FII_CC_MGR_HIERARCHIES';
481:
482: INSERT /*+ APPEND */ INTO FII_CC_MGR_HIERARCHIES
483: (MGR_ID,
484: MGR_LEVEL,
485: DIRECT_ID,
486: DIRECT_LEVEL,

Line 519: ' rows of data into FII_CC_MGR_HIERARCHIES table');

515: ---------------------------------------------------------------
516:
517: if g_debug_flag = 'Y' then
518: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
519: ' rows of data into FII_CC_MGR_HIERARCHIES table');
520: end if;
521:
522: --Call FND_STATS to collect statistics after re-populating the tables.
523:

Line 524: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';

520: end if;
521:
522: --Call FND_STATS to collect statistics after re-populating the tables.
523:
524: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
525: FND_STATS.gather_table_stats
526: (ownname => g_fii_schema,
527: tabname => 'FII_CC_MGR_HIERARCHIES');
528:

Line 527: tabname => 'FII_CC_MGR_HIERARCHIES');

523:
524: g_phase := 'gather_table_stats for FII_CC_MGR_HIERARCHIES';
525: FND_STATS.gather_table_stats
526: (ownname => g_fii_schema,
527: tabname => 'FII_CC_MGR_HIERARCHIES');
528:
529: g_phase := 'gather_table_stats for MLOG$_FII_CC_MGR_HIERARCHI';
530: FND_STATS.gather_table_stats
531: (ownname => g_fii_schema,