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_FM_SUM_BKLG dependencies on PJI_PJI_PROJ_BATCH_MAP

Line 46: from pji_pji_proj_batch_map map

42: , to_date(min(fin9.TIME_ID), 'J')
43: -- , to_date(min(fin9.RECVR_GL_TIME_ID),'J')
44: -- , to_date(min(fin9.RECVR_PA_TIME_ID),'J')
45: , sum(abs(fin9.POU_REVENUE))
46: from pji_pji_proj_batch_map map
47: , PJI_FM_AGGR_FIN9 fin9
48: where 1 = 1
49: and map.worker_id = p_worker_id
50: and fin9.project_id = map.project_id

Line 86: -- Update the table pji_pji_proj_batch_map with the

82:
83: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
84: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
85:
86: -- Update the table pji_pji_proj_batch_map with the
87: -- minimum activity dates for each project in the current batch
88: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
89: pji_pji_proj_batch_map map
90: SET ( map.ACTIVITY_MIN_GL_DATE

Line 88: UPDATE /+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) /

84: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
85:
86: -- Update the table pji_pji_proj_batch_map with the
87: -- minimum activity dates for each project in the current batch
88: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
89: pji_pji_proj_batch_map map
90: SET ( map.ACTIVITY_MIN_GL_DATE
91: , map.ACTIVITY_MIN_PA_DATE) =
92: (select scope.ACTIVITY_MIN_GL_DATE

Line 89: pji_pji_proj_batch_map map

85:
86: -- Update the table pji_pji_proj_batch_map with the
87: -- minimum activity dates for each project in the current batch
88: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
89: pji_pji_proj_batch_map map
90: SET ( map.ACTIVITY_MIN_GL_DATE
91: , map.ACTIVITY_MIN_PA_DATE) =
92: (select scope.ACTIVITY_MIN_GL_DATE
93: , scope.ACTIVITY_MIN_PA_DATE

Line 153: , pji_pji_proj_batch_map map

149: , to_date(min(act5.TIME_ID), 'J')
150: -- , to_date(min(LEAST(act5.GL_TIME_ID,act5.PA_TIME_ID)),'J')
151: , sum(abs(act5.POU_FUNDING))
152: from PJI_FM_AGGR_ACT5 act5
153: , pji_pji_proj_batch_map map
154: where 1 = 1
155: and act5.worker_id = p_worker_id
156: and act5.project_id = map.project_id
157: and map.worker_id = p_worker_id

Line 189: -- Update the table pji_pji_proj_batch_map with the

185:
186: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
187: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
188:
189: -- Update the table pji_pji_proj_batch_map with the
190: -- minimum funding dates for each project in the current batch
191: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
192: pji_pji_proj_batch_map map
193: SET ( map.FUNDING_MIN_DATE ) =

Line 191: UPDATE /+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) /

187: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
188:
189: -- Update the table pji_pji_proj_batch_map with the
190: -- minimum funding dates for each project in the current batch
191: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
192: pji_pji_proj_batch_map map
193: SET ( map.FUNDING_MIN_DATE ) =
194: (select scope.FUNDING_MIN_DATE
195: from PJI_FM_RMAP_ACT scope

Line 192: pji_pji_proj_batch_map map

188:
189: -- Update the table pji_pji_proj_batch_map with the
190: -- minimum funding dates for each project in the current batch
191: UPDATE /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
192: pji_pji_proj_batch_map map
193: SET ( map.FUNDING_MIN_DATE ) =
194: (select scope.FUNDING_MIN_DATE
195: from PJI_FM_RMAP_ACT scope
196: where scope.worker_id = p_worker_id

Line 240: UPDATE PJI_PJI_PROJ_BATCH_MAP upd

236:
237: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
238: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
239:
240: UPDATE PJI_PJI_PROJ_BATCH_MAP upd
241: set upd.BACKLOG_EXTRACTION_STATUS=null
242: where upd.project_id in
243: (
244: select /*+ ORDERED

Line 250: PJI_PJI_PROJ_BATCH_MAP map

246: */
247: distinct
248: map.project_id project_id
249: From
250: PJI_PJI_PROJ_BATCH_MAP map
251: , PJI_FM_AGGR_ACT3 act3
252: Where 1=1
253: and map.worker_id = p_worker_id
254: and map.project_id = act3.project_id

Line 1225: from pji_pji_proj_batch_map

1221: from PJI_FM_AGGR_ACT3
1222: where worker_id = 1
1223: and project_id in
1224: (select project_id
1225: from pji_pji_proj_batch_map
1226: where worker_id = 1
1227: and BACKLOG_EXTRACTION_STATUS = 'P'
1228: and PARALLEL_BACKLOG_WORKER_ID = p_worker_id
1229: )

Line 1232: Update pji_pji_proj_batch_map

1228: and PARALLEL_BACKLOG_WORKER_ID = p_worker_id
1229: )
1230: ;
1231:
1232: Update pji_pji_proj_batch_map
1233: Set BACKLOG_EXTRACTION_STATUS = null
1234: , PARALLEL_BACKLOG_WORKER_ID = null
1235: Where WORKER_ID = 1
1236: And PARALLEL_BACKLOG_WORKER_ID = p_worker_id

Line 1265: Update pji_pji_proj_batch_map

1261: END IF;
1262:
1263: l_try_upd_again := 'N';
1264:
1265: Update pji_pji_proj_batch_map
1266: Set BACKLOG_EXTRACTION_STATUS='P'
1267: , PARALLEL_BACKLOG_WORKER_ID = p_worker_id
1268: Where WORKER_ID = 1
1269: And BACKLOG_EXTRACTION_STATUS is null

Line 1273: from pji_pji_proj_batch_map

1269: And BACKLOG_EXTRACTION_STATUS is null
1270: And rownum = 1
1271: And not exists
1272: ( select 1
1273: from pji_pji_proj_batch_map
1274: where worker_id = 1
1275: and parallel_backlog_worker_id = p_worker_id
1276: and backlog_extraction_status = 'P'
1277: )

Line 1298: from pji_pji_proj_batch_map

1294: ELSE -- either there are no more records to be processed
1295: -- or there has been data contention
1296: select count(*)
1297: into l_count_for_upd
1298: from pji_pji_proj_batch_map
1299: where WORKER_ID = p_worker_id
1300: and BACKLOG_EXTRACTION_STATUS is null
1301: and ( ACTIVITY_MIN_GL_DATE is not null
1302: or ACTIVITY_MIN_PA_DATE is not null

Line 1324: From pji_pji_proj_batch_map

1320: ELSE -- go ahead with the processing for the record updated
1321:
1322: Select project_id
1323: Into l_curr_project_id
1324: From pji_pji_proj_batch_map
1325: Where BACKLOG_EXTRACTION_STATUS='P'
1326: And PARALLEL_BACKLOG_WORKER_ID = p_worker_id
1327: ;
1328:

Line 1367: FROM pji_pji_proj_batch_map map

1363: , l_project_organization_id
1364: , l_calendar_id
1365: , l_gl_calendar_id
1366: , l_pa_calendar_id
1367: FROM pji_pji_proj_batch_map map
1368: , PJI_ORG_EXTR_INFO org_info
1369: WHERE map.WORKER_ID = 1
1370: AND map.PROJECT_ORG_ID = org_info.org_id
1371: AND map.project_id = l_curr_project_id

Line 1410: Update pji_pji_proj_batch_map

1406: end loop; -- WHILE l_dual < 3
1407:
1408: l_prev_project := l_curr_project_id;
1409:
1410: Update pji_pji_proj_batch_map
1411: Set BACKLOG_EXTRACTION_STATUS='X'
1412: Where project_id = l_curr_project_id
1413: ;
1414:

Line 1427: from pji_pji_proj_batch_map

1423:
1424:
1425: select count(*)
1426: into l_count_for_upd
1427: from pji_pji_proj_batch_map
1428: where WORKER_ID = p_worker_id
1429: and NVL(BACKLOG_EXTRACTION_STATUS,'P') = 'P'
1430: ;
1431: