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_UDD1_PMV_AGRT_NODES

Line 821: update fii_udd1_pmv_agrt_nodes f

817: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
818: END IF;
819:
820: g_phase := 'Updating the User Defined Dimension 1 pmv helper table for the newly aggregated nodes';
821: update fii_udd1_pmv_agrt_nodes f
822: set aggregated_flag = (select aggregate_next_level_flag
823: from fii_udd1_hierarchies
824: where next_level_value_id = f.udd1_value_id
825: and parent_level = next_level)

Line 832: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');

828: where next_level_value_id = f.udd1_value_id
829: and parent_level = next_level);
830:
831: IF (FIIDIM_Debug) THEN
832: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
833: END IF;
834:
835: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
836: FND_STATS.gather_table_stats

Line 978: from fii_udd1_pmv_agrt_nodes

974: IF (G_PROGRAM_MODE = 'INCRE') THEN
975: g_phase := 'In IF Update fii_udd1_hierarchies and set the aggregate_next_level_flag';
976: update fii_udd1_hierarchies f
977: set aggregate_next_level_flag = (select aggregated_flag
978: from fii_udd1_pmv_agrt_nodes
979: where UDD1_VALUE_ID = f.next_level_value_id)
980: where aggregate_next_level_flag <> (select aggregated_flag
981: from fii_udd1_pmv_agrt_nodes
982: where UDD1_VALUE_ID = f.next_level_value_id);

Line 981: from fii_udd1_pmv_agrt_nodes

977: set aggregate_next_level_flag = (select aggregated_flag
978: from fii_udd1_pmv_agrt_nodes
979: where UDD1_VALUE_ID = f.next_level_value_id)
980: where aggregate_next_level_flag <> (select aggregated_flag
981: from fii_udd1_pmv_agrt_nodes
982: where UDD1_VALUE_ID = f.next_level_value_id);
983:
984: IF (FIIDIM_Debug) THEN
985: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');

Line 992: from fii_udd1_pmv_agrt_nodes

988: ELSE
989: g_phase := 'In ELSE Update fii_udd1_hierarchies and set the aggregate_next_level_flag';
990: update fii_udd1_hierarchies f
991: set aggregate_next_level_flag = (select aggregated_flag
992: from fii_udd1_pmv_agrt_nodes
993: where UDD1_VALUE_ID = f.next_level_value_id);
994:
995: IF (FIIDIM_Debug) THEN
996: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');

Line 1105: g_phase := 'Update FII_UDD1_PMV_AGRT_NODES for User Defined Dimension1';

1101: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_PMV_AGRT_NODES');
1102: END IF;
1103:
1104: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1105: g_phase := 'Update FII_UDD1_PMV_AGRT_NODES for User Defined Dimension1';
1106:
1107: UPDATE FII_UDD1_PMV_AGRT_NODES
1108: set for_viewby_flag = 'Y'
1109: WHERE udd1_value_id in ( select next_level_value_id

Line 1107: UPDATE FII_UDD1_PMV_AGRT_NODES

1103:
1104: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1105: g_phase := 'Update FII_UDD1_PMV_AGRT_NODES for User Defined Dimension1';
1106:
1107: UPDATE FII_UDD1_PMV_AGRT_NODES
1108: set for_viewby_flag = 'Y'
1109: WHERE udd1_value_id in ( select next_level_value_id
1110: from FII_UDD1_HIERARCHIES f1
1111: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')

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

1115: and f2.aggregate_next_level_flag = 'Y'
1116: and f2.parent_value_id <> f2.next_level_value_id));
1117:
1118: IF (FIIDIM_Debug) THEN
1119: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_UDD1_PMV_AGRT_NODES');
1120: END IF;
1121:
1122: END IF;
1123:

Line 1236: g_phase := 'Inserting into fii_udd1_pmv_agrt_nodes for UDD1';

