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_PMV_HELPER_TABLES_C dependencies on FII_AGGRT_NODE_GT

Line 338: -- Populate_Temp procedure ( Populates FII_AGGRT_NODE_GT table with the records from all

334: END Initialize;
335:
336:
337: -- **************************************************************************************
338: -- Populate_Temp procedure ( Populates FII_AGGRT_NODE_GT table with the records from all
339: -- the dimensions) This would store the information about the number of children of the
340: -- parent and the dimension name for an id.
341: -- **************************************************************************************
342:

Line 350: g_phase := 'Populate FII_AGGRT_NODE_GT';

346: IF (FIIDIM_Debug) THEN
347: FII_MESSAGE.Func_Ent ('FII_PMV_HELPER_TABLES_C.populate_temp');
348: END IF;
349:
350: g_phase := 'Populate FII_AGGRT_NODE_GT';
351: -- For FC Dimension
352: If (G_FC_DBI_ENABLED_FLAG = 'Y') THEN
353: g_phase :='Populate FII_AGGRT_NODE_GT for Financial Category dimension';
354: INSERT INTO FII_AGGRT_NODE_GT (

Line 353: g_phase :='Populate FII_AGGRT_NODE_GT for Financial Category dimension';

349:
350: g_phase := 'Populate FII_AGGRT_NODE_GT';
351: -- For FC Dimension
352: If (G_FC_DBI_ENABLED_FLAG = 'Y') THEN
353: g_phase :='Populate FII_AGGRT_NODE_GT for Financial Category dimension';
354: INSERT INTO FII_AGGRT_NODE_GT (
355: id,
356: no_of_children,
357: dim_short_name)

Line 354: INSERT INTO FII_AGGRT_NODE_GT (

350: g_phase := 'Populate FII_AGGRT_NODE_GT';
351: -- For FC Dimension
352: If (G_FC_DBI_ENABLED_FLAG = 'Y') THEN
353: g_phase :='Populate FII_AGGRT_NODE_GT for Financial Category dimension';
354: INSERT INTO FII_AGGRT_NODE_GT (
355: id,
356: no_of_children,
357: dim_short_name)
358:

Line 376: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

372: NEXT_LEVEL_FIN_CAT_ID,
373: subtree_freq ;
374:
375: IF (FIIDIM_Debug) THEN
376: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
377: END IF;
378:
379: -- This is done to treat the top node differently
380: UPDATE FII_AGGRT_NODE_GT

Line 380: UPDATE FII_AGGRT_NODE_GT

376: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
377: END IF;
378:
379: -- This is done to treat the top node differently
380: UPDATE FII_AGGRT_NODE_GT
381: SET no_of_children = no_of_children + 1
382: WHERE id = G_FC_TOP_NODE_ID ;
383:
384: IF (FIIDIM_Debug) THEN

Line 385: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');

381: SET no_of_children = no_of_children + 1
382: WHERE id = G_FC_TOP_NODE_ID ;
383:
384: IF (FIIDIM_Debug) THEN
385: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
386: END IF;
387:
388: ELSE
389: -- Populate the unassigned node in case the dimension is disabled

Line 392: INSERT INTO FII_AGGRT_NODE_GT (

388: ELSE
389: -- Populate the unassigned node in case the dimension is disabled
390: -- This should never be the case as FC is a mandatory dimension
391: g_phase := 'Populate the unassigned node in case the dimension is disabled';
392: INSERT INTO FII_AGGRT_NODE_GT (
393: id,
394: no_of_children,
395: dim_short_name)
396: VALUES(G_UNASSIGNED_ID, 1, 'GL_FII_FIN_ITEM');

Line 399: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

395: dim_short_name)
396: VALUES(G_UNASSIGNED_ID, 1, 'GL_FII_FIN_ITEM');
397:
398: IF (FIIDIM_Debug) THEN
399: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
400: END IF;
401: END IF;
402:
403: -- For Company Dimension

Line 405: g_phase :='Populate FII_AGGRT_NODE_GT for Company dimension';

401: END IF;
402:
403: -- For Company Dimension
404: If (G_CO_DBI_ENABLED_FLAG = 'Y') THEN
405: g_phase :='Populate FII_AGGRT_NODE_GT for Company dimension';
406: INSERT INTO FII_AGGRT_NODE_GT (
407: id,
408: no_of_children,
409: dim_short_name)

Line 406: INSERT INTO FII_AGGRT_NODE_GT (

402:
403: -- For Company Dimension
404: If (G_CO_DBI_ENABLED_FLAG = 'Y') THEN
405: g_phase :='Populate FII_AGGRT_NODE_GT for Company dimension';
406: INSERT INTO FII_AGGRT_NODE_GT (
407: id,
408: no_of_children,
409: dim_short_name)
410:

Line 427: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

423: NEXT_LEVEL_COMPANY_ID,
424: subtree_freq ;
425:
426: IF (FIIDIM_Debug) THEN
427: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
428: END IF;
429:
430: -- This is done to treat the top node differently
431: UPDATE FII_AGGRT_NODE_GT

Line 431: UPDATE FII_AGGRT_NODE_GT

427: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
428: END IF;
429:
430: -- This is done to treat the top node differently
431: UPDATE FII_AGGRT_NODE_GT
432: SET no_of_children = no_of_children + 1
433: WHERE id = G_CO_TOP_NODE_ID ;
434:
435: IF (FIIDIM_Debug) THEN

Line 436: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');

432: SET no_of_children = no_of_children + 1
433: WHERE id = G_CO_TOP_NODE_ID ;
434:
435: IF (FIIDIM_Debug) THEN
436: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
437: END IF;
438:
439: ELSE
440: -- Populate the unassigned node in case the dimension is disabled

Line 442: INSERT INTO FII_AGGRT_NODE_GT (

438:
439: ELSE
440: -- Populate the unassigned node in case the dimension is disabled
441: g_phase := 'Populate the unassigned node in case the dimension is disabled';
442: INSERT INTO FII_AGGRT_NODE_GT (
443: id,
444: no_of_children,
445: dim_short_name)
446: VALUES(G_UNASSIGNED_ID, 1, 'FII_COMPANIES');

Line 449: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

445: dim_short_name)
446: VALUES(G_UNASSIGNED_ID, 1, 'FII_COMPANIES');
447:
448: IF (FIIDIM_Debug) THEN
449: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
450: END IF;
451:
452: END IF;
453:

Line 456: g_phase :='Populate FII_AGGRT_NODE_GT for Cost Center dimension';

452: END IF;
453:
454: -- For Cost Center
455: If (G_CC_DBI_ENABLED_FLAG = 'Y') THEN
456: g_phase :='Populate FII_AGGRT_NODE_GT for Cost Center dimension';
457: INSERT INTO FII_AGGRT_NODE_GT (
458: id,
459: no_of_children,
460: dim_short_name)

Line 457: INSERT INTO FII_AGGRT_NODE_GT (

453:
454: -- For Cost Center
455: If (G_CC_DBI_ENABLED_FLAG = 'Y') THEN
456: g_phase :='Populate FII_AGGRT_NODE_GT for Cost Center dimension';
457: INSERT INTO FII_AGGRT_NODE_GT (
458: id,
459: no_of_children,
460: dim_short_name)
461:

Line 478: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

474: NEXT_LEVEL_CC_ID,
475: subtree_freq ;
476:
477: IF (FIIDIM_Debug) THEN
478: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
479: END IF;
480:
481: -- This is done to treat the top node differently
482: UPDATE FII_AGGRT_NODE_GT

Line 482: UPDATE FII_AGGRT_NODE_GT

478: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
479: END IF;
480:
481: -- This is done to treat the top node differently
482: UPDATE FII_AGGRT_NODE_GT
483: SET no_of_children = no_of_children + 1
484: WHERE id = G_CC_TOP_NODE_ID ;
485:
486: IF (FIIDIM_Debug) THEN

Line 487: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');

483: SET no_of_children = no_of_children + 1
484: WHERE id = G_CC_TOP_NODE_ID ;
485:
486: IF (FIIDIM_Debug) THEN
487: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
488: END IF;
489:
490: ELSE
491:

Line 495: INSERT INTO FII_AGGRT_NODE_GT (

491:
492: -- Populate the unassigned node in case the dimension is disabled
493: g_phase := 'Populate the unassigned node in case the dimension is disabled';
494:
495: INSERT INTO FII_AGGRT_NODE_GT (
496: id,
497: no_of_children,
498: dim_short_name)
499: VALUES(G_UNASSIGNED_ID, 1, 'HRI_CL_ORGCC');

Line 502: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

498: dim_short_name)
499: VALUES(G_UNASSIGNED_ID, 1, 'HRI_CL_ORGCC');
500:
501: IF (FIIDIM_Debug) THEN
502: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
503: END IF;
504:
505: END IF;
506:

Line 509: g_phase :='Populate FII_AGGRT_NODE_GT for User Defined dimension1';

505: END IF;
506:
507: -- For UDD1
508: If (G_UDD1_DBI_ENABLED_FLAG = 'Y') THEN
509: g_phase :='Populate FII_AGGRT_NODE_GT for User Defined dimension1';
510: INSERT INTO FII_AGGRT_NODE_GT (
511: id,
512: no_of_children,
513: dim_short_name)

Line 510: INSERT INTO FII_AGGRT_NODE_GT (

506:
507: -- For UDD1
508: If (G_UDD1_DBI_ENABLED_FLAG = 'Y') THEN
509: g_phase :='Populate FII_AGGRT_NODE_GT for User Defined dimension1';
510: INSERT INTO FII_AGGRT_NODE_GT (
511: id,
512: no_of_children,
513: dim_short_name)
514:

Line 530: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

526: NEXT_LEVEL_VALUE_ID,
527: subtree_freq ;
528:
529: IF (FIIDIM_Debug) THEN
530: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
531: END IF;
532:
533: -- This is done to treat the top node differently
534: UPDATE FII_AGGRT_NODE_GT

Line 534: UPDATE FII_AGGRT_NODE_GT

530: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
531: END IF;
532:
533: -- This is done to treat the top node differently
534: UPDATE FII_AGGRT_NODE_GT
535: SET no_of_children = no_of_children + 1
536: WHERE id = G_UDD1_TOP_NODE_ID ;
537:
538: IF (FIIDIM_Debug) THEN

Line 539: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');

535: SET no_of_children = no_of_children + 1
536: WHERE id = G_UDD1_TOP_NODE_ID ;
537:
538: IF (FIIDIM_Debug) THEN
539: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_AGGRT_NODE_GT');
540: END IF;
541:
542: ELSE
543:

Line 547: INSERT INTO FII_AGGRT_NODE_GT (

543:
544: -- Populate the unassigned node in case the dimension is disabled
545: g_phase := 'Populate the unassigned node in case the dimension is disabled';
546:
547: INSERT INTO FII_AGGRT_NODE_GT (
548: id,
549: no_of_children,
550: dim_short_name)
551: VALUES(G_UNASSIGNED_ID, 1, 'FII_USER_DEFINED_1');

Line 554: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');

550: dim_short_name)
551: VALUES(G_UNASSIGNED_ID, 1, 'FII_USER_DEFINED_1');
552:
553: IF (FIIDIM_Debug) THEN
554: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_AGGRT_NODE_GT');
555: END IF;
556:
557: END IF;
558:

Line 584: from fii_aggrt_node_gt

580:
581: -- cursor to get the number of nodes in a dimension
582: CURSOR dim_no_of_nodes is
583: select max (no_of_children) no_of_children, dim_short_name
584: from fii_aggrt_node_gt
585: group by dim_short_name
586: ORDER BY no_of_children;
587:
588: I number :=1;

Line 1268: FROM FII_AGGRT_NODE_GT

1264: SELECT MIN (no_of_children), MAX (rn)
1265: INTO l_subtree_freq, l_row_number
1266: FROM (SELECT no_of_children,
1267: row_number() over (order by NO_OF_CHILDREN desc) rn
1268: FROM FII_AGGRT_NODE_GT
1269: WHERE dim_short_name = p_dim_short_name)
1270: WHERE rn < = G_OPTIMUM_NODES;
1271:
1272: BEGIN

Line 1278: FROM FII_AGGRT_NODE_GT

1274: g_phase := 'Checking if we need to add 1 to the minimum frequency';
1275: SELECT 'Y' into l_bool
1276: FROM (SELECT no_of_children,
1277: row_number() over (order by NO_OF_CHILDREN desc) rn
1278: FROM FII_AGGRT_NODE_GT
1279: WHERE dim_short_name = p_dim_short_name)
1280: WHERE rn > l_row_number
1281: AND no_of_children = l_subtree_freq
1282: AND rownum <2;

Line 1295: g_phase := 'Inserting into fii_fc_pmv_agrt_nodes from fii_aggrt_node_gt';

1291: END IF;
1292:
1293: IF (p_dim_short_name = 'GL_FII_FIN_ITEM') THEN
1294:
1295: g_phase := 'Inserting into fii_fc_pmv_agrt_nodes from fii_aggrt_node_gt';
1296: Insert into FII_FC_PMV_AGRT_NODES(FIN_CATEGORY_ID,
1297: aggregated_flag,
1298: for_viewby_flag,
1299: LAST_UPDATE_DATE ,

Line 1311: FROM FII_AGGRT_NODE_GT

1307: FII_USER_ID,
1308: SYSDATE,
1309: FII_USER_ID,
1310: FII_LOGIN_ID
1311: FROM FII_AGGRT_NODE_GT
1312: where dim_short_name = p_dim_short_name
1313: AND no_of_children >= l_subtree_freq;
1314:
1315: IF (FIIDIM_Debug) THEN

Line 1320: g_phase := 'Inserting into fii_com_pmv_agrt_nodes from fii_aggrt_node_gt';

1316: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FC_PMV_AGRT_NODES');
1317: END IF;
1318: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN
1319:
1320: g_phase := 'Inserting into fii_com_pmv_agrt_nodes from fii_aggrt_node_gt';
1321: Insert into FII_COM_PMV_AGRT_NODES(COMPANY_ID,
1322: aggregated_flag,
1323: for_viewby_flag,
1324: LAST_UPDATE_DATE ,

Line 1336: FROM FII_AGGRT_NODE_GT

1332: FII_USER_ID,
1333: SYSDATE,
1334: FII_USER_ID,
1335: FII_LOGIN_ID
1336: FROM FII_AGGRT_NODE_GT
1337: where dim_short_name = p_dim_short_name
1338: AND no_of_children >= l_subtree_freq;
1339:
1340: IF (FIIDIM_Debug) THEN

Line 1346: g_phase := 'Inserting into fii_cc_pmv_agrt_nodes from fii_aggrt_node_gt';

1342: END IF;
1343:
1344: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1345:
1346: g_phase := 'Inserting into fii_cc_pmv_agrt_nodes from fii_aggrt_node_gt';
1347: Insert into FII_CC_PMV_AGRT_NODES(COST_CENTER_ID,
1348: aggregated_flag,
1349: for_viewby_flag,
1350: LAST_UPDATE_DATE ,

Line 1362: FROM FII_AGGRT_NODE_GT

1358: FII_USER_ID,
1359: SYSDATE,
1360: FII_USER_ID,
1361: FII_LOGIN_ID
1362: FROM FII_AGGRT_NODE_GT
1363: where dim_short_name = p_dim_short_name
1364: AND no_of_children >= l_subtree_freq;
1365:
1366: IF (FIIDIM_Debug) THEN

Line 1372: g_phase := 'Inserting into fii_udd1_pmv_agrt_nodes from fii_aggrt_node_gt';

1368: END IF;
1369:
1370: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1371:
1372: g_phase := 'Inserting into fii_udd1_pmv_agrt_nodes from fii_aggrt_node_gt';
1373: Insert into FII_UDD1_PMV_AGRT_NODES(UDD1_VALUE_ID,
1374: aggregated_flag,
1375: for_viewby_flag,
1376: LAST_UPDATE_DATE ,

Line 1388: FROM FII_AGGRT_NODE_GT

1384: FII_USER_ID,
1385: SYSDATE,
1386: FII_USER_ID,
1387: FII_LOGIN_ID
1388: FROM FII_AGGRT_NODE_GT
1389: where dim_short_name = p_dim_short_name
1390: AND no_of_children >= l_subtree_freq;
1391:
1392: IF (FIIDIM_Debug) THEN

Line 1785: --Secondly populate the table FII_AGGRT_NODE_GT

1781: --First do the initialization
1782: g_phase := 'Calling Initialize';
1783: Initialize;
1784:
1785: --Secondly populate the table FII_AGGRT_NODE_GT
1786: g_phase := 'Populate FII_AGGRT_NODE_GT table' ;
1787: populate_temp;
1788:
1789: --Calling Calculate_Sort_Nodes

Line 1786: g_phase := 'Populate FII_AGGRT_NODE_GT table' ;

1782: g_phase := 'Calling Initialize';
1783: Initialize;
1784:
1785: --Secondly populate the table FII_AGGRT_NODE_GT
1786: g_phase := 'Populate FII_AGGRT_NODE_GT table' ;
1787: populate_temp;
1788:
1789: --Calling Calculate_Sort_Nodes
1790: g_phase := 'Calling Calculate_sort_nodes';