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_PJP_SUM_ROLLUP dependencies on DUAL

Line 1496: -- FROM DUAL ;

1492: -- x_return_status => l_return_status);
1493:
1494: -- SELECT DECODE(l_extraction_type, 'PARTIAL', 'PLANTYPE', l_extraction_type)
1495: -- INTO l_extraction_type
1496: -- FROM DUAL ;
1497:
1498: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (
1499: p_context => l_extraction_type
1500: , p_lock_mode => 'P'

Line 2032: dual

2028: l_created_by,
2029: l_last_update_login,
2030: 'A'
2031: from
2032: dual
2033: where
2034: not exists
2035: (
2036: select

Line 2239: DUAL

2235: c.RBS_VERSION_ID,
2236: 'I',
2237: 'X'
2238: from
2239: DUAL
2240: where
2241: not exists (select 1
2242: from PA_RBS_DENORM rbs
2243: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 2356: DUAL

2352: c.RBS_VERSION_ID,
2353: 'I',
2354: 'X'
2355: from
2356: DUAL
2357: where
2358: not exists (select 1
2359: from PA_RBS_DENORM rbs
2360: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 2433: DUAL

2429: c.RBS_VERSION_ID,
2430: 'I',
2431: 'X'
2432: from
2433: DUAL
2434: where
2435: not exists (select 1
2436: from PA_RBS_DENORM rbs
2437: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 2948: DUAL

2944: c.RBS_VERSION_ID,
2945: 'I',
2946: 'X'
2947: from
2948: DUAL
2949: where
2950: not exists (select 1
2951: from PA_RBS_DENORM rbs
2952: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 4267: select 1 INVERT_ID from dual

4263: PJI_ORG_EXTR_INFO info,
4264: PJI_PJP_WBS_HEADER wbs_hdr,
4265: PA_PROJ_ELEMENT_VERSIONS ver,
4266: (
4267: select 1 INVERT_ID from dual
4268: where l_g1_currency_code is not null union all
4269: select 2 INVERT_ID from dual
4270: where l_g2_currency_flag = 'Y' and
4271: l_g2_currency_code is not null union all

Line 4269: select 2 INVERT_ID from dual

4265: PA_PROJ_ELEMENT_VERSIONS ver,
4266: (
4267: select 1 INVERT_ID from dual
4268: where l_g1_currency_code is not null union all
4269: select 2 INVERT_ID from dual
4270: where l_g2_currency_flag = 'Y' and
4271: l_g2_currency_code is not null union all
4272: select 4 INVERT_ID from dual union all
4273: select 8 INVERT_ID from dual union all

Line 4272: select 4 INVERT_ID from dual union all

4268: where l_g1_currency_code is not null union all
4269: select 2 INVERT_ID from dual
4270: where l_g2_currency_flag = 'Y' and
4271: l_g2_currency_code is not null union all
4272: select 4 INVERT_ID from dual union all
4273: select 8 INVERT_ID from dual union all
4274: select 16 INVERT_ID from dual
4275: where l_txn_currency_flag = 'Y'
4276: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

Line 4273: select 8 INVERT_ID from dual union all

4269: select 2 INVERT_ID from dual
4270: where l_g2_currency_flag = 'Y' and
4271: l_g2_currency_code is not null union all
4272: select 4 INVERT_ID from dual union all
4273: select 8 INVERT_ID from dual union all
4274: select 16 INVERT_ID from dual
4275: where l_txn_currency_flag = 'Y'
4276: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4277: -- where l_g1_currency_code is not null union all

Line 4274: select 16 INVERT_ID from dual

4270: where l_g2_currency_flag = 'Y' and
4271: l_g2_currency_code is not null union all
4272: select 4 INVERT_ID from dual union all
4273: select 8 INVERT_ID from dual union all
4274: select 16 INVERT_ID from dual
4275: where l_txn_currency_flag = 'Y'
4276: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4277: -- where l_g1_currency_code is not null union all
4278: -- select 64 INVERT_ID from dual

Line 4276: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

4272: select 4 INVERT_ID from dual union all
4273: select 8 INVERT_ID from dual union all
4274: select 16 INVERT_ID from dual
4275: where l_txn_currency_flag = 'Y'
4276: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4277: -- where l_g1_currency_code is not null union all
4278: -- select 64 INVERT_ID from dual
4279: -- where l_g2_currency_flag = 'Y' and
4280: -- l_g2_currency_code is not null union all

Line 4278: -- select 64 INVERT_ID from dual

4274: select 16 INVERT_ID from dual
4275: where l_txn_currency_flag = 'Y'
4276: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4277: -- where l_g1_currency_code is not null union all
4278: -- select 64 INVERT_ID from dual
4279: -- where l_g2_currency_flag = 'Y' and
4280: -- l_g2_currency_code is not null union all
4281: -- select 128 INVERT_ID from dual union all
4282: -- select 256 INVERT_ID from dual

Line 4281: -- select 128 INVERT_ID from dual union all

4277: -- where l_g1_currency_code is not null union all
4278: -- select 64 INVERT_ID from dual
4279: -- where l_g2_currency_flag = 'Y' and
4280: -- l_g2_currency_code is not null union all
4281: -- select 128 INVERT_ID from dual union all
4282: -- select 256 INVERT_ID from dual
4283: ) invert
4284: where
4285: src.TXN_ACCUM_HEADER_ID = rbs.TXN_ACCUM_HEADER_ID (+) and

Line 4282: -- select 256 INVERT_ID from dual

4278: -- select 64 INVERT_ID from dual
4279: -- where l_g2_currency_flag = 'Y' and
4280: -- l_g2_currency_code is not null union all
4281: -- select 128 INVERT_ID from dual union all
4282: -- select 256 INVERT_ID from dual
4283: ) invert
4284: where
4285: src.TXN_ACCUM_HEADER_ID = rbs.TXN_ACCUM_HEADER_ID (+) and
4286: src.RBS_VERSION_ID = rbs.STRUCT_VERSION_ID (+) and

Line 4963: select 1 INVERT_ID from dual

4959: PJI_PJP_PROJ_BATCH_MAP map,
4960: PJI_PJP_WBS_HEADER wbs_hdr,
4961: PA_PROJ_ELEMENT_VERSIONS ver,
4962: (
4963: select 1 INVERT_ID from dual
4964: where l_g1_currency_code is not null union all
4965: select 2 INVERT_ID from dual
4966: where l_g2_currency_flag = 'Y' and
4967: l_g2_currency_code is not null union all

Line 4965: select 2 INVERT_ID from dual

4961: PA_PROJ_ELEMENT_VERSIONS ver,
4962: (
4963: select 1 INVERT_ID from dual
4964: where l_g1_currency_code is not null union all
4965: select 2 INVERT_ID from dual
4966: where l_g2_currency_flag = 'Y' and
4967: l_g2_currency_code is not null union all
4968: select 4 INVERT_ID from dual union all
4969: select 8 INVERT_ID from dual union all

Line 4968: select 4 INVERT_ID from dual union all

4964: where l_g1_currency_code is not null union all
4965: select 2 INVERT_ID from dual
4966: where l_g2_currency_flag = 'Y' and
4967: l_g2_currency_code is not null union all
4968: select 4 INVERT_ID from dual union all
4969: select 8 INVERT_ID from dual union all
4970: select 16 INVERT_ID from dual
4971: where l_txn_currency_flag = 'Y'
4972: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

Line 4969: select 8 INVERT_ID from dual union all

4965: select 2 INVERT_ID from dual
4966: where l_g2_currency_flag = 'Y' and
4967: l_g2_currency_code is not null union all
4968: select 4 INVERT_ID from dual union all
4969: select 8 INVERT_ID from dual union all
4970: select 16 INVERT_ID from dual
4971: where l_txn_currency_flag = 'Y'
4972: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4973: -- where l_g1_currency_code is not null union all

Line 4970: select 16 INVERT_ID from dual

4966: where l_g2_currency_flag = 'Y' and
4967: l_g2_currency_code is not null union all
4968: select 4 INVERT_ID from dual union all
4969: select 8 INVERT_ID from dual union all
4970: select 16 INVERT_ID from dual
4971: where l_txn_currency_flag = 'Y'
4972: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4973: -- where l_g1_currency_code is not null union all
4974: -- select 64 INVERT_ID from dual

Line 4972: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

4968: select 4 INVERT_ID from dual union all
4969: select 8 INVERT_ID from dual union all
4970: select 16 INVERT_ID from dual
4971: where l_txn_currency_flag = 'Y'
4972: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4973: -- where l_g1_currency_code is not null union all
4974: -- select 64 INVERT_ID from dual
4975: -- where l_g2_currency_flag = 'Y' and
4976: -- l_g2_currency_code is not null union all

Line 4974: -- select 64 INVERT_ID from dual

4970: select 16 INVERT_ID from dual
4971: where l_txn_currency_flag = 'Y'
4972: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
4973: -- where l_g1_currency_code is not null union all
4974: -- select 64 INVERT_ID from dual
4975: -- where l_g2_currency_flag = 'Y' and
4976: -- l_g2_currency_code is not null union all
4977: -- select 128 INVERT_ID from dual union all
4978: -- select 256 INVERT_ID from dual

Line 4977: -- select 128 INVERT_ID from dual union all

4973: -- where l_g1_currency_code is not null union all
4974: -- select 64 INVERT_ID from dual
4975: -- where l_g2_currency_flag = 'Y' and
4976: -- l_g2_currency_code is not null union all
4977: -- select 128 INVERT_ID from dual union all
4978: -- select 256 INVERT_ID from dual
4979: ) invert
4980: where
4981: map.WORKER_ID = p_worker_id and

Line 4978: -- select 256 INVERT_ID from dual

4974: -- select 64 INVERT_ID from dual
4975: -- where l_g2_currency_flag = 'Y' and
4976: -- l_g2_currency_code is not null union all
4977: -- select 128 INVERT_ID from dual union all
4978: -- select 256 INVERT_ID from dual
4979: ) invert
4980: where
4981: map.WORKER_ID = p_worker_id and
4982: src.PROJECT_ID = map.PROJECT_ID and

Line 5223: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual

5219: (
5220: Select decode(
5221: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5222: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
5223: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
5224: UNION ALL
5225: Select decode(
5226: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5227: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

Line 5227: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

5223: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
5224: UNION ALL
5225: Select decode(
5226: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
5227: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
5228: )
5229: OR -- Bug#5099574 Pull Reversals for Fin plan Working Versions when l_refresh_code=16,30. ignore if l_refresh_code>=62
5230: (
5231: bv.BUDGET_STATUS_CODE in ('W','S') and

Line 5258: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null

5254: map.worker_id,map.project_id, plan_version_id, 'G' time_phased_code
5255: from
5256: PJI_PJP_PROJ_BATCH_MAP map,
5257: (
5258: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5259: union all
5260: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5261: union all
5262: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual

Line 5260: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual

5256: PJI_PJP_PROJ_BATCH_MAP map,
5257: (
5258: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5259: union all
5260: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5261: union all
5262: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
5263: )
5264: where map.worker_id=p_worker_id;

Line 5262: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual

5258: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
5259: union all
5260: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
5261: union all
5262: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
5263: )
5264: where map.worker_id=p_worker_id;
5265:
5266:

Line 6607: select 'ACTIVITY' INVERT_ID from DUAL union all

6603: PJI_AC_AGGR_PJP0 pjp0, -- Bug 6689297
6604: PJI_TIME_RPT_STRUCT cal,
6605: PJI_TIME_ENT_PERIOD_V ent,
6606: (
6607: select 'ACTIVITY' INVERT_ID from DUAL union all
6608: select 'SNAPSHOT' INVERT_ID from DUAL
6609: ) invert
6610: where
6611: l_extraction_type <> 'PARTIAL' and

Line 6608: select 'SNAPSHOT' INVERT_ID from DUAL

6604: PJI_TIME_RPT_STRUCT cal,
6605: PJI_TIME_ENT_PERIOD_V ent,
6606: (
6607: select 'ACTIVITY' INVERT_ID from DUAL union all
6608: select 'SNAPSHOT' INVERT_ID from DUAL
6609: ) invert
6610: where
6611: l_extraction_type <> 'PARTIAL' and
6612: map.WORKER_ID = p_worker_id and

Line 6751: select 'ACTIVITY' INVERT_ID from DUAL union all

6747: PJI_TIME_CAL_RPT_STRUCT cal,
6748: PJI_ORG_EXTR_INFO info,
6749: PJI_TIME_CAL_PERIOD_V gl_cal,
6750: (
6751: select 'ACTIVITY' INVERT_ID from DUAL union all
6752: select 'SNAPSHOT' INVERT_ID from DUAL
6753: ) invert
6754: where
6755: l_extraction_type <> 'PARTIAL' and

Line 6752: select 'SNAPSHOT' INVERT_ID from DUAL

6748: PJI_ORG_EXTR_INFO info,
6749: PJI_TIME_CAL_PERIOD_V gl_cal,
6750: (
6751: select 'ACTIVITY' INVERT_ID from DUAL union all
6752: select 'SNAPSHOT' INVERT_ID from DUAL
6753: ) invert
6754: where
6755: l_extraction_type <> 'PARTIAL' and
6756: map.WORKER_ID = p_worker_id and

Line 6898: select 'ACTIVITY' INVERT_ID from DUAL union all

6894: PJI_TIME_CAL_RPT_STRUCT cal,
6895: PJI_ORG_EXTR_INFO info,
6896: PJI_TIME_CAL_PERIOD_V pa_cal,
6897: (
6898: select 'ACTIVITY' INVERT_ID from DUAL union all
6899: select 'SNAPSHOT' INVERT_ID from DUAL
6900: ) invert
6901: where
6902: l_extraction_type <> 'PARTIAL' and

Line 6899: select 'SNAPSHOT' INVERT_ID from DUAL

6895: PJI_ORG_EXTR_INFO info,
6896: PJI_TIME_CAL_PERIOD_V pa_cal,
6897: (
6898: select 'ACTIVITY' INVERT_ID from DUAL union all
6899: select 'SNAPSHOT' INVERT_ID from DUAL
6900: ) invert
6901: where
6902: l_extraction_type <> 'PARTIAL' and
6903: map.WORKER_ID = p_worker_id and

Line 7589: from dual;

7585: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'C');
7586:
7587: select decode(l_extraction_type,'PARTIAL','PARTIAL',NULL)
7588: into l_partial_mode
7589: from dual;
7590:
7591: -- allow recovery after each level is processed
7592:
7593: select

Line 7651: DUAL;

7647: 'ROLLUP_FPR_WBS - level ' || to_char(l_level - x + 1) STEP_NAME,
7648: null START_DATE,
7649: null END_DATE
7650: from
7651: DUAL;
7652:
7653: end loop;
7654:
7655: end if;

Line 8477: from DUAL union all

8473: PA_XBS_DENORM wbs,
8474: PJI_XBS_DENORM prg,
8475: (
8476: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8477: from DUAL union all
8478: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8479: from DUAL union all
8480: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8481: from DUAL union all

Line 8479: from DUAL union all

8475: (
8476: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8477: from DUAL union all
8478: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8479: from DUAL union all
8480: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8481: from DUAL union all
8482: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8483: from DUAL union all

Line 8481: from DUAL union all

8477: from DUAL union all
8478: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8479: from DUAL union all
8480: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8481: from DUAL union all
8482: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8483: from DUAL union all
8484: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8485: from DUAL union all

Line 8483: from DUAL union all

8479: from DUAL union all
8480: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8481: from DUAL union all
8482: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8483: from DUAL union all
8484: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8485: from DUAL union all
8486: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8487: from DUAL union all

Line 8485: from DUAL union all

8481: from DUAL union all
8482: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8483: from DUAL union all
8484: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8485: from DUAL union all
8486: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8487: from DUAL union all
8488: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8489: from DUAL union all

Line 8487: from DUAL union all

8483: from DUAL union all
8484: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8485: from DUAL union all
8486: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8487: from DUAL union all
8488: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8489: from DUAL union all
8490: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8491: from DUAL

Line 8489: from DUAL union all

8485: from DUAL union all
8486: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8487: from DUAL union all
8488: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8489: from DUAL union all
8490: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8491: from DUAL
8492: ) fin_plan,
8493: (

Line 8491: from DUAL

8487: from DUAL union all
8488: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8489: from DUAL union all
8490: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8491: from DUAL
8492: ) fin_plan,
8493: (
8494: select 1 WBS_SUP_LEVEL,
8495: 1 WBS_SUB_LEVEL,

Line 8497: from DUAL

8493: (
8494: select 1 WBS_SUP_LEVEL,
8495: 1 WBS_SUB_LEVEL,
8496: 'PRJ' INVERT_ID
8497: from DUAL
8498: union all
8499: select 1 WBS_SUP_LEVEL,
8500: 1 WBS_SUB_LEVEL,
8501: 'WBS' INVERT_ID

Line 8502: from DUAL

8498: union all
8499: select 1 WBS_SUP_LEVEL,
8500: 1 WBS_SUB_LEVEL,
8501: 'WBS' INVERT_ID
8502: from DUAL
8503: ) top_slice
8504: where
8505: prg.STRUCT_TYPE = 'PRG' and
8506: prg.SUP_LEVEL = l_level and

Line 8632: from DUAL union all

8628: (
8629: select 'Y' CB_FLAG,
8630: 'N' CO_FLAG,
8631: -3 PLAN_VERSION_ID
8632: from DUAL union all
8633: select 'N' CB_FLAG,
8634: 'Y' CO_FLAG,
8635: -4 PLAN_VERSION_ID
8636: from DUAL union all

Line 8636: from DUAL union all

8632: from DUAL union all
8633: select 'N' CB_FLAG,
8634: 'Y' CO_FLAG,
8635: -4 PLAN_VERSION_ID
8636: from DUAL union all
8637: select 'Y' CB_FLAG,
8638: 'Y' CO_FLAG,
8639: -3 PLAN_VERSION_ID
8640: from DUAL union all

Line 8640: from DUAL union all

8636: from DUAL union all
8637: select 'Y' CB_FLAG,
8638: 'Y' CO_FLAG,
8639: -3 PLAN_VERSION_ID
8640: from DUAL union all
8641: select 'Y' CB_FLAG,
8642: 'Y' CO_FLAG,
8643: -4 PLAN_VERSION_ID
8644: from DUAL

Line 8644: from DUAL

8640: from DUAL union all
8641: select 'Y' CB_FLAG,
8642: 'Y' CO_FLAG,
8643: -4 PLAN_VERSION_ID
8644: from DUAL
8645: ) fin_plan
8646: where
8647: prg.STRUCT_TYPE = 'PRG' and
8648: prg.SUP_LEVEL = l_level and

Line 8783: from DUAL union all

8779: PJI_XBS_DENORM prg,
8780: PJI_FP_XBS_ACCUM_F fpr,
8781: (
8782: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8783: from DUAL union all
8784: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8785: from DUAL union all
8786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8787: from DUAL union all

Line 8785: from DUAL union all

8781: (
8782: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8783: from DUAL union all
8784: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8785: from DUAL union all
8786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8787: from DUAL union all
8788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8789: from DUAL union all

Line 8787: from DUAL union all

8783: from DUAL union all
8784: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8785: from DUAL union all
8786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8787: from DUAL union all
8788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8789: from DUAL union all
8790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8791: from DUAL union all

Line 8789: from DUAL union all

8785: from DUAL union all
8786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8787: from DUAL union all
8788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8789: from DUAL union all
8790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8791: from DUAL union all
8792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8793: from DUAL union all

Line 8791: from DUAL union all

8787: from DUAL union all
8788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8789: from DUAL union all
8790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8791: from DUAL union all
8792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8793: from DUAL union all
8794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8795: from DUAL union all

Line 8793: from DUAL union all

8789: from DUAL union all
8790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
8791: from DUAL union all
8792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8793: from DUAL union all
8794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8795: from DUAL union all
8796: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8797: from DUAL

Line 8795: from DUAL union all

8791: from DUAL union all
8792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8793: from DUAL union all
8794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8795: from DUAL union all
8796: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8797: from DUAL
8798: ) fin_plan,
8799: (

Line 8797: from DUAL

8793: from DUAL union all
8794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
8795: from DUAL union all
8796: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
8797: from DUAL
8798: ) fin_plan,
8799: (
8800: select 1 WBS_SUP_LEVEL,
8801: 1 WBS_SUB_LEVEL,

Line 8803: from DUAL

8799: (
8800: select 1 WBS_SUP_LEVEL,
8801: 1 WBS_SUB_LEVEL,
8802: 'PRJ' INVERT_ID
8803: from DUAL
8804: union all
8805: select 1 WBS_SUP_LEVEL,
8806: 1 WBS_SUB_LEVEL,
8807: 'WBS' INVERT_ID

Line 8808: from DUAL

8804: union all
8805: select 1 WBS_SUP_LEVEL,
8806: 1 WBS_SUB_LEVEL,
8807: 'WBS' INVERT_ID
8808: from DUAL
8809: ) top_slice
8810: where
8811: prg.STRUCT_TYPE = 'PRG' and
8812: prg.SUP_LEVEL = l_level and

Line 8869: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

8865: from
8866: PJI_PJP_PROJ_BATCH_MAP map,
8867: PJI_XBS_DENORM prg,
8868: (
8869: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8870: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8871: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8872: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8873: ) invert,

Line 8870: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

8866: PJI_PJP_PROJ_BATCH_MAP map,
8867: PJI_XBS_DENORM prg,
8868: (
8869: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8870: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8871: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8872: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8873: ) invert,
8874: PJI_XBS_DENORM_DELTA prg_delta

Line 8871: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

8867: PJI_XBS_DENORM prg,
8868: (
8869: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8870: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8871: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8872: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8873: ) invert,
8874: PJI_XBS_DENORM_DELTA prg_delta
8875: where

Line 8872: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

8868: (
8869: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8870: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
8871: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
8872: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
8873: ) invert,
8874: PJI_XBS_DENORM_DELTA prg_delta
8875: where
8876: prg.STRUCT_TYPE = 'PRG' and

Line 9783: from DUAL union all

9779: PA_XBS_DENORM wbs,
9780: PJI_XBS_DENORM prg,
9781: (
9782: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9783: from DUAL union all
9784: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9785: from DUAL union all
9786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9787: from DUAL union all

Line 9785: from DUAL union all

9781: (
9782: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9783: from DUAL union all
9784: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9785: from DUAL union all
9786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9787: from DUAL union all
9788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9789: from DUAL union all

Line 9787: from DUAL union all

9783: from DUAL union all
9784: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9785: from DUAL union all
9786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9787: from DUAL union all
9788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9789: from DUAL union all
9790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9791: from DUAL union all

Line 9789: from DUAL union all

9785: from DUAL union all
9786: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9787: from DUAL union all
9788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9789: from DUAL union all
9790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9791: from DUAL union all
9792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9793: from DUAL union all

Line 9791: from DUAL union all

9787: from DUAL union all
9788: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9789: from DUAL union all
9790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9791: from DUAL union all
9792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9793: from DUAL union all
9794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9795: from DUAL union all

Line 9793: from DUAL union all

9789: from DUAL union all
9790: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
9791: from DUAL union all
9792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9793: from DUAL union all
9794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9795: from DUAL union all
9796: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9797: from DUAL

Line 9795: from DUAL union all

9791: from DUAL union all
9792: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9793: from DUAL union all
9794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9795: from DUAL union all
9796: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9797: from DUAL
9798: ) fin_plan,
9799: (

Line 9797: from DUAL

9793: from DUAL union all
9794: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
9795: from DUAL union all
9796: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
9797: from DUAL
9798: ) fin_plan,
9799: (
9800: select 1 WBS_SUP_LEVEL,
9801: 1 WBS_SUB_LEVEL,

Line 9803: from DUAL

9799: (
9800: select 1 WBS_SUP_LEVEL,
9801: 1 WBS_SUB_LEVEL,
9802: 'PRJ' INVERT_ID
9803: from DUAL
9804: union all
9805: select 1 WBS_SUP_LEVEL,
9806: 1 WBS_SUB_LEVEL,
9807: 'WBS' INVERT_ID

Line 9808: from DUAL

9804: union all
9805: select 1 WBS_SUP_LEVEL,
9806: 1 WBS_SUB_LEVEL,
9807: 'WBS' INVERT_ID
9808: from DUAL
9809: ) top_slice
9810: where
9811: prg.STRUCT_TYPE = 'PRG' and
9812: prg.SUP_LEVEL = l_level and

Line 9938: from DUAL union all

9934: (
9935: select 'Y' CB_FLAG,
9936: 'N' CO_FLAG,
9937: -3 PLAN_VERSION_ID
9938: from DUAL union all
9939: select 'N' CB_FLAG,
9940: 'Y' CO_FLAG,
9941: -4 PLAN_VERSION_ID
9942: from DUAL union all

Line 9942: from DUAL union all

9938: from DUAL union all
9939: select 'N' CB_FLAG,
9940: 'Y' CO_FLAG,
9941: -4 PLAN_VERSION_ID
9942: from DUAL union all
9943: select 'Y' CB_FLAG,
9944: 'Y' CO_FLAG,
9945: -3 PLAN_VERSION_ID
9946: from DUAL union all

Line 9946: from DUAL union all

9942: from DUAL union all
9943: select 'Y' CB_FLAG,
9944: 'Y' CO_FLAG,
9945: -3 PLAN_VERSION_ID
9946: from DUAL union all
9947: select 'Y' CB_FLAG,
9948: 'Y' CO_FLAG,
9949: -4 PLAN_VERSION_ID
9950: from DUAL

Line 9950: from DUAL

9946: from DUAL union all
9947: select 'Y' CB_FLAG,
9948: 'Y' CO_FLAG,
9949: -4 PLAN_VERSION_ID
9950: from DUAL
9951: ) fin_plan
9952: where
9953: prg.STRUCT_TYPE = 'PRG' and
9954: prg.SUP_LEVEL = l_level and

Line 10090: from DUAL union all

10086: PJI_XBS_DENORM prg,
10087: PJI_FP_XBS_ACCUM_F fpr,
10088: (
10089: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10090: from DUAL union all
10091: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10092: from DUAL union all
10093: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10094: from DUAL union all

Line 10092: from DUAL union all

10088: (
10089: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10090: from DUAL union all
10091: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10092: from DUAL union all
10093: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10094: from DUAL union all
10095: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10096: from DUAL union all

Line 10094: from DUAL union all

10090: from DUAL union all
10091: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10092: from DUAL union all
10093: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10094: from DUAL union all
10095: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10096: from DUAL union all
10097: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10098: from DUAL union all

Line 10096: from DUAL union all

10092: from DUAL union all
10093: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10094: from DUAL union all
10095: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10096: from DUAL union all
10097: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10098: from DUAL union all
10099: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10100: from DUAL union all

Line 10098: from DUAL union all

10094: from DUAL union all
10095: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10096: from DUAL union all
10097: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10098: from DUAL union all
10099: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10100: from DUAL union all
10101: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10102: from DUAL union all

Line 10100: from DUAL union all

10096: from DUAL union all
10097: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
10098: from DUAL union all
10099: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10100: from DUAL union all
10101: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10102: from DUAL union all
10103: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10104: from DUAL

Line 10102: from DUAL union all

10098: from DUAL union all
10099: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10100: from DUAL union all
10101: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10102: from DUAL union all
10103: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10104: from DUAL
10105: ) fin_plan,
10106: (

Line 10104: from DUAL

10100: from DUAL union all
10101: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
10102: from DUAL union all
10103: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
10104: from DUAL
10105: ) fin_plan,
10106: (
10107: select 1 WBS_SUP_LEVEL,
10108: 1 WBS_SUB_LEVEL,

Line 10110: from DUAL

10106: (
10107: select 1 WBS_SUP_LEVEL,
10108: 1 WBS_SUB_LEVEL,
10109: 'PRJ' INVERT_ID
10110: from DUAL
10111: union all
10112: select 1 WBS_SUP_LEVEL,
10113: 1 WBS_SUB_LEVEL,
10114: 'WBS' INVERT_ID

Line 10115: from DUAL

10111: union all
10112: select 1 WBS_SUP_LEVEL,
10113: 1 WBS_SUB_LEVEL,
10114: 'WBS' INVERT_ID
10115: from DUAL
10116: ) top_slice
10117: where
10118: prg.STRUCT_TYPE = 'PRG' and
10119: prg.SUP_LEVEL = l_level and

Line 10962: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

10958: from
10959: PJI_XBS_DENORM prg,
10960: PA_PROJECTS_ALL prj,
10961: (
10962: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10963: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10964: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10965: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10966: ) invert

Line 10963: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

10959: PJI_XBS_DENORM prg,
10960: PA_PROJECTS_ALL prj,
10961: (
10962: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10963: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10964: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10965: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10966: ) invert
10967: where

Line 10964: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

10960: PA_PROJECTS_ALL prj,
10961: (
10962: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10963: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10964: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10965: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10966: ) invert
10967: where
10968: l_level > 1 and

Line 10965: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

10961: (
10962: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10963: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
10964: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
10965: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
10966: ) invert
10967: where
10968: l_level > 1 and
10969: prg.STRUCT_TYPE = 'PRG' and

Line 11498: from DUAL

11494: PA_XBS_DENORM wbs,
11495: (
11496: select 1 WBS_SUP_LEVEL,
11497: 'PRJ' INVERT_ID
11498: from DUAL
11499: union all
11500: select 1 WBS_SUP_LEVEL,
11501: 'WBS' INVERT_ID
11502: from DUAL

Line 11502: from DUAL

11498: from DUAL
11499: union all
11500: select 1 WBS_SUP_LEVEL,
11501: 'WBS' INVERT_ID
11502: from DUAL
11503: ) top_slice
11504: where
11505: l_extraction_type <> 'RBS' and
11506: 'WBS' = wbs.STRUCT_TYPE (+) and

Line 11953: from DUAL

11949: PA_XBS_DENORM wbs,
11950: (
11951: select 1 WBS_SUP_LEVEL,
11952: 'PRJ' INVERT_ID
11953: from DUAL
11954: union all
11955: select 1 WBS_SUP_LEVEL,
11956: 'WBS' INVERT_ID
11957: from DUAL

Line 11957: from DUAL

11953: from DUAL
11954: union all
11955: select 1 WBS_SUP_LEVEL,
11956: 'WBS' INVERT_ID
11957: from DUAL
11958: ) top_slice
11959: where
11960: -- l_extraction_type <> 'RBS' and
11961: 'WBS' = wbs.STRUCT_TYPE (+) and

Line 12118: DUAL;

12114: 'ROLLUP_ACR_WBS - level ' || to_char(l_level - x + 1) STEP_NAME,
12115: null START_DATE,
12116: null END_DATE
12117: from
12118: DUAL;
12119:
12120: end loop;
12121:
12122: end if;

Line 12423: from DUAL

12419: (
12420: select 1 WBS_SUP_LEVEL,
12421: 1 WBS_SUB_LEVEL,
12422: 'PRJ' INVERT_ID
12423: from DUAL
12424: union all
12425: select 1 WBS_SUP_LEVEL,
12426: 1 WBS_SUB_LEVEL,
12427: 'WBS' INVERT_ID

Line 12428: from DUAL

12424: union all
12425: select 1 WBS_SUP_LEVEL,
12426: 1 WBS_SUB_LEVEL,
12427: 'WBS' INVERT_ID
12428: from DUAL
12429: ) top_slice
12430: where
12431: prg.STRUCT_TYPE = 'PRG' and
12432: prg.SUP_LEVEL = l_level and

Line 12613: from DUAL

12609: (
12610: select 1 WBS_SUP_LEVEL,
12611: 1 WBS_SUB_LEVEL,
12612: 'PRJ' INVERT_ID
12613: from DUAL
12614: union all
12615: select 1 WBS_SUP_LEVEL,
12616: 1 WBS_SUB_LEVEL,
12617: 'WBS' INVERT_ID

Line 12618: from DUAL

12614: union all
12615: select 1 WBS_SUP_LEVEL,
12616: 1 WBS_SUB_LEVEL,
12617: 'WBS' INVERT_ID
12618: from DUAL
12619: ) top_slice
12620: where
12621: prg.STRUCT_TYPE = 'PRG' and
12622: prg.SUP_LEVEL = l_level and

Line 13054: from DUAL

13050: (
13051: select 1 WBS_SUP_LEVEL,
13052: 1 WBS_SUB_LEVEL,
13053: 'PRJ' INVERT_ID
13054: from DUAL
13055: union all
13056: select 1 WBS_SUP_LEVEL,
13057: 1 WBS_SUB_LEVEL,
13058: 'WBS' INVERT_ID

Line 13059: from DUAL

13055: union all
13056: select 1 WBS_SUP_LEVEL,
13057: 1 WBS_SUB_LEVEL,
13058: 'WBS' INVERT_ID
13059: from DUAL
13060: ) top_slice
13061: where
13062: prg.STRUCT_TYPE = 'PRG' and
13063: prg.SUP_LEVEL = l_level and

Line 13245: from DUAL

13241: (
13242: select 1 WBS_SUP_LEVEL,
13243: 1 WBS_SUB_LEVEL,
13244: 'PRJ' INVERT_ID
13245: from DUAL
13246: union all
13247: select 1 WBS_SUP_LEVEL,
13248: 1 WBS_SUB_LEVEL,
13249: 'WBS' INVERT_ID

Line 13250: from DUAL

13246: union all
13247: select 1 WBS_SUP_LEVEL,
13248: 1 WBS_SUB_LEVEL,
13249: 'WBS' INVERT_ID
13250: from DUAL
13251: ) top_slice
13252: where
13253: prg.STRUCT_TYPE = 'PRG' and
13254: prg.SUP_LEVEL = l_level and

Line 14017: from DUAL union all

14013: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14014: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14015: (
14016: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14017: from DUAL union all
14018: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
14019: from DUAL union all
14020: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14021: from DUAL union all

Line 14019: from DUAL union all

14015: (
14016: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14017: from DUAL union all
14018: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
14019: from DUAL union all
14020: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14021: from DUAL union all
14022: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
14023: from DUAL

Line 14021: from DUAL union all

14017: from DUAL union all
14018: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
14019: from DUAL union all
14020: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14021: from DUAL union all
14022: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
14023: from DUAL
14024: ) fin_plan
14025: where

Line 14023: from DUAL

14019: from DUAL union all
14020: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14021: from DUAL union all
14022: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
14023: from DUAL
14024: ) fin_plan
14025: where
14026: prg.WORKER_ID = p_worker_id and
14027: prg.STRUCT_TYPE = 'PRG' and

Line 14418: from DUAL union all

14414: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
14415: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
14416: (
14417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14418: from DUAL union all
14419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
14420: from DUAL union all
14421: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14422: from DUAL union all

Line 14420: from DUAL union all

14416: (
14417: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
14418: from DUAL union all
14419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
14420: from DUAL union all
14421: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14422: from DUAL union all
14423: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
14424: from DUAL

Line 14422: from DUAL union all

14418: from DUAL union all
14419: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
14420: from DUAL union all
14421: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14422: from DUAL union all
14423: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
14424: from DUAL
14425: ) fin_plan
14426: where

Line 14424: from DUAL

14420: from DUAL union all
14421: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
14422: from DUAL union all
14423: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
14424: from DUAL
14425: ) fin_plan
14426: where
14427: prg.STRUCT_TYPE = 'PRG' and
14428: prg.SUP_LEVEL = l_level and

Line 14515: from DUAL

14511: PA_XBS_DENORM wbs,
14512: (
14513: select 1 WBS_SUP_LEVEL,
14514: 'PRJ' INVERT_ID
14515: from DUAL
14516: union all
14517: select 1 WBS_SUP_LEVEL,
14518: 'WBS' INVERT_ID
14519: from DUAL

Line 14519: from DUAL

14515: from DUAL
14516: union all
14517: select 1 WBS_SUP_LEVEL,
14518: 'WBS' INVERT_ID
14519: from DUAL
14520: ) top_slice
14521: where
14522: map.WORKER_ID = p_worker_id and
14523: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 15064: from DUAL

15060: PA_XBS_DENORM wbs,
15061: (
15062: select 1 WBS_SUP_LEVEL,
15063: 'PRJ' INVERT_ID
15064: from DUAL
15065: union all
15066: select 1 WBS_SUP_LEVEL,
15067: 'WBS' INVERT_ID
15068: from DUAL

Line 15068: from DUAL

15064: from DUAL
15065: union all
15066: select 1 WBS_SUP_LEVEL,
15067: 'WBS' INVERT_ID
15068: from DUAL
15069: ) top_slice
15070: where
15071: map.WORKER_ID = p_worker_id and
15072: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 16371: select 1 INVERT_ID from DUAL union all

16367: 2, log.ATTRIBUTE1) PRG_GROUP
16368: from
16369: PJI_PA_PROJ_EVENTS_LOG log,
16370: (
16371: select 1 INVERT_ID from DUAL union all
16372: select 2 INVERT_ID from DUAL
16373: ) invert
16374: where
16375: log.WORKER_ID = p_worker_id and

Line 16372: select 2 INVERT_ID from DUAL

16368: from
16369: PJI_PA_PROJ_EVENTS_LOG log,
16370: (
16371: select 1 INVERT_ID from DUAL union all
16372: select 2 INVERT_ID from DUAL
16373: ) invert
16374: where
16375: log.WORKER_ID = p_worker_id and
16376: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 16391: select 1 INVERT_ID from DUAL union all

16387: 1, log.EVENT_OBJECT,
16388: 2, log.ATTRIBUTE2)) struct_version_id
16389: from PJI_PA_PROJ_EVENTS_LOG log,
16390: (
16391: select 1 INVERT_ID from DUAL union all
16392: select 2 INVERT_ID from DUAL
16393: ) invert
16394: where
16395: log.WORKER_ID = p_worker_id and

Line 16392: select 2 INVERT_ID from DUAL

16388: 2, log.ATTRIBUTE2)) struct_version_id
16389: from PJI_PA_PROJ_EVENTS_LOG log,
16390: (
16391: select 1 INVERT_ID from DUAL union all
16392: select 2 INVERT_ID from DUAL
16393: ) invert
16394: where
16395: log.WORKER_ID = p_worker_id and
16396: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH'));

Line 16419: select 1 INVERT_ID from DUAL union all

16415: 2, log.ATTRIBUTE1) PRG_GROUP
16416: from
16417: PJI_PA_PROJ_EVENTS_LOG log,
16418: (
16419: select 1 INVERT_ID from DUAL union all
16420: select 2 INVERT_ID from DUAL
16421: ) invert
16422: where
16423: log.WORKER_ID = p_worker_id and

Line 16420: select 2 INVERT_ID from DUAL

16416: from
16417: PJI_PA_PROJ_EVENTS_LOG log,
16418: (
16419: select 1 INVERT_ID from DUAL union all
16420: select 2 INVERT_ID from DUAL
16421: ) invert
16422: where
16423: log.WORKER_ID = p_worker_id and
16424: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 16447: select 1 INVERT_ID from DUAL union all

16443: 2, log.ATTRIBUTE2)
16444: from
16445: PJI_PA_PROJ_EVENTS_LOG log,
16446: (
16447: select 1 INVERT_ID from DUAL union all
16448: select 2 INVERT_ID from DUAL
16449: ) invert
16450: where
16451: log.WORKER_ID = p_worker_id and

Line 16448: select 2 INVERT_ID from DUAL

16444: from
16445: PJI_PA_PROJ_EVENTS_LOG log,
16446: (
16447: select 1 INVERT_ID from DUAL union all
16448: select 2 INVERT_ID from DUAL
16449: ) invert
16450: where
16451: log.WORKER_ID = p_worker_id and
16452: log.EVENT_TYPE in ('WBS_CHANGE',

Line 16517: select 1 INVERT_ID from DUAL union all

16513: 2, log.ATTRIBUTE1) PRG_GROUP
16514: from
16515: PJI_PA_PROJ_EVENTS_LOG log,
16516: (
16517: select 1 INVERT_ID from DUAL union all
16518: select 2 INVERT_ID from DUAL
16519: ) invert
16520: where
16521: log.WORKER_ID = p_worker_id and

Line 16518: select 2 INVERT_ID from DUAL

16514: from
16515: PJI_PA_PROJ_EVENTS_LOG log,
16516: (
16517: select 1 INVERT_ID from DUAL union all
16518: select 2 INVERT_ID from DUAL
16519: ) invert
16520: where
16521: log.WORKER_ID = p_worker_id and
16522: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 16949: select 1 INVERT_ID from DUAL union all

16945: 'RBS_DELETE', log.EVENT_OBJECT)
16946: from
16947: PJI_PA_PROJ_EVENTS_LOG log,
16948: (
16949: select 1 INVERT_ID from DUAL union all
16950: select 2 INVERT_ID from DUAL
16951: ) invert
16952: where
16953: log.WORKER_ID = p_worker_id and

Line 16950: select 2 INVERT_ID from DUAL

16946: from
16947: PJI_PA_PROJ_EVENTS_LOG log,
16948: (
16949: select 1 INVERT_ID from DUAL union all
16950: select 2 INVERT_ID from DUAL
16951: ) invert
16952: where
16953: log.WORKER_ID = p_worker_id and
16954: log.EVENT_TYPE in ('RBS_PUSH',

Line 17184: FROM DUAL;

17180:
17181: -- Incr-Incr, Full-Initial, rbs-full, pr-full.
17182: SELECT DECODE(l_extraction_type, 'INCREMENTAL', 'INCREMENTAL', 'FULL', 'INITIAL', 'FULL')
17183: INTO l_extraction_type_wp
17184: FROM DUAL;
17185:
17186: LOOP
17187:
17188: l_project_id_tbl := system.pa_num_tbl_type();

Line 17432: -- FROM DUAL ;

17428: WHERE worker_id = p_worker_id );
17429:
17430: -- SELECT DECODE(l_extraction_type, 'PARTIAL', 'PLANTYPE', l_extraction_type)
17431: -- INTO l_extraction_type
17432: -- FROM DUAL ;
17433:
17434: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (
17435: p_context => l_extraction_type
17436: , p_lock_mode => NULL