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_PJP_WBS_HEADER

Line 695: pji_pjp_wbs_header head,

691: FROM
692: pji_pjp_proj_batch_map map,
693: PA_PROJECTS_ALL ppa,
694: PA_BUDGET_VERSIONS pbv,
695: pji_pjp_wbs_header head,
696: PA_PROJ_ELEM_VER_STRUCTURE ppevs,
697: PA_PROJ_FP_OPTIONS fpo
698: WHERE
699: -- map.PROJECT_ACTIVE_FLAG = 'Y' AND

Line 807: , pji_pjp_wbs_header whd

803: , 'Y' lp_flag
804: FROM
805: pji_pjp_proj_batch_map map
806: , PA_PROJECTS_ALL ppa
807: , pji_pjp_wbs_header whd
808: , pji_pjp_rbs_header rhd
809: WHERE 1=1
810: AND ppa.project_id = map.project_id
811: -- AND map.PROJECT_ACTIVE_FLAG = 'Y'

Line 843: , pji_pjp_wbs_header whd

839: , 'Y' lp_flag
840: FROM
841: pji_pjp_proj_batch_map map
842: , PA_PROJECTS_ALL ppa
843: , pji_pjp_wbs_header whd
844: , pji_pjp_rbs_header rhd
845: WHERE 1=1
846: AND ppa.project_id = map.project_id
847: -- AND map.PROJECT_ACTIVE_FLAG = 'Y'

Line 1159: FROM pji_pjp_wbs_header

1155: PRAGMA EXCEPTION_INIT(excp_resource_busy, -54);
1156:
1157: CURSOR c_get_hdrs_lock_ver3_t_cur IS
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;

