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_CC_PMV_AGRT_NODES

Line 741: update fii_cc_pmv_agrt_nodes f

737: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
738: END IF;
739:
740: g_phase := 'Updating the Cost Center pmv helper table for the newly aggregated nodes';
741: update fii_cc_pmv_agrt_nodes f
742: set aggregated_flag = (select aggregate_next_level_flag
743: from fii_cost_ctr_hierarchies
744: where next_level_cc_id = f.cost_center_id
745: and parent_level = next_level)

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

748: where next_level_cc_id = f.cost_center_id
749: and parent_level = next_level);
750:
751: IF (FIIDIM_Debug) THEN
752: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
753: END IF;
754:
755: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';
756: FND_STATS.gather_table_stats

Line 944: from fii_cc_pmv_agrt_nodes

940: IF (G_PROGRAM_MODE = 'INCRE') THEN
941: g_phase := 'In IF Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';
942: update fii_cost_ctr_hierarchies f
943: set aggregate_next_level_flag = (select aggregated_flag
944: from fii_cc_pmv_agrt_nodes
945: where cost_center_id = f.next_level_cc_id)
946: where aggregate_next_level_flag <> (select aggregated_flag
947: from fii_cc_pmv_agrt_nodes
948: where cost_center_id = f.next_level_cc_id);

Line 947: from fii_cc_pmv_agrt_nodes

943: set aggregate_next_level_flag = (select aggregated_flag
944: from fii_cc_pmv_agrt_nodes
945: where cost_center_id = f.next_level_cc_id)
946: where aggregate_next_level_flag <> (select aggregated_flag
947: from fii_cc_pmv_agrt_nodes
948: where cost_center_id = f.next_level_cc_id);
949:
950: IF (FIIDIM_Debug) THEN
951: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');

Line 958: from fii_cc_pmv_agrt_nodes

954: ELSE
955: g_phase := 'In ELSE Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';
956: update fii_cost_ctr_hierarchies f
957: set aggregate_next_level_flag = (select aggregated_flag
958: from fii_cc_pmv_agrt_nodes
959: where cost_center_id = f.next_level_cc_id);
960:
961: IF (FIIDIM_Debug) THEN
962: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');

Line 1087: g_phase := 'Update FII_CC_PMV_AGRT_NODES for Cost Center';

1083: END IF;
1084:
1085:
1086: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1087: g_phase := 'Update FII_CC_PMV_AGRT_NODES for Cost Center';
1088:
1089: UPDATE FII_CC_PMV_AGRT_NODES
1090: set for_viewby_flag = 'Y'
1091: WHERE cost_center_id in ( select next_level_cc_id

Line 1089: UPDATE FII_CC_PMV_AGRT_NODES

1085:
1086: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1087: g_phase := 'Update FII_CC_PMV_AGRT_NODES for Cost Center';
1088:
1089: UPDATE FII_CC_PMV_AGRT_NODES
1090: set for_viewby_flag = 'Y'
1091: WHERE cost_center_id in ( select next_level_cc_id
1092: from FII_COST_CTR_HIERARCHIES f1
1093: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')

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

1097: and f2.aggregate_next_level_flag = 'Y'
1098: and f2.parent_cc_id <> f2.next_level_cc_id));
1099:
1100: IF (FIIDIM_Debug) THEN
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';

Line 1211: g_phase := 'Inserting into fii_cc_pmv_agrt_nodes for CC';

