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.PJI_PMV_ENGINE dependencies on PJI_PMV_JL_DIM_TMP

Line 1089: DELETE PJI_PMV_JL_DIM_TMP;

1085: Write2FWKLog('Entering Convert_Job_Level...','Convert_Job_Level');
1086: END IF;
1087:
1088: DELETE PJI_PMV_JB_DIM_TMP;
1089: DELETE PJI_PMV_JL_DIM_TMP;
1090:
1091: IF p_Job_Level_IDS IS NOT NULL THEN
1092: l_JLevel_Dimension_List_Tab:=Decode_IDS(p_Job_Level_IDS);
1093: ELSE

Line 1107: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

1103: IF l_JLevel_Dimension_List_Tab IS NULL AND p_View_BY = 'JL' THEN
1104: IF p_PA_DEBUG_MODE = 'Y' THEN
1105: Write2FWKLog('View BY JL and JL is not specified.');
1106: END IF;
1107: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1108: SELECT ID, VALUE
1109: FROM PJI_JOB_LEVELS_V;
1110: l_JL_Parsed_Flag:='Y';
1111: ELSIF l_JLevel_Dimension_List_Tab IS NOT NULL THEN

Line 1121: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

1117: ** because of a bug in db (2596577).
1118: */
1119: /*
1120: FORALL i IN 1..l_JLevel_Dimension_List_Tab.Last
1121: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1122: SELECT ID,DECODE(p_View_By, 'JL', VALUE , '-1')
1123: FROM PJI_JOB_LEVELS_V
1124: WHERE ID = l_JLevel_Dimension_List_Tab(i);
1125: */

Line 1127: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

1123: FROM PJI_JOB_LEVELS_V
1124: WHERE ID = l_JLevel_Dimension_List_Tab(i);
1125: */
1126: FOR i IN 1..l_JLevel_Dimension_List_Tab.Last LOOP
1127: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1128: SELECT ID,DECODE(p_View_By, 'JL', VALUE , '-1')
1129: FROM PJI_JOB_LEVELS_V
1130: WHERE ID = l_JLevel_Dimension_List_Tab(i);
1131: END LOOP;

Line 1155: , PJI_PMV_JL_DIM_TMP USRX

1151: END IF;
1152: INSERT INTO PJI_PMV_JB_DIM_TMP (ID, NAME)
1153: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1154: FROM PJI_JOBS_V ORIG
1155: , PJI_PMV_JL_DIM_TMP USRX
1156: WHERE ORIG.JOB_LEVEL=USRX.ID;
1157: l_JB_Parsed_Flag:='Y';
1158: END IF;
1159: ELSIF l_Job_Dimension_List_Tab IS NOT NULL THEN

Line 1171: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

1167: ** because of a bug in db (2596577).
1168: */
1169: /*
1170: FORALL i IN 1..l_Job_Dimension_List_Tab.Last
1171: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1172: SELECT ID, DECODE(p_View_BY,'JL',VALUE,'-1')
1173: FROM PJI_JOBS_V
1174: WHERE ID = l_Job_Dimension_List_Tab(i);
1175: */

Line 1177: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

1173: FROM PJI_JOBS_V
1174: WHERE ID = l_Job_Dimension_List_Tab(i);
1175: */
1176: FOR i IN 1..l_Job_Dimension_List_Tab.Last LOOP
1177: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1178: SELECT ID, DECODE(p_View_BY,'JL',VALUE,'-1')
1179: FROM PJI_JOBS_V
1180: WHERE ID = l_Job_Dimension_List_Tab(i);
1181: END LOOP;

Line 1193: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

1189: ** because of a bug in db (2596577).
1190: */
1191: /*
1192: FORALL i IN 1..l_Job_Dimension_List_Tab.Last
1193: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1194: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1195: FROM PJI_JOBS_V ORIG
1196: , PJI_PMV_JL_DIM_TMP USRX
1197: WHERE ORIG.ID=l_Job_Dimension_List_Tab(i)

Line 1196: , PJI_PMV_JL_DIM_TMP USRX

1192: FORALL i IN 1..l_Job_Dimension_List_Tab.Last
1193: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1194: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1195: FROM PJI_JOBS_V ORIG
1196: , PJI_PMV_JL_DIM_TMP USRX
1197: WHERE ORIG.ID=l_Job_Dimension_List_Tab(i)
1198: AND ORIG.JOB_LEVEL=USRX.ID;
1199: */
1200: FOR i IN 1..l_Job_Dimension_List_Tab.Last LOOP

Line 1201: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)

1197: WHERE ORIG.ID=l_Job_Dimension_List_Tab(i)
1198: AND ORIG.JOB_LEVEL=USRX.ID;
1199: */
1200: FOR i IN 1..l_Job_Dimension_List_Tab.Last LOOP
1201: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1202: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1203: FROM PJI_JOBS_V ORIG
1204: , PJI_PMV_JL_DIM_TMP USRX
1205: WHERE ORIG.ID=l_Job_Dimension_List_Tab(i)

Line 1204: , PJI_PMV_JL_DIM_TMP USRX

1200: FOR i IN 1..l_Job_Dimension_List_Tab.Last LOOP
1201: INSERT INTO PJI_PMV_JL_DIM_TMP (ID, NAME)
1202: SELECT ORIG.ID, DECODE(p_View_BY,'JL',USRX.NAME,'JB',ORIG.VALUE,'-1')
1203: FROM PJI_JOBS_V ORIG
1204: , PJI_PMV_JL_DIM_TMP USRX
1205: WHERE ORIG.ID=l_Job_Dimension_List_Tab(i)
1206: AND ORIG.JOB_LEVEL=USRX.ID;
1207: END LOOP;
1208: l_JB_Parsed_Flag:='Y';