[Home] [Help]
1234: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
1235: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
1236: union all
1237: select /*+ ordered
1238: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
1239: -- get delta task level amounts from Reporting Lines
1240: to_char(null) LINE_TYPE,
1241: wbs_hdr.WBS_VERSION_ID,
1242: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,
1340: PJI_XBS_DENORM_DELTA wbs,
1341: --PJI_XBS_DENORM prg,
1342: PJI_XBS_DENORM_t prg,
1343: -- End of Commenting and adding code for testing 0802
1344: PJI_FP_XBS_ACCUM_F fpr,
1345: (
1346: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1347: from DUAL union all
1348: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2618: wbs_hdr.CB_FLAG = fin_plan.CB_FLAG (+) and
2619: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
2620: union all
2621: select /*+ ordered
2622: index(fpr PJI_FP_XBS_ACCUM_F_N1) */
2623: -- get delta task level amounts from Reporting Lines
2624: to_char(null) LINE_TYPE,
2625: wbs_hdr.WBS_VERSION_ID,
2626: decode(wbs_hdr.WP_FLAG, 'Y', 'LW', 'LF') RELATIONSHIP_TYPE,
2720: PJI_PA_PROJ_EVENTS_LOG log,
2721: PJI_PJP_WBS_HEADER wbs_hdr,
2722: PJI_XBS_DENORM_DELTA wbs,
2723: PJI_XBS_DENORM prg,
2724: PJI_FP_XBS_ACCUM_F fpr,
2725: (
2726: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2727: from DUAL union all
2728: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
4876: TYPE row_id_tab_type IS TABLE OF rowid index by binary_integer;
4877: x_row_id row_id_tab_type;
4878:
4879: cursor c1 (p_worker_id in number) is
4880: select rowid from PJI_FP_XBS_ACCUM_F
4881: where RBS_AGGR_LEVEL in ('L', 'R') and
4882: (PROJECT_ID,
4883: PLAN_VERSION_ID,
4884: RBS_VERSION_ID) in
4928:
4929: if (l_extraction_type = 'INCREMENTAL') then
4930:
4931: delete
4932: from PJI_FP_XBS_ACCUM_F
4933: where (RBS_AGGR_LEVEL,
4934: WBS_ROLLUP_FLAG,
4935: PRG_ROLLUP_FLAG) in (('L', 'Y', 'N'),
4936: ('R', 'N', 'N'),
4991: If x_row_id.count > 0 then
4992:
4993: Forall i in x_row_id.first..x_row_id.last
4994: delete
4995: from PJI_FP_XBS_ACCUM_F
4996: where rowid = x_row_id(i);
4997:
4998: x_row_id.delete;
4999:
8934: - fpr.custom14 CUSTOM14,
8935: - fpr.custom15 CUSTOM15 /* Modified for Bug 8271578 End */
8936: from
8937: PJI_PJP_PROJ_BATCH_MAP map,
8938: PJI_FP_XBS_ACCUM_F fpr
8939: where
8940: l_extraction_type = 'INCREMENTAL' and
8941: map.WORKER_ID = p_worker_id and
8942: map.EXTRACTION_TYPE = 'M' and
9025: - fpr.CUSTOM14 CUSTOM14,
9026: - fpr.CUSTOM15 CUSTOM15
9027: from
9028: PJI_FM_EXTR_PLNVER3_T map,
9029: PJI_FP_XBS_ACCUM_F fpr
9030: where
9031: l_extraction_type = 'PARTIAL' and
9032: map.WORKER_ID = p_worker_id and
9033: fpr.PROJECT_ID = map.PROJECT_ID and
12094: wbs_hdr.CO_FLAG = fin_plan.CO_FLAG (+)
12095: union all
12096: select /*+ ordered
12097: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
12098: index(fpr PJI_FP_XBS_ACCUM_F_N1)
12099: index(prg pji_xbs_denorm_n3) */ -- Bug 10632614
12100: -- get delta task level amounts from Reporting Lines
12101: to_char(null) LINE_TYPE,
12102: wbs_hdr.WBS_VERSION_ID,
12197: PA_PJI_PROJ_EVENTS_LOG log,
12198: PJI_PJP_WBS_HEADER wbs_hdr,
12199: PJI_XBS_DENORM_DELTA_T wbs,
12200: PJI_XBS_DENORM prg,
12201: PJI_FP_XBS_ACCUM_F fpr,
12202: (
12203: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12204: from DUAL union all
12205: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12268: wbs.SUB_LEVEL = 1))
12269: union all
12270: select /*+ ordered
12271: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
12272: index(fpr PJI_FP_XBS_ACCUM_F_N1)
12273: index(prg pji_xbs_denorm_n3) */ -- Bug 10632614
12274: -- Baseline reversals and fact amounts (-3 slice)
12275: -- Current Original reversals and fact amounts (-4 slice)
12276: -- Part 1
12627: PA_PJI_PROJ_EVENTS_LOG log,
12628: PJI_PJP_WBS_HEADER wbs_hdr,
12629: -- Changes done for bug 7354982.
12630: --PJI_XBS_DENORM prg,
12631: PJI_FP_XBS_ACCUM_F fpr,
12632: PJI_XBS_DENORM prg
12633: where
12634: prg.STRUCT_TYPE = 'PRG' and
12635: prg.SUP_LEVEL = l_level and
12663: prg.struct_version_id is NULL -- added for bug 5882260
12664: union all
12665: select /*+ ordered
12666: index(log PA_PJI_PROJ_EVENTS_LOG_N2)
12667: index(fpr PJI_FP_XBS_ACCUM_F_N1)
12668: index(prg pji_xbs_denorm_n3) */ -- Bug 10632614
12669: -- Baseline reversals and fact amounts (-3 slice)
12670: -- Current Original reversals and fact amounts (-4 slice)
12671: -- Part 2
13022: PA_PJI_PROJ_EVENTS_LOG log,
13023: PJI_PJP_WBS_HEADER wbs_hdr,
13024: -- Changes done for bug 7354982.
13025: --PJI_XBS_DENORM prg,
13026: PJI_FP_XBS_ACCUM_F fpr,
13027: PJI_XBS_DENORM prg
13028: where
13029: prg.STRUCT_TYPE = 'PRG' and
13030: prg.SUP_LEVEL = l_level and
15811: sum(pjp.CUSTOM14) CUSTOM14,
15812: sum(pjp.CUSTOM15) CUSTOM15
15813: from
15814: (
15815: select /*+ ordered index(fpr PJI_FP_XBS_ACCUM_F_N1) */
15816: -- get structure level amounts from Reporting Lines
15817: /* decode(fpr.RBS_AGGR_LEVEL,
15818: 'L', 'DO_NOT_ROLLUP',
15819: 'WBS') STRUCT_TYPE,
16131: from
16132: PJI_XBS_DENORM_DELTA prg,
16133: PA_PROJ_ELEMENTS prj_emt,
16134: PJI_PJP_WBS_HEADER wbs_hdr,
16135: PJI_FP_XBS_ACCUM_F fpr,
16136: PJI_PJP_WBS_HEADER sup_wbs_hdr,
16137: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16138: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16139: (