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_PLAN_MAINT_PVT dependencies on PJI_FM_EXTR_PLNVER3_T

Line 1162: FROM pji_fm_extr_plnver3_t)

1158: SELECT 1
1159: FROM pji_pjp_wbs_header
1160: WHERE (project_id, plan_type_id, plan_version_id) IN
1161: (SELECT DISTINCT project_id, plan_type_id, plan_version_id
1162: FROM pji_fm_extr_plnver3_t)
1163: FOR UPDATE;
1164:
1165: CURSOR c_get_hdrs_lock_map_cur IS
1166: SELECT /*+ index(hd, pji_pjp_wbs_header_n1) */ 1

Line 1207: DELETE FROM pji_fm_extr_plnver3_t;

1203: print_time( ' Invalid p_context, returning: ' || p_context);
1204: RETURN;
1205: END IF;
1206:
1207: DELETE FROM pji_fm_extr_plnver3_t;
1208:
1209: /*
1210: IF (p_context LIKE '%c_incr_act_etc%' AND p_update_mode = 'P') THEN
1211:

Line 1212: INSERT INTO pji_fm_extr_plnver3_t

1208:
1209: /*
1210: IF (p_context LIKE '%c_incr_act_etc%' AND p_update_mode = 'P') THEN
1211:
1212: INSERT INTO pji_fm_extr_plnver3_t
1213: (project_id, plan_version_id, plan_type_id)
1214: SELECT / * + ORDERED * / -- INDEX(HD9, PJI_PJP_WBS_HEADER_N1)
1215: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1216: FROM pji_pjp_proj_batch_map map

Line 1251: INSERT INTO pji_fm_extr_plnver3_t

1247: */
1248:
1249: IF (p_context LIKE '%c_all_cb_co_above%' AND p_update_mode = 'P') THEN
1250:
1251: INSERT INTO pji_fm_extr_plnver3_t
1252: (project_id, plan_version_id, plan_type_id)
1253: SELECT /*+ ORDERED */
1254: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1255: FROM pji_pjp_proj_batch_map map

Line 1278: INSERT INTO pji_fm_extr_plnver3_t

1274: END IF;
1275:
1276: IF (p_context LIKE '%c_all_baselined_fps_generic%' AND p_update_mode = 'P') THEN
1277:
1278: INSERT INTO pji_fm_extr_plnver3_t
1279: (project_id, plan_version_id, plan_type_id)
1280: SELECT
1281: DISTINCT bv.project_id, bv.budget_version_id, bv.fin_plan_type_id
1282: FROM pji_pjp_proj_batch_map map

Line 1297: INSERT INTO pji_fm_extr_plnver3_t

1293:
1294:
1295: IF (p_context LIKE '%c_all_plans_prg_chng%') THEN -- !! ONLY FOR PRG_CHANGE
1296:
1297: INSERT INTO pji_fm_extr_plnver3_t
1298: (project_id, plan_version_id, plan_type_id)
1299: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1300: FROM -- pji_pjp_wbs_header hd2
1301: -- pa_proj_elem_ver_structure hd2

Line 1325: INSERT INTO pji_fm_extr_plnver3_t

1321:
1322:
1323: IF (p_context LIKE '%c_all_cb_co_rbsprg_below%' AND p_update_mode = 'P') THEN
1324:
1325: INSERT INTO pji_fm_extr_plnver3_t
1326: (project_id, plan_version_id, plan_type_id)
1327: SELECT /*+ ordered */
1328: DISTINCT hd2.project_id, hd2.plan_version_id, hd2.plan_type_id
1329: FROM

Line 1358: INSERT INTO pji_fm_extr_plnver3_t

1354:
1355:
1356: IF (p_context LIKE '%c_all_baselined_fps_rbsassoc%' AND p_update_mode = 'P') THEN
1357:
1358: INSERT INTO pji_fm_extr_plnver3_t
1359: (project_id, plan_version_id, plan_type_id)
1360: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1361: FROM pji_pjp_proj_batch_map map
1362: , pji_pa_proj_events_log ev

Line 1386: INSERT INTO pji_fm_extr_plnver3_t

1382:
1383:
1384: IF (p_context LIKE '%c_all_cb_co_rbsassoc_above_cur%' AND p_update_mode = 'P') THEN
1385:
1386: INSERT INTO pji_fm_extr_plnver3_t
1387: (project_id, plan_version_id, plan_type_id)
1388: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1389: FROM pji_xbs_denorm den
1390: , pji_pjp_wbs_header hd1 -- SUB

Line 1424: INSERT INTO pji_fm_extr_plnver3_t

1420:
1421:
1422: IF (p_context LIKE '%c_all_bslnd_fps_rbsprg_below%' AND p_update_mode = 'P') THEN
1423:
1424: INSERT INTO pji_fm_extr_plnver3_t
1425: (project_id, plan_version_id, plan_type_id)
1426: SELECT /*+ ordered */
1427: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1428: FROM pji_pjp_proj_batch_map map

Line 1460: INSERT INTO pji_fm_extr_plnver3_t

1456:
1457:
1458: IF (p_context LIKE '%c_all_cb_co_rbsprg_above%' AND p_update_mode = 'P') THEN
1459:
1460: INSERT INTO pji_fm_extr_plnver3_t
1461: (project_id, plan_version_id, plan_type_id)
1462: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1463: FROM pji_xbs_denorm den
1464: , pji_pjp_wbs_header hd2 -- SUB

Line 1491: INSERT INTO pji_fm_extr_plnver3_t

1487:
1488:
1489: IF (p_context LIKE '%c_dangl_fps_self%' AND p_update_mode = 'P') THEN
1490:
1491: INSERT INTO pji_fm_extr_plnver3_t
1492: (project_id, plan_version_id, plan_type_id)
1493: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1494: FROM pji_pjp_proj_batch_map map
1495: , PA_BUDGET_VERSIONS bv

Line 1514: INSERT INTO pji_fm_extr_plnver3_t

1510:
1511:
1512: IF (p_context LIKE '%c_dangl_cb_co_above%' AND p_update_mode = 'P') THEN
1513:
1514: INSERT INTO pji_fm_extr_plnver3_t
1515: (project_id, plan_version_id, plan_type_id)
1516: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1517: FROM pji_xbs_denorm den
1518: , pji_pjp_wbs_header hd1 -- SUB

Line 1559: FROM pji_fm_extr_plnver3_t);

1555: , LAST_UPDATED_BY = l_last_updated_by
1556: , LAST_UPDATE_LOGIN = l_last_update_login
1557: WHERE (project_id, plan_type_id, plan_version_id) IN
1558: (SELECT DISTINCT project_id, plan_type_id, plan_version_id
1559: FROM pji_fm_extr_plnver3_t);
1560:
1561: print_time ( ' UPDATE_LOCKS # updated hdrs = ' || SQL%ROWCOUNT );
1562:
1563: DELETE FROM pji_fm_extr_plnver3_t;

Line 1563: DELETE FROM pji_fm_extr_plnver3_t;

1559: FROM pji_fm_extr_plnver3_t);
1560:
1561: print_time ( ' UPDATE_LOCKS # updated hdrs = ' || SQL%ROWCOUNT );
1562:
1563: DELETE FROM pji_fm_extr_plnver3_t;
1564: print_time ( ' # of records deleted in plnver3 = ' || SQL%ROWCOUNT );
1565:
1566:
1567: IF (p_update_mode IS NULL) THEN