APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_WT_DIM_TMP

Line 712: DELETE PJI_PMV_WT_DIM_TMP;

708: IF p_PA_DEBUG_MODE = 'Y' THEN
709: Write2FWKLog('Entering Convert_Work_Type...','Convert_Work_Type');
710: END IF;
711:
712: DELETE PJI_PMV_WT_DIM_TMP;
713:
714: IF p_View_BY NOT IN ('WT') AND p_Work_Type_IDS IS NULL THEN
715: l_Parse_Status := 'N';
716: ELSE

Line 722: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

718:
719: IF p_Work_Type_IDS IS NOT NULL THEN
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;

Line 728: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

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)
729: SELECT WT.ID, WT.VALUE
730: FROM PJI_WORK_TYPES_V WT ;
731: END IF;
732:

Line 902: DELETE PJI_PMV_WT_DIM_TMP;

898: IF p_PA_DEBUG_MODE = 'Y' THEN
899: Write2FWKLog('Entering Convert_Util_Category...','Convert_Util_Category');
900: END IF;
901:
902: DELETE PJI_PMV_WT_DIM_TMP;
903: DELETE PJI_PMV_UC_DIM_TMP;
904:
905: IF p_Util_Category_IDS IS NOT NULL THEN
906: l_Util_Dimension_List_Tab:=Decode_IDS(p_Util_Category_IDS);

Line 965: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

961: IF l_UC_Parsed_Flag IS NULL AND p_View_BY = 'WT' THEN
962: IF p_PA_DEBUG_MODE = 'Y' THEN
963: Write2FWKLog('Creating WT rows, View BY WT and UC is not specified.');
964: END IF;
965: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
966: SELECT work_type_id, name
967: FROM pa_work_types_tl
968: WHERE
969: LANGUAGE = USERENV('LANG');

Line 975: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

971: ELSIF l_UC_Parsed_Flag IS NOT NULL THEN
972: IF p_PA_DEBUG_MODE = 'Y' THEN
973: Write2FWKLog('Creating WT rows, UC is specified.');
974: END IF;
975: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
976: SELECT orig.work_type_id, DECODE(p_View_BY,'UC',usrx.name,'WT',orig_tl.name,'-1')
977: FROM pa_work_types_tl orig_tl
978: , pa_work_types_b orig
979: , pji_pmv_uc_dim_tmp usrx

Line 1000: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

996: ** because of a bug in db (2596577).
997: */
998: /*
999: FORALL i IN 1..l_WType_Dimension_List_Tab.Last
1000: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1001: SELECT work_type_id, DECODE(p_View_BY,'WT',name,'-1')
1002: FROM pa_work_types_tl
1003: WHERE
1004: LANGUAGE = USERENV('LANG')

Line 1008: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

1004: LANGUAGE = USERENV('LANG')
1005: AND work_type_id = l_WType_Dimension_List_Tab(i);
1006: */
1007: FOR i IN 1..l_WType_Dimension_List_Tab.Last LOOP
1008: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1009: SELECT work_type_id, DECODE(p_View_BY,'WT',name,'-1')
1010: FROM pa_work_types_tl
1011: WHERE
1012: LANGUAGE = USERENV('LANG')

Line 1026: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

1022: ** because of a bug in db (2596577).
1023: */
1024: /*
1025: FORALL i IN 1..l_WType_Dimension_List_Tab.Last
1026: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1027: SELECT orig.work_type_id, DECODE(p_View_BY,'UC',usrx.name,'WT',orig_tl.name,'-1')
1028: FROM pa_work_types_tl orig_tl
1029: , pa_work_types_b orig
1030: , pji_pmv_uc_dim_tmp usrx

Line 1038: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)

1034: AND orig.work_type_id = orig_tl.work_type_id
1035: AND orig.org_util_category_id = usrx.id;
1036: */
1037: FOR i IN 1..l_WType_Dimension_List_Tab.Last LOOP
1038: INSERT INTO PJI_PMV_WT_DIM_TMP (ID, NAME)
1039: SELECT orig.work_type_id, DECODE(p_View_BY,'UC',usrx.name,'WT',orig_tl.name,'-1')
1040: FROM pa_work_types_tl orig_tl
1041: , pa_work_types_b orig
1042: , pji_pmv_uc_dim_tmp usrx