720: l_Dimension_List_Tab:=Decode_IDS(p_Work_Type_IDS);
721: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
722: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
723: SELECT WT.ID, DECODE(p_View_BY,'WT',WT.VALUE,'-1')
724: FROM PJI_WORK_TYPES_V WT
725: WHERE WT.ID = l_Dimension_List_Tab(i);
726: END LOOP;
727: ELSE
728: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
726: END LOOP;
727: ELSE
728: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
729: SELECT WT.ID, WT.VALUE
730: FROM PJI_WORK_TYPES_V WT ;
731: END IF;
732:
733: END IF;
734: RETURN l_Parse_Status;
5050: G_ViewBY_Column_Name := 'UTIL_CATEGORY_ID';
5051: G_ViewBY_Table_Name := 'PJI_UTIL_CATEGORIES_V';
5052: WHEN 'PROJECT WORK TYPE+PJI_WORK_TYPES' THEN
5053: G_ViewBY_Column_Name := 'WORK_TYPE_ID';
5054: G_ViewBY_Table_Name := 'PJI_WORK_TYPES_V';
5055: WHEN 'PROJECT+PJI_PROJECTS' THEN
5056: G_ViewBY_Column_Name := 'PROJECT_NAME';
5057: G_ViewBY_Table_Name := 'PJI_PROJECTS_V';
5058: WHEN 'TIME+FII_TIME_CAL_PERIOD' THEN