APPS.PJI_PJP_SUM_MAIN dependencies on PJI_PJP_PROJ_EXTR_STATUS

Line 3175: PJI_PJP_PROJ_EXTR_STATUS status,

3171: /* Processing is not depending on Project status Bug 5057835
3172: decode(active_projects.PROJECT_STATUS_CODE,
3173: null, 'N', 'Y') PROJECT_ACTIVE_FLAG */
3174: from
3175: PJI_PJP_PROJ_EXTR_STATUS status,
3176: PA_PROJECTS_ALL prj,
3177: PA_PROJECT_STATUSES proj_status /*,
3178: ( Processing is not depending on Project status Bug 5057835
3179: select

Line 3239: PJI_PJP_PROJ_EXTR_STATUS status,

3235: status.PROJECT_TYPE_CLASS,
3236: prj.PROJECT_CURRENCY_CODE,
3237: 'Y' PROJECT_ACTIVE_FLAG
3238: from
3239: PJI_PJP_PROJ_EXTR_STATUS status,
3240: PA_PROJECTS_ALL prj ,
3241: PJI_PRG_GROUP prg1
3242: where
3243: status.PROJECT_ID = prj.PROJECT_ID and

Line 3281: PJI_PJP_PROJ_EXTR_STATUS status,

3277: status.PROJECT_TYPE_CLASS,
3278: prj.PROJECT_CURRENCY_CODE,
3279: decode(active_projects.PROJECT_ID, null, 'N', 'Y') PROJECT_ACTIVE_FLAG
3280: from
3281: PJI_PJP_PROJ_EXTR_STATUS status,
3282: PA_PROJECTS_ALL prj,
3283: (
3284: select /*+ ordered
3285: index(prg, PA_XBS_DENORM_N3)

Line 3403: PJI_PJP_PROJ_EXTR_STATUS status,

3399: prg2.SUB_LEVEL = prg2.SUP_LEVEL and
3400: prg2.PRG_GROUP = prg1.PRG_GROUP
3401: ) map,
3402: PJI_PJP_PROJ_BATCH_MAP existing_projects,
3403: PJI_PJP_PROJ_EXTR_STATUS status,
3404: PA_PROJECTS_ALL prj
3405: where
3406: p_worker_id = existing_projects.WORKER_ID (+) and
3407: map.PROJECT_ID = existing_projects.PROJECT_ID (+) and

Line 3575: FROM pji_pjp_proj_extr_status extr,

3571: SELECT 'FULL' INTO l_extraction_type FROM DUAL
3572: WHERE EXISTS
3573: (
3574: SELECT 1
3575: FROM pji_pjp_proj_extr_status extr,
3576: PJI_PJP_PROJ_BATCH_MAP map
3577: WHERE map.project_id=extr.project_id
3578: AND extr.extraction_status='F'
3579: AND WORKER_ID = p_worker_id

Line 3723: PJI_PJP_PROJ_EXTR_STATUS stat

3719: 'RBS_PRG' --Uncommented for bug 13800894
3720: ) and
3721: log.ATTRIBUTE1 in (select stat.PROJECT_ID
3722: from PJI_PJP_PROJ_BATCH_MAP map,
3723: PJI_PJP_PROJ_EXTR_STATUS stat
3724: where map.WORKER_ID = p_worker_id and
3725: stat.PROJECT_ID = map.PROJECT_ID and
3726: stat.EXTRACTION_STATUS = 'F');
3727:

Line 3730: update PJI_PJP_PROJ_EXTR_STATUS

3726: stat.EXTRACTION_STATUS = 'F');
3727:
3728: end if;
3729:
3730: update PJI_PJP_PROJ_EXTR_STATUS
3731: set EXTRACTION_STATUS = 'I',
3732: LAST_UPDATE_DATE = sysdate
3733: where l_extraction_type = 'FULL' and
3734: EXTRACTION_STATUS = 'F' and

Line 4216: update PJI_PJP_PROJ_EXTR_STATUS

4212: OUTPUT_ACT_FAILED_RUNS(p_worker_id);
4213: OUTPUT_ACT_PASSED_RUNS(p_worker_id);
4214: end if;
4215:
4216: update PJI_PJP_PROJ_EXTR_STATUS
4217: set LAST_UPDATE_DATE = sysdate
4218: where PROJECT_ID in (select map.PROJECT_ID
4219: from PJI_PJP_PROJ_BATCH_MAP map
4220: where map.WORKER_ID = p_worker_id);