APPS.PJI_PJP_SUM_MAIN dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 985: from PA_PJI_PROJ_EVENTS_LOG elog,

981: BEGIN
982: -- pji_utils.write2log('In Procedure plan type code changes');
983:
984: select count(bmap.project_id) into l_count
985: from PA_PJI_PROJ_EVENTS_LOG elog,
986: PJI_PJP_PROJ_BATCH_MAP bmap
987: where elog.event_object = to_char(bmap.project_id)
988: and elog.event_type = 'PLANTYPE_UPG'
989: and bmap.worker_id = p_worker_id;

Line 1074: PA_PJI_PROJ_EVENTS_LOG elog,

1070: FROM
1071: pa_budget_versions bv
1072: , pa_proj_fp_options fpo
1073: , (select distinct bmap.project_id,elog.ATTRIBUTE1 plan_type_id from
1074: PA_PJI_PROJ_EVENTS_LOG elog,
1075: PJI_PJP_PROJ_BATCH_MAP bmap
1076: where elog.event_object = to_char(bmap.project_id)
1077: and elog.EVENT_TYPE = 'PLANTYPE_UPG'
1078: and bmap.worker_id = p_worker_id) logmap

Line 2706: DELETE pa_pji_proj_events_log log

2702: );
2703:
2704: -- pji_utils.write2log('Inserted records into fact'||sql%rowcount);
2705:
2706: DELETE pa_pji_proj_events_log log
2707: where log.event_type = 'PLANTYPE_UPG'
2708: and exists (select 1 from pji_fm_extr_plnver4 ver
2709: where ver.worker_id = p_worker_id and
2710: to_char(ver.project_id) = log.event_object);

Line 2713: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);

2709: where ver.worker_id = p_worker_id and
2710: to_char(ver.project_id) = log.event_object);
2711:
2712:
2713: --pji_utils.write2log('Deleted records from pa_pji_proj_events_log'||sql%rowcount);
2714:
2715: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2716:
2717: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);

Line 2728: from PA_PJI_PROJ_EVENTS_LOG elog

2724:
2725: Begin
2726: select 1 into l_count from dual
2727: where exists ( select event_type
2728: from PA_PJI_PROJ_EVENTS_LOG elog
2729: where elog.event_type = 'PLANTYPE_UPG');
2730: exception when NO_DATA_FOUND then
2731: PJI_UTILS.SET_PARAMETER ('PJI_PTC_UPGRADE', 'C');
2732: end;

Line 3458: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)

3454: PRJ_CURRENCY_CODE,
3455: PROJECT_ACTIVE_FLAG
3456: )
3457: select /*+ ordered
3458: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)
3459: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */
3460: distinct
3461: p_worker_id,
3462: rbs_asg.PROJECT_ID,

Line 3478: PA_PJI_PROJ_EVENTS_LOG log,

3474: 'Y' PROJECT_ACTIVE_FLAG
3475: /* decode(active_projects.PROJECT_ID,
3476: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3477: from
3478: PA_PJI_PROJ_EVENTS_LOG log,
3479: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
3480: PA_PROJECTS_ALL prj,
3481: PA_PROJECT_TYPES_ALL pt /*,
3482: ( Processing is now not depending on status Bug 5057835

Line 3533: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)

3529: PRJ_CURRENCY_CODE,
3530: PROJECT_ACTIVE_FLAG
3531: )
3532: select /*+ ordered
3533: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)
3534: index(rbs_asg, PA_RBS_PRJ_ASSIGNMENTS_N1) */
3535: distinct
3536: p_worker_id,
3537: prj.PROJECT_ID,

Line 3553: PA_PJI_PROJ_EVENTS_LOG log,

3549: 'Y' PROJECT_ACTIVE_FLAG
3550: /* decode(active_projects.PROJECT_ID,
3551: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3552: from
3553: PA_PJI_PROJ_EVENTS_LOG log,
3554: PA_PROJECTS_ALL prj,
3555: PA_PROJECT_TYPES_ALL pt
3556: where
3557: log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE') and

Line 3715: from PA_PJI_PROJ_EVENTS_LOG log

3711: (l_extraction_type = 'PARTIAL' and
3712: EXTRACTION_STATUS <> 'I'));
3713:
3714: delete
3715: from PA_PJI_PROJ_EVENTS_LOG log
3716: where log.EVENT_TYPE in ('WBS_CHANGE',
3717: 'WBS_PUBLISH',
3718: 'RBS_ASSOC',
3719: 'RBS_PRG' --Uncommented for bug 13800894