1207: END IF;
1208:
1209: --For CC Dimension
1210: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1211: g_phase := 'Inserting into fii_cc_pmv_agrt_nodes for CC';
1212: Insert into fii_cc_pmv_agrt_nodes(COST_CENTER_ID,
1213: for_viewby_flag,
1214: aggregated_flag,
1215: LAST_UPDATE_DATE ,

Line 1212: Insert into fii_cc_pmv_agrt_nodes(COST_CENTER_ID,

1208:
1209: --For CC Dimension
1210: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1211: g_phase := 'Inserting into fii_cc_pmv_agrt_nodes for CC';
1212: Insert into fii_cc_pmv_agrt_nodes(COST_CENTER_ID,
1213: for_viewby_flag,
1214: aggregated_flag,
1215: LAST_UPDATE_DATE ,
1216: LAST_UPDATED_BY,

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

1227: where parent_level= next_level
1228: ) ;
1229:
1230: IF (FIIDIM_Debug) THEN
1231: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
1232: END IF;
1233:
1234: --For UDD1
1235: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') 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 1347: Insert into FII_CC_PMV_AGRT_NODES(COST_CENTER_ID,

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

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

1363: where dim_short_name = p_dim_short_name
1364: AND no_of_children >= l_subtree_freq;
1365:
1366: IF (FIIDIM_Debug) THEN
1367: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
1368: END IF;
1369:
1370: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
1371:

Line 1465: g_phase := 'Inserting records which will not be aggregated into fii_cc_pmv_agrt_nodes_gt for Cost Center';

1461:
1462: --For CC Dimension
1463: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1464:
1465: g_phase := 'Inserting records which will not be aggregated into fii_cc_pmv_agrt_nodes_gt for Cost Center';
1466: Insert into fii_cc_pmv_agrt_nodes(cost_center_id, for_viewby_flag,
1467: aggregated_flag,
1468: LAST_UPDATE_DATE ,
1469: LAST_UPDATED_BY,

Line 1466: Insert into fii_cc_pmv_agrt_nodes(cost_center_id, for_viewby_flag,

1462: --For CC Dimension
1463: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
1464:
1465: g_phase := 'Inserting records which will not be aggregated into fii_cc_pmv_agrt_nodes_gt for Cost Center';
1466: Insert into fii_cc_pmv_agrt_nodes(cost_center_id, for_viewby_flag,
1467: aggregated_flag,
1468: LAST_UPDATE_DATE ,
1469: LAST_UPDATED_BY,
1470: CREATION_DATE,

Line 1488: from fii_cc_pmv_agrt_nodes) ;

1484: FII_USER_ID,
1485: SYSDATE,
1486: FII_USER_ID,
1487: FII_LOGIN_ID
1488: from fii_cc_pmv_agrt_nodes) ;
1489:
1490: IF (FIIDIM_Debug) THEN
1491: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
1492: END IF;

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

1487: FII_LOGIN_ID
1488: from fii_cc_pmv_agrt_nodes) ;
1489:
1490: IF (FIIDIM_Debug) THEN
1491: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
1492: END IF;
1493:
1494: --For UDD1
1495: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN

Line 1554: FROM FII_CC_PMV_AGRT_NODES

1550: FROM FII_COM_PMV_AGRT_NODES
1551: WHERE aggregated_flag = 'Y';
1552: ELSIF(p_dim_short_name = 'HRI_CL_ORGCC') THEN
1553: SELECT count(*) into l_nodes_aggregated
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

Line 1618: FII_UTIL.truncate_table ('FII_CC_PMV_AGRT_NODES', 'FII', g_retcode);

1614: IF(g_retcode = '-1') THEN
1615: raise PMVH_lock_err;
1616: END IF;
1617:
1618: FII_UTIL.truncate_table ('FII_CC_PMV_AGRT_NODES', 'FII', g_retcode);
1619: IF(g_retcode = '-1') THEN
1620: raise PMVH_lock_err;
1621: END IF;
1622:

Line 1808: g_phase := 'gather_table_stats for FII_CC_PMV_AGRT_NODES';

1804: FND_STATS.gather_table_stats
1805: (ownname => g_schema_name,
1806: tabname => 'FII_COM_PMV_AGRT_NODES');
1807:
1808: g_phase := 'gather_table_stats for FII_CC_PMV_AGRT_NODES';
1809:
1810: FND_STATS.gather_table_stats
1811: (ownname => g_schema_name,
1812: tabname => 'FII_CC_PMV_AGRT_NODES');

Line 1812: tabname => 'FII_CC_PMV_AGRT_NODES');

1808: g_phase := 'gather_table_stats for FII_CC_PMV_AGRT_NODES';
1809:
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