APPS.PJI_PJP_SUM_MAIN dependencies on PJI_PJP_PROJ_EXTR_STATUS

Line 3086: PJI_PJP_PROJ_EXTR_STATUS status,

3082: /* Processing is not depending on Project status Bug 5057835
3083: decode(active_projects.PROJECT_STATUS_CODE,
3084: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3085: from
3086: PJI_PJP_PROJ_EXTR_STATUS status,
3087: PA_PROJECTS_ALL prj /*,
3088: ( Processing is not depending on Project status Bug 5057835
3089: select
3090: distinct

Line 3141: PJI_PJP_PROJ_EXTR_STATUS status,

3137: status.PROJECT_TYPE_CLASS,
3138: prj.PROJECT_CURRENCY_CODE,
3139: decode(active_projects.PROJECT_ID, null, 'N', 'Y') PROJECT_ACTIVE_FLAG
3140: from
3141: PJI_PJP_PROJ_EXTR_STATUS status,
3142: PA_PROJECTS_ALL prj,
3143: (
3144: select /*+ ordered
3145: index(prg, PA_XBS_DENORM_N3)

Line 3260: PJI_PJP_PROJ_EXTR_STATUS status,

3256: prg2.SUB_LEVEL = prg2.SUP_LEVEL and
3257: prg2.PRG_GROUP = prg1.PRG_GROUP
3258: ) map,
3259: PJI_PJP_PROJ_BATCH_MAP existing_projects,
3260: PJI_PJP_PROJ_EXTR_STATUS status,
3261: PA_PROJECTS_ALL prj
3262: where
3263: p_worker_id = existing_projects.WORKER_ID (+) and
3264: map.PROJECT_ID = existing_projects.PROJECT_ID (+) and

Line 3379: FROM pji_pjp_proj_extr_status extr,

3375: SELECT 'FULL' INTO l_extraction_type FROM DUAL
3376: WHERE EXISTS
3377: (
3378: SELECT 1
3379: FROM pji_pjp_proj_extr_status extr,
3380: PJI_PJP_PROJ_BATCH_MAP map
3381: WHERE map.project_id=extr.project_id
3382: AND extr.extraction_status='F'
3383: AND WORKER_ID = p_worker_id

Line 3525: PJI_PJP_PROJ_EXTR_STATUS stat

3521: 'RBS_PRG'*/ --Commented for bug#6113807 by VVJOSHI
3522: ) and
3523: log.ATTRIBUTE1 in (select stat.PROJECT_ID
3524: from PJI_PJP_PROJ_BATCH_MAP map,
3525: PJI_PJP_PROJ_EXTR_STATUS stat
3526: where map.WORKER_ID = p_worker_id and
3527: stat.PROJECT_ID = map.PROJECT_ID and
3528: stat.EXTRACTION_STATUS = 'F');
3529:

Line 3532: update PJI_PJP_PROJ_EXTR_STATUS

3528: stat.EXTRACTION_STATUS = 'F');
3529:
3530: end if;
3531:
3532: update PJI_PJP_PROJ_EXTR_STATUS
3533: set EXTRACTION_STATUS = 'I',
3534: LAST_UPDATE_DATE = sysdate
3535: where l_extraction_type = 'FULL' and
3536: EXTRACTION_STATUS = 'F' and

Line 3978: update PJI_PJP_PROJ_EXTR_STATUS

3974: OUTPUT_ACT_FAILED_RUNS(p_worker_id);
3975: OUTPUT_ACT_PASSED_RUNS(p_worker_id);
3976: end if;
3977:
3978: update PJI_PJP_PROJ_EXTR_STATUS
3979: set LAST_UPDATE_DATE = sysdate
3980: where PROJECT_ID in (select map.PROJECT_ID
3981: from PJI_PJP_PROJ_BATCH_MAP map
3982: where map.WORKER_ID = p_worker_id);