1232: END IF;
1233:
1234: --For UDD1
1235: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1236: g_phase := 'Inserting into fii_udd1_pmv_agrt_nodes for UDD1';
1237: Insert into fii_udd1_pmv_agrt_nodes(UDD1_VALUE_ID,
1238: for_viewby_flag,
1239: aggregated_flag,
1240: LAST_UPDATE_DATE ,

Line 1237: Insert into fii_udd1_pmv_agrt_nodes(UDD1_VALUE_ID,

1233:
1234: --For UDD1
1235: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1236: g_phase := 'Inserting into fii_udd1_pmv_agrt_nodes for UDD1';
1237: Insert into fii_udd1_pmv_agrt_nodes(UDD1_VALUE_ID,
1238: for_viewby_flag,
1239: aggregated_flag,
1240: LAST_UPDATE_DATE ,
1241: LAST_UPDATED_BY,

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

1252: where parent_level= next_level
1253: ) ;
1254:
1255: IF (FIIDIM_Debug) THEN
1256: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
1257: END IF;
1258:
1259: END IF;
1260:

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 1373: Insert into FII_UDD1_PMV_AGRT_NODES(UDD1_VALUE_ID,

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 ,
1377: LAST_UPDATED_BY,

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

1389: where dim_short_name = p_dim_short_name
1390: AND no_of_children >= l_subtree_freq;
1391:
1392: IF (FIIDIM_Debug) THEN
1393: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
1394: END IF;
1395: END IF;
1396:
1397: -- Insert the records which will not be aggregated

Line 1497: g_phase := 'Inserting records which will not be aggregated into fii_udd1_pmv_agrt_nodes for UDD1';

1493:
1494: --For UDD1
1495: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1496:
1497: g_phase := 'Inserting records which will not be aggregated into fii_udd1_pmv_agrt_nodes for UDD1';
1498: Insert into fii_udd1_pmv_agrt_nodes(UDD1_VALUE_ID, for_viewby_flag,
1499: aggregated_flag,
1500: LAST_UPDATE_DATE ,
1501: LAST_UPDATED_BY,

Line 1498: Insert into fii_udd1_pmv_agrt_nodes(UDD1_VALUE_ID, for_viewby_flag,

1494: --For UDD1
1495: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1496:
1497: g_phase := 'Inserting records which will not be aggregated into fii_udd1_pmv_agrt_nodes for UDD1';
1498: Insert into fii_udd1_pmv_agrt_nodes(UDD1_VALUE_ID, for_viewby_flag,
1499: aggregated_flag,
1500: LAST_UPDATE_DATE ,
1501: LAST_UPDATED_BY,
1502: CREATION_DATE,

Line 1520: from fii_udd1_pmv_agrt_nodes) ;

1516: FII_USER_ID,
1517: SYSDATE,
1518: FII_USER_ID,
1519: FII_LOGIN_ID
1520: from fii_udd1_pmv_agrt_nodes) ;
1521:
1522: IF (FIIDIM_Debug) THEN
1523: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
1524: END IF;

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

1519: FII_LOGIN_ID
1520: from fii_udd1_pmv_agrt_nodes) ;
1521:
1522: IF (FIIDIM_Debug) THEN
1523: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
1524: END IF;
1525:
1526: END IF;
1527:

Line 1558: FROM FII_UDD1_PMV_AGRT_NODES

1554: FROM FII_CC_PMV_AGRT_NODES
1555: WHERE aggregated_flag = 'Y';
1556: ELSIF(p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1557: SELECT count(*) into l_nodes_aggregated
1558: FROM FII_UDD1_PMV_AGRT_NODES
1559: WHERE aggregated_flag = 'Y';
1560: END IF;
1561:
1562: -- this case won't arise but to avoid a zero divisor in the next step

Line 1623: FII_UTIL.truncate_table ('FII_UDD1_PMV_AGRT_NODES','FII', g_retcode);

1619: IF(g_retcode = '-1') THEN
1620: raise PMVH_lock_err;
1621: END IF;
1622:
1623: FII_UTIL.truncate_table ('FII_UDD1_PMV_AGRT_NODES','FII', g_retcode);
1624: IF(g_retcode = '-1') THEN
1625: raise PMVH_lock_err;
1626: END IF;
1627:

Line 1814: g_phase := 'gather_table_stats for FII_UDD1_PMV_AGRT_NODES';

1810: FND_STATS.gather_table_stats
1811: (ownname => g_schema_name,
1812: tabname => 'FII_CC_PMV_AGRT_NODES');
1813:
1814: g_phase := 'gather_table_stats for FII_UDD1_PMV_AGRT_NODES';
1815:
1816: FND_STATS.gather_table_stats
1817: (ownname => g_schema_name,
1818: tabname => 'FII_UDD1_PMV_AGRT_NODES');

Line 1818: tabname => 'FII_UDD1_PMV_AGRT_NODES');

1814: g_phase := 'gather_table_stats for FII_UDD1_PMV_AGRT_NODES';
1815:
1816: FND_STATS.gather_table_stats
1817: (ownname => g_schema_name,
1818: tabname => 'FII_UDD1_PMV_AGRT_NODES');
1819:
1820: --==============================================================--
1821:
1822: FND_CONCURRENT.Af_Commit;