Line 1166: SELECT /+ index(hd, pji_pjp_wbs_header_n1) / 1

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
1167: FROM pji_pjp_wbs_header hd
1168: WHERE (project_id, plan_version_id, plan_type_id) IN
1169: ( SELECT hd1.project_id, plan_version_id, plan_type_id
1170: FROM pji_pjp_wbs_header hd1

Line 1167: FROM pji_pjp_wbs_header hd

1163: FOR UPDATE;
1164:
1165: CURSOR c_get_hdrs_lock_map_cur IS
1166: SELECT /*+ index(hd, pji_pjp_wbs_header_n1) */ 1
1167: FROM pji_pjp_wbs_header hd
1168: WHERE (project_id, plan_version_id, plan_type_id) IN
1169: ( SELECT hd1.project_id, plan_version_id, plan_type_id
1170: FROM pji_pjp_wbs_header hd1
1171: , pji_pjp_proj_batch_map map

Line 1170: FROM pji_pjp_wbs_header hd1

1166: SELECT /*+ index(hd, pji_pjp_wbs_header_n1) */ 1
1167: FROM pji_pjp_wbs_header hd
1168: WHERE (project_id, plan_version_id, plan_type_id) IN
1169: ( SELECT hd1.project_id, plan_version_id, plan_type_id
1170: FROM pji_pjp_wbs_header hd1
1171: , pji_pjp_proj_batch_map map
1172: WHERE hd1.project_id = map.project_id
1173: AND map.worker_id = g_worker_id
1174: AND (hd1.plan_version_id > 0 OR hd1.plan_version_id IN (-3, -4))

Line 1214: SELECT / * + ORDERED * / -- INDEX(HD9, PJI_PJP_WBS_HEADER_N1)

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
1217: , pji_fm_extr_plan_lines epl
1218: , pji_pjp_wbs_header hd2 -- SUB

Line 1218: , pji_pjp_wbs_header hd2 -- SUB

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
1217: , pji_fm_extr_plan_lines epl
1218: , pji_pjp_wbs_header hd2 -- SUB
1219: , pji_xbs_denorm den
1220: , pji_pjp_wbs_header hd9 -- SUP
1221: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
1222: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2

Line 1220: , pji_pjp_wbs_header hd9 -- SUP

1216: FROM pji_pjp_proj_batch_map map
1217: , pji_fm_extr_plan_lines epl
1218: , pji_pjp_wbs_header hd2 -- SUB
1219: , pji_xbs_denorm den
1220: , pji_pjp_wbs_header hd9 -- SUP
1221: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
1222: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
1223: WHERE
1224: den.struct_version_id IS NULL

Line 1256: , pji_pjp_wbs_header hd1 -- SUB

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
1256: , pji_pjp_wbs_header hd1 -- SUB
1257: , pji_xbs_denorm den
1258: , pji_pjp_wbs_header hd9 -- SUP
1259: WHERE
1260: den.struct_version_id IS NULL

Line 1258: , pji_pjp_wbs_header hd9 -- SUP

1254: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1255: FROM pji_pjp_proj_batch_map map
1256: , pji_pjp_wbs_header hd1 -- SUB
1257: , pji_xbs_denorm den
1258: , pji_pjp_wbs_header hd9 -- SUP
1259: WHERE
1260: den.struct_version_id IS NULL
1261: AND hd1.wbs_version_id = den.sub_id -- struct_version_id
1262: AND hd9.wbs_version_id = den.sup_id

Line 1300: FROM -- pji_pjp_wbs_header hd2

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
1302: pji_pa_proj_events_log ev
1303: , Pa_XBS_DENORM den
1304: , pji_pjp_wbs_header hd9 -- SUP

Line 1304: , pji_pjp_wbs_header hd9 -- SUP

1300: FROM -- pji_pjp_wbs_header hd2
1301: -- pa_proj_elem_ver_structure hd2
1302: pji_pa_proj_events_log ev
1303: , Pa_XBS_DENORM den
1304: , pji_pjp_wbs_header hd9 -- SUP
1305: WHERE
1306: den.struct_version_id IS NULL
1307: AND hd9.wbs_version_id = den.sup_id -- struct_version_id
1308: -- AND hd2.element_version_id = den.sub_id

Line 1332: , pji_pjp_wbs_header hd9 -- SUP

1328: DISTINCT hd2.project_id, hd2.plan_version_id, hd2.plan_type_id
1329: FROM
1330: pji_pjp_proj_batch_map map
1331: , pji_pa_proj_events_log ev
1332: , pji_pjp_wbs_header hd9 -- SUP
1333: , pji_xbs_denorm den
1334: , pji_pjp_wbs_header hd2 -- SUB
1335: WHERE
1336: den.struct_version_id IS NULL

Line 1334: , pji_pjp_wbs_header hd2 -- SUB

1330: pji_pjp_proj_batch_map map
1331: , pji_pa_proj_events_log ev
1332: , pji_pjp_wbs_header hd9 -- SUP
1333: , pji_xbs_denorm den
1334: , pji_pjp_wbs_header hd2 -- SUB
1335: WHERE
1336: den.struct_version_id IS NULL
1337: AND hd9.wbs_version_id = den.sub_id -- struct_version_id
1338: AND hd2.wbs_version_id = den.sup_id

Line 1363: , pji_pjp_wbs_header hd9 -- SUP

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
1363: , pji_pjp_wbs_header hd9 -- SUP
1364: WHERE
1365: map.worker_id = g_worker_id
1366: AND ev.worker_id = g_worker_id
1367: AND ev.event_type = 'RBS_ASSOC'

Line 1390: , pji_pjp_wbs_header hd1 -- SUB

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
1391: , pji_pjp_proj_batch_map map
1392: , pji_pa_proj_events_log ev
1393: , pji_pjp_wbs_header hd9 -- SUP
1394: WHERE

Line 1393: , pji_pjp_wbs_header hd9 -- SUP

1389: FROM pji_xbs_denorm den
1390: , pji_pjp_wbs_header hd1 -- SUB
1391: , pji_pjp_proj_batch_map map
1392: , pji_pa_proj_events_log ev
1393: , pji_pjp_wbs_header hd9 -- SUP
1394: WHERE
1395: den.struct_version_id IS NULL
1396: AND hd1.wbs_version_id = den.sub_id -- struct_version_id
1397: AND hd9.wbs_version_id = den.sup_id

Line 1432: , pji_pjp_wbs_header wh1 -- sup

1428: FROM pji_pjp_proj_batch_map map
1429: , pji_pa_proj_events_log ev
1430: -- , PA_BUDGET_VERSIONS bv
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header wh1 -- sup
1433: , pji_pjp_wbs_header hd9 -- SUb!!
1434: WHERE
1435: den.struct_version_id IS NULL
1436: AND hd9.wbs_version_id = den.sub_id -- struct_version_id

Line 1433: , pji_pjp_wbs_header hd9 -- SUb!!

1429: , pji_pa_proj_events_log ev
1430: -- , PA_BUDGET_VERSIONS bv
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header wh1 -- sup
1433: , pji_pjp_wbs_header hd9 -- SUb!!
1434: WHERE
1435: den.struct_version_id IS NULL
1436: AND hd9.wbs_version_id = den.sub_id -- struct_version_id
1437: AND wh1.wbs_version_id = den.sup_id

Line 1464: , pji_pjp_wbs_header hd2 -- SUB

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
1465: , pji_pjp_proj_batch_map map
1466: , pji_pa_proj_events_log ev
1467: , pji_pjp_wbs_header hd9 -- SUP
1468: WHERE

Line 1467: , pji_pjp_wbs_header hd9 -- SUP

1463: FROM pji_xbs_denorm den
1464: , pji_pjp_wbs_header hd2 -- SUB
1465: , pji_pjp_proj_batch_map map
1466: , pji_pa_proj_events_log ev
1467: , pji_pjp_wbs_header hd9 -- SUP
1468: WHERE
1469: den.struct_version_id IS NULL
1470: AND hd9.wbs_version_id = den.sup_id -- struct_version_id
1471: AND hd2.wbs_version_id = den.sub_id

Line 1496: , pji_pjp_wbs_header hd9 -- SUP

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
1496: , pji_pjp_wbs_header hd9 -- SUP
1497: WHERE
1498: map.worker_id = g_worker_id
1499: AND hd9.project_id = map.project_id
1500: AND hd9.project_id = bv.project_id

Line 1518: , pji_pjp_wbs_header hd1 -- SUB

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
1519: , pji_pjp_proj_batch_map map
1520: , pa_budget_versions bv
1521: , pji_pjp_wbs_header hd9 -- SUP
1522: WHERE

Line 1521: , pji_pjp_wbs_header hd9 -- SUP

1517: FROM pji_xbs_denorm den
1518: , pji_pjp_wbs_header hd1 -- SUB
1519: , pji_pjp_proj_batch_map map
1520: , pa_budget_versions bv
1521: , pji_pjp_wbs_header hd9 -- SUP
1522: WHERE
1523: den.struct_version_id IS NULL
1524: AND map.project_id = bv.project_id
1525: AND map.project_id = hd1.project_id

Line 1552: UPDATE pji_pjp_wbs_header hd9 -- SUP

1548:
1549: OPEN c_get_hdrs_lock_ver3_t_cur;
1550: CLOSE c_get_hdrs_lock_ver3_t_cur;
1551:
1552: UPDATE pji_pjp_wbs_header hd9 -- SUP
1553: SET lock_flag = p_update_mode
1554: , LAST_UPDATE_DATE = l_last_update_date
1555: , LAST_UPDATED_BY = l_last_updated_by
1556: , LAST_UPDATE_LOGIN = l_last_update_login

Line 1572: update PJI_PJP_WBS_HEADER hd9

1568:
1569: OPEN c_get_hdrs_lock_map_cur;
1570: CLOSE c_get_hdrs_lock_map_cur;
1571:
1572: update PJI_PJP_WBS_HEADER hd9
1573: set LOCK_FLAG = null,
1574: LAST_UPDATE_DATE = l_last_update_date,
1575: LAST_UPDATED_BY = l_last_updated_by,
1576: LAST_UPDATE_LOGIN = l_last_update_login

Line 2479: , pji_pjp_wbs_header hd1 -- sup

2475: FROM
2476: pa_budget_versions bv
2477: , pa_proj_fp_options fpo
2478: , pji_pa_proj_events_log ev
2479: , pji_pjp_wbs_header hd1 -- sup
2480: , pji_pjp_wbs_header hd2 -- sub
2481: , pji_xbs_denorm den
2482: WHERE bv.version_type IS NOT NULL
2483: AND bv.fin_plan_type_id IS NOT NULL

Line 2480: , pji_pjp_wbs_header hd2 -- sub

2476: pa_budget_versions bv
2477: , pa_proj_fp_options fpo
2478: , pji_pa_proj_events_log ev
2479: , pji_pjp_wbs_header hd1 -- sup
2480: , pji_pjp_wbs_header hd2 -- sub
2481: , pji_xbs_denorm den
2482: WHERE bv.version_type IS NOT NULL
2483: AND bv.fin_plan_type_id IS NOT NULL
2484: AND fpo.project_id = bv.project_id

Line 2550: , pji_pjp_wbs_header hd1 -- sup

2546: FROM
2547: pa_budget_versions bv
2548: , pa_proj_fp_options fpo
2549: , PJI_PA_PROJ_EVENTS_LOG ev
2550: , pji_pjp_wbs_header hd1 -- sup
2551: , pji_pjp_wbs_header hd2 -- sub
2552: , pji_xbs_denorm den
2553: , (SELECT -3 plan_version_id FROM DUAL
2554: UNION ALL

Line 2551: , pji_pjp_wbs_header hd2 -- sub

2547: pa_budget_versions bv
2548: , pa_proj_fp_options fpo
2549: , PJI_PA_PROJ_EVENTS_LOG ev
2550: , pji_pjp_wbs_header hd1 -- sup
2551: , pji_pjp_wbs_header hd2 -- sub
2552: , pji_xbs_denorm den
2553: , (SELECT -3 plan_version_id FROM DUAL
2554: UNION ALL
2555: SELECT -4 plan_version_id FROM DUAL

Line 2640: , pji_pjp_wbs_header whsub

2636: AND map.project_id = bv.project_id
2637: ) fpo
2638: , pa_xbs_denorm den
2639: , pji_pjp_proj_batch_map map
2640: , pji_pjp_wbs_header whsub
2641: , ( SELECT -3 plan_version_id FROM dual
2642: UNION ALL
2643: SELECT -4 plan_version_id FROM dual ) cbco
2644: WHERE NVL(fpolc, 'PLAN_VERSION') = 'PLAN_VERSION'

Line 5681: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.

5677: , l_last_update_login
5678: FROM
5679: PJI_FP_RMAP_FPR rwid
5680: , pji_fp_aggr_pjp1 tmp
5681: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5682: WHERE 1 = 1
5683: AND tmp.rowid = rwid.tmp_rowid
5684: AND rl.rowid = rwid.rl_rowid
5685: --Commented for bug 5927368

Line 5816: SELECT /+ ordered index(ver3 PJI_PJP_WBS_HEADER_N1) /

5812: , CUSTOM15
5813: , PLAN_TYPE_CODE /*4471527 */
5814: )
5815: --Commented hint for bug 5927368
5816: SELECT /*+ ordered index(ver3 PJI_PJP_WBS_HEADER_N1) */
5817: -- SELECT / *+ ordered full(rwid) rowid(tmp) * /
5818: tmp.PROJECT_ID
5819: , tmp.PROJECT_ORG_ID
5820: , tmp.PROJECT_ORGANIZATION_ID

Line 5963: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.

5959: FROM
5960: --Commented for 5927368
5961: -- PJI_FP_RMAP_FPR rwid
5962: pji_fp_aggr_pjp1 tmp
5963: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5964: WHERE 1 = 1
5965: AND tmp.worker_id = g_worker_id
5966: --commented for 5927368 and added tmp.RECORD_TYPE <> 'U' condition
5967: -- AND rwid.worker_id = g_worker_id

Line 7252: INSERT INTO PJI_PJP_WBS_HEADER

7248: BEGIN
7249:
7250: print_time ( ' Before populate wbs header ' );
7251:
7252: INSERT INTO PJI_PJP_WBS_HEADER
7253: (
7254: PROJECT_ID
7255: , PLAN_VERSION_ID
7256: , WBS_VERSION_ID

Line 7289: , PJI_PJP_WBS_HEADER whdr

7285: , l_created_by
7286: , l_last_update_login
7287: , ver.plan_type_code
7288: FROM PJI_FM_EXTR_PLNVER4 ver
7289: , PJI_PJP_WBS_HEADER whdr
7290: WHERE ver.worker_id = g_worker_id
7291: AND ver.plan_version_id = whdr.plan_version_id (+)
7292: AND ver.plan_type_code = whdr.plan_type_code(+) /*4471527 */
7293: AND ver.project_id = whdr.project_id (+)

Line 7343: , pji_pjp_wbs_header whdr

7339: , MIN(LEAST(cal.start_date, NVL(whdr.min_txn_date, cal.start_date))) start_date
7340: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
7341: FROM PJI_FP_AGGR_PJP1 pjp1
7342: , pji_time_cal_period_v cal
7343: , pji_pjp_wbs_header whdr
7344: WHERE
7345: pjp1.worker_id = g_worker_id
7346: AND pjp1.project_id = whdr.project_id
7347: AND pjp1.plan_type_id = NVL(whdr.plan_type_id, -1)

Line 7355: UPDATE /+ index(whdr,PJI_PJP_WBS_HEADER_N1) /

7351: AND pjp1.plan_type_code = whdr.plan_type_code
7352: GROUP BY whdr.project_id, whdr.plan_type_id
7353: , whdr.plan_version_id, whdr.plan_type_code;
7354:
7355: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
7356: PJI_PJP_WBS_HEADER whdr
7357: SET ( MIN_TXN_DATE
7358: , MAX_TXN_DATE
7359: , LAST_UPDATE_DATE

Line 7356: PJI_PJP_WBS_HEADER whdr

7352: GROUP BY whdr.project_id, whdr.plan_type_id
7353: , whdr.plan_version_id, whdr.plan_type_code;
7354:
7355: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
7356: PJI_PJP_WBS_HEADER whdr
7357: SET ( MIN_TXN_DATE
7358: , MAX_TXN_DATE
7359: , LAST_UPDATE_DATE
7360: , LAST_UPDATED_BY

Line 11157: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;

11153: pjp1.worker_id = p_worker_id
11154: AND pjp1.time_id = cal.cal_period_id
11155: AND pjp1.calendar_type IN ('P', 'G') ; -- Non time ph and ent cals don't need to be considered.
11156:
11157: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
11158: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
11159: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
11160: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
11161: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;

Line 11158: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;

11154: AND pjp1.time_id = cal.cal_period_id
11155: AND pjp1.calendar_type IN ('P', 'G') ; -- Non time ph and ent cals don't need to be considered.
11156:
11157: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
11158: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
11159: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
11160: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
11161: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
11162: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;

Line 11159: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;

11155: AND pjp1.calendar_type IN ('P', 'G') ; -- Non time ph and ent cals don't need to be considered.
11156:
11157: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
11158: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
11159: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
11160: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
11161: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
11162: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
11163:

Line 11160: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;

11156:
11157: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
11158: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
11159: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
11160: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
11161: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
11162: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
11163:
11164: proj_id_tab proj_id_tab_TYPE;

Line 11161: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;

11157: TYPE proj_id_tab_type IS TABLE OF pji_pjp_wbs_header.project_id%TYPE;
11158: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
11159: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
11160: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
11161: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
11162: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
11163:
11164: proj_id_tab proj_id_tab_TYPE;
11165: plan_ver_id_tab plan_ver_id_tab_TYPE;

Line 11162: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;

11158: TYPE plan_ver_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_version_id%TYPE;
11159: TYPE plan_type_id_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_id%TYPE;
11160: TYPE plan_type_code_tab_type IS TABLE OF pji_pjp_wbs_header.plan_type_code%TYPE;
11161: TYPE min_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.min_txn_date%TYPE;
11162: TYPE max_txn_date_tab_type IS TABLE OF pji_pjp_wbs_header.max_txn_date%TYPE;
11163:
11164: proj_id_tab proj_id_tab_TYPE;
11165: plan_ver_id_tab plan_ver_id_tab_TYPE;
11166: plan_type_id_tab plan_type_id_tab_TYPE;

Line 11183: UPDATE /+ index(whdr,PJI_PJP_WBS_HEADER_N1) /

11179:
11180: -- EXIT WHEN wbs_cur%NOTFOUND; -- bug 6316433
11181: If proj_id_tab.count > 0 then
11182: FORALL i IN proj_id_tab.FIRST .. proj_id_tab.LAST
11183: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
11184: PJI_PJP_WBS_HEADER whdr
11185: SET MIN_TXN_DATE = LEAST(min_txn_date_tab(i), NVL(whdr.min_txn_date, min_txn_date_tab(i)))
11186: , MAX_TXN_DATE = GREATEST(max_txn_date_tab(i), NVL(whdr.max_txn_date, max_txn_date_tab(i)))
11187: , LAST_UPDATE_DATE = sysdate

Line 11184: PJI_PJP_WBS_HEADER whdr

11180: -- EXIT WHEN wbs_cur%NOTFOUND; -- bug 6316433
11181: If proj_id_tab.count > 0 then
11182: FORALL i IN proj_id_tab.FIRST .. proj_id_tab.LAST
11183: UPDATE /*+ index(whdr,PJI_PJP_WBS_HEADER_N1) */
11184: PJI_PJP_WBS_HEADER whdr
11185: SET MIN_TXN_DATE = LEAST(min_txn_date_tab(i), NVL(whdr.min_txn_date, min_txn_date_tab(i)))
11186: , MAX_TXN_DATE = GREATEST(max_txn_date_tab(i), NVL(whdr.max_txn_date, max_txn_date_tab(i)))
11187: , LAST_UPDATE_DATE = sysdate
11188: , LAST_UPDATED_BY = -9999

Line 11390: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.

11386: , tmp.CUSTOM14
11387: , tmp.CUSTOM15
11388: , tmp.PLAN_TYPE_CODE
11389: FROM pji_fp_aggr_pjp1 tmp
11390: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
11391: WHERE 1 = 1
11392: AND tmp.worker_id = g_worker_id
11393: AND tmp.project_id = ver3.project_id
11394: AND ver3.plan_version_id = tmp.plan_version_id