APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_UC_DIM_TMP

Line 903: DELETE PJI_PMV_UC_DIM_TMP;

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);
907: ELSE

Line 922: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)

918: IF l_Util_Dimension_List_Tab IS NULL AND p_View_BY = 'UC' THEN
919: IF p_PA_DEBUG_MODE = 'Y' THEN
920: Write2FWKLog('View BY UC and UC is not specified.');
921: END IF;
922: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)
923: SELECT util_category_id, name
924: FROM pa_util_categories_tl
925: WHERE
926: LANGUAGE = USERENV('LANG');

Line 938: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)

934: ** because of a bug in db (2596577).
935: */
936: /*
937: FORALL i IN 1..l_Util_Dimension_List_Tab.Last
938: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)
939: SELECT util_category_id, DECODE(p_View_By, 'UC', name , '-1')
940: FROM pa_util_categories_tl
941: WHERE
942: LANGUAGE = USERENV('LANG')

Line 946: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)

942: LANGUAGE = USERENV('LANG')
943: AND util_category_id = l_Util_Dimension_List_Tab(i);
944: */
945: FOR i IN 1..l_Util_Dimension_List_Tab.Last LOOP
946: INSERT INTO PJI_PMV_UC_DIM_TMP (ID, NAME)
947: SELECT util_category_id, DECODE(p_View_By, 'UC', name , '-1')
948: FROM pa_util_categories_tl
949: WHERE
950: LANGUAGE = USERENV('LANG')

Line 979: , pji_pmv_uc_dim_tmp usrx

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
980: WHERE
981: LANGUAGE = USERENV('LANG')
982: AND orig.work_type_id = orig_tl.work_type_id
983: AND orig.org_util_category_id = usrx.id;

Line 1030: , pji_pmv_uc_dim_tmp usrx

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
1031: WHERE
1032: LANGUAGE = USERENV('LANG')
1033: AND orig.work_type_id = l_WType_Dimension_List_Tab(i)
1034: AND orig.work_type_id = orig_tl.work_type_id

Line 1042: , pji_pmv_uc_dim_tmp usrx

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
1043: WHERE
1044: LANGUAGE = USERENV('LANG')
1045: AND orig.work_type_id = l_WType_Dimension_List_Tab(i)
1046: AND orig.work_type_id = orig_tl.work_type_id