[Home] [Help]
1369: AND hd9.wp_flag = 'N'
1370: AND hd9.cb_flag || hd9.co_flag LIKE '%Y%'
1371: AND hd9.project_id = map.project_id
1372: AND not exists(select null
1373: from pji_fp_xbs_accum_f fact
1374: where fact.project_id = hd9.project_id
1375: and fact.plan_version_id = hd9.plan_version_id
1376: and fact.plan_type_id = hd9.plan_type_id
1377: and fact.rbs_version_id = ev.event_object)
1407: AND TO_NUMBER(ev.attribute1) = map.project_id
1408: AND hd1.project_id = map.project_id
1409: AND hd9.plan_type_id = hd1.plan_type_id
1410: AND not exists(select null
1411: from pji_fp_xbs_accum_f fact
1412: where fact.project_id = hd9.project_id
1413: and fact.plan_version_id = hd9.plan_version_id
1414: and fact.plan_type_id = hd9.plan_type_id
1415: and fact.rbs_version_id = ev.event_object)
4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4362:
4363: -- gather statistics for PJI metadata tables
4364: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4365: tabname => 'PJI_FP_XBS_ACCUM_F',
4366: percent => 5,
4367: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4368:
4369:
4368:
4369:
4370: Forall i in x_row_id.first..x_row_id.last
4371: */
4372: INSERT /*+ append parallel(rl) */ INTO pji_fp_xbs_accum_f rl
4373: (
4374: PROJECT_ID
4375: , PROJECT_ORG_ID
4376: , PROJECT_ORGANIZATION_ID
4737: , rl.CUSTOM15
4738: , g_default_prg_level
4739: , rl.PLAN_TYPE_CODE
4740: FROM
4741: pji_fp_xbs_accum_f rl
4742: , pa_budget_versions bv -- @pjdev115 bv
4743: , pa_proj_fp_options fpo -- @pjdev115 fpo
4744: WHERE
4745: rl.project_id = bv.project_id
5418: worker_id
5419: , rl_rowid
5420: , tmp_rowid
5421: )
5422: SELECT /*+ ORDERED full(tmp) index(rl,PJI_FP_XBS_ACCUM_F_N1) */
5423: g_worker_id WORKER_ID
5424: , rl.ROWID rl_rowid
5425: , tmp.ROWID TMP_ROWID
5426: FROM
5424: , rl.ROWID rl_rowid
5425: , tmp.ROWID TMP_ROWID
5426: FROM
5427: pji_fp_aggr_pjp1 tmp
5428: , pji_fp_xbs_accum_f rl
5429: WHERE 1 = 1
5430: -- Removed outer join for bug 5927368
5431: -- AND tmp.WORKER_ID = g_worker_id
5432: -- AND tmp.PROJECT_ID = rl.PROJECT_ID (+)
5490:
5491:
5492:
5493: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
5494: pji_fp_xbs_accum_f rl
5495: SET (
5496: rl.RAW_COST
5497: , rl.BRDN_COST
5498: , rl.REVENUE
5732: nvl(RECORD_TYPE, 'X') <> 'U';
5733: commit;
5734: --End of addition for bug 5927368
5735:
5736: INSERT INTO pji_fp_xbs_accum_f fact
5737: (
5738: PROJECT_ID
5739: , PROJECT_ORG_ID
5740: , PROJECT_ORGANIZATION_ID
6747: , CUSTOM14
6748: , CUSTOM15
6749: , g_default_prg_level
6750: ,PLAN_TYPE_CODE
6751: FROM pji_fp_xbs_accum_f
6752: WHERE plan_version_id = p_pln_ver_id
6753: );
6754:
6755: EXCEPTION
10070: ,TO_DATE(NULL) END_DATE
10071: ,g_default_prg_level PRG_LEVEL
10072: , fact.plan_type_code plan_type_code
10073: FROM
10074: pji_fp_xbs_accum_f fact,
10075: pji_fm_extr_plnver4 ver
10076: WHERE fact.plan_version_id=ver.plan_version_id
10077: AND fact.plan_type_code = ver.plan_type_code /*4471527 */
10078: AND fact.project_id = ver.project_id
11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11242:
11243: -- gather statistics for PJI metadata tables
11244: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11245: tabname => 'PJI_FP_XBS_ACCUM_F',
11246: percent => 5,
11247: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11248:
11249:
11247: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11248:
11249:
11250: Forall i in x_row_id.first..x_row_id.last
11251: MERGE INTO PJI_FP_XBS_ACCUM_F fact
11252: USING ( SELECT
11253: tmp.worker_id
11254: , tmp.PROJECT_ID
11255: , tmp.PROJECT_ORG_ID