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_MAIN dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 800: from pji_pjp_proj_batch_map map,pa_projects_all pa

796: l_rpt_excep_reason varchar2(30);
797: l_rpt_footer varchar2(60);
798: cursor c_err_report is
799: select pa.segment1,map.act_err_msg
800: from pji_pjp_proj_batch_map map,pa_projects_all pa
801: where pa.project_id=map.project_id
802: and map.worker_id=p_worker_id
803: and map.act_err_msg is not null
804: order by segment1;

Line 874: from pji_pjp_proj_batch_map map,pa_projects_all pa

870: l_rpt_footer varchar2(60);
871:
872: cursor c_err_report is
873: select pa.segment1,pa.name
874: from pji_pjp_proj_batch_map map,pa_projects_all pa
875: where pa.project_id=map.project_id
876: and map.worker_id=p_worker_id
877: and map.act_err_msg is null
878: order by segment1;

Line 963: PJI_PJP_PROJ_BATCH_MAP bmap

959: -- pji_utils.write2log('In Procedure plan type code changes');
960:
961: select count(bmap.project_id) into l_count
962: from PA_PJI_PROJ_EVENTS_LOG elog,
963: PJI_PJP_PROJ_BATCH_MAP bmap
964: where elog.event_object = to_char(bmap.project_id)
965: and elog.event_type = 'PLANTYPE_UPG'
966: and bmap.worker_id = p_worker_id;
967:

Line 1052: PJI_PJP_PROJ_BATCH_MAP bmap

1048: pa_budget_versions bv
1049: , pa_proj_fp_options fpo
1050: , (select distinct bmap.project_id,elog.ATTRIBUTE1 plan_type_id from
1051: PA_PJI_PROJ_EVENTS_LOG elog,
1052: PJI_PJP_PROJ_BATCH_MAP bmap
1053: where elog.event_object = to_char(bmap.project_id)
1054: and elog.EVENT_TYPE = 'PLANTYPE_UPG'
1055: and bmap.worker_id = p_worker_id) logmap
1056: WHERE 1=1

Line 2745: PJI_PJP_PROJ_BATCH_MAP map,

2741: cursor lock_headers (p_worker_id in number) is
2742: select
2743: wbs_hdr.ROWID HDR_ROWID
2744: from
2745: PJI_PJP_PROJ_BATCH_MAP map,
2746: PJI_PJP_WBS_HEADER wbs_hdr
2747: where
2748: map.WORKER_ID = p_worker_id and
2749: wbs_hdr.PROJECT_ID = map.PROJECT_ID and

Line 2835: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;

2831: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NOT_ENABLED');
2832: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2833: end if;
2834:
2835: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
2836:
2837: if (p_run_mode = 'F') then
2838: l_extraction_type := 'FULL';
2839: elsif (p_run_mode = 'I' or

Line 3056: insert into PJI_PJP_PROJ_BATCH_MAP

3052: end;
3053:
3054: if (l_prg_exists = 'N') then
3055: */
3056: insert into PJI_PJP_PROJ_BATCH_MAP
3057: (
3058: WORKER_ID,
3059: PROJECT_ID,
3060: PJI_PROJECT_STATUS,

Line 3114: insert into PJI_PJP_PROJ_BATCH_MAP

3110:
3111: /* Not required changed the logic of l_prg_exist Bug 5057835
3112: elsif (l_prg_exists = 'Y') then
3113:
3114: insert into PJI_PJP_PROJ_BATCH_MAP
3115: (
3116: WORKER_ID,
3117: PROJECT_ID,
3118: PJI_PROJECT_STATUS,

Line 3182: PJI_PJP_PROJ_BATCH_MAP map,

3178: 'Y'
3179: into
3180: l_prg_exists
3181: from
3182: PJI_PJP_PROJ_BATCH_MAP map,
3183: PA_PROJ_ELEMENT_VERSIONS proj
3184: where
3185: map.WORKER_ID = p_worker_id and
3186: map.PROJECT_ID = proj.PROJECT_ID and

Line 3199: insert into PJI_PJP_PROJ_BATCH_MAP

3195: end;
3196:
3197: if (l_prg_exists = 'Y') then
3198:
3199: insert into PJI_PJP_PROJ_BATCH_MAP
3200: (
3201: WORKER_ID,
3202: PROJECT_ID,
3203: PJI_PROJECT_STATUS,

Line 3231: PJI_PJP_PROJ_BATCH_MAP map,

3227: select /*+ ordered */
3228: distinct
3229: ver2.PROJECT_ID
3230: from
3231: PJI_PJP_PROJ_BATCH_MAP map,
3232: PA_PROJ_ELEMENT_VERSIONS ver1,
3233: PA_PROJ_ELEMENT_VERSIONS ver2
3234: where
3235: map.WORKER_ID = p_worker_id and

Line 3247: PJI_PJP_PROJ_BATCH_MAP map,

3243: index(prg2 PJI_XBS_DENORM_N3) */
3244: distinct
3245: prg2.SUP_PROJECT_ID PROJECT_ID
3246: from
3247: PJI_PJP_PROJ_BATCH_MAP map,
3248: PJI_XBS_DENORM prg1,
3249: PJI_XBS_DENORM prg2
3250: where
3251: map.WORKER_ID = p_worker_id and

Line 3259: PJI_PJP_PROJ_BATCH_MAP existing_projects,

3255: prg2.STRUCT_TYPE = 'PRG' and
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

Line 3278: PJI_PJP_PROJ_BATCH_MAP new_worker

3274: count(*)
3275: into
3276: l_count
3277: from
3278: PJI_PJP_PROJ_BATCH_MAP new_worker
3279: where
3280: new_worker.WORKER_ID = p_worker_id;
3281:
3282: if (l_count = 0) then

Line 3299: insert into PJI_PJP_PROJ_BATCH_MAP

3295: end if;
3296:
3297: elsif (l_extraction_type = 'RBS') then
3298:
3299: insert into PJI_PJP_PROJ_BATCH_MAP
3300: (
3301: WORKER_ID,
3302: PROJECT_ID,
3303: PJI_PROJECT_STATUS,

Line 3380: PJI_PJP_PROJ_BATCH_MAP map

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
3384: );

Line 3424: from PJI_PJP_PROJ_BATCH_MAP existing_workers

3420: for c in
3421: (
3422: select distinct
3423: existing_workers.WORKER_ID
3424: from PJI_PJP_PROJ_BATCH_MAP existing_workers
3425: where existing_workers.WORKER_ID <> p_worker_id and
3426: exists (select 1
3427: from PJI_PJP_PROJ_BATCH_MAP new_worker
3428: where new_worker.WORKER_ID = p_worker_id and

Line 3427: from PJI_PJP_PROJ_BATCH_MAP new_worker

3423: existing_workers.WORKER_ID
3424: from PJI_PJP_PROJ_BATCH_MAP existing_workers
3425: where existing_workers.WORKER_ID <> p_worker_id and
3426: exists (select 1
3427: from PJI_PJP_PROJ_BATCH_MAP new_worker
3428: where new_worker.WORKER_ID = p_worker_id and
3429: new_worker.PROJECT_ID = existing_workers.PROJECT_ID)
3430: ) loop
3431:

Line 3451: rollback; -- unlock PJI_PJP_PROJ_BATCH_MAP

3447: end loop;
3448:
3449: if (l_count > 0) then
3450:
3451: rollback; -- unlock PJI_PJP_PROJ_BATCH_MAP
3452:
3453: for i in 1..l_count loop
3454: if request_id_table(i) <> -1 then
3455: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);

Line 3507: from PJI_PJP_PROJ_BATCH_MAP

3503: l_extraction_type = 'INCREMENTAL' or
3504: l_extraction_type = 'PARTIAL') then
3505:
3506: delete
3507: from PJI_PJP_PROJ_BATCH_MAP
3508: where WORKER_ID = p_worker_id and
3509: ((l_extraction_type = 'FULL' and
3510: EXTRACTION_STATUS <> 'F') or
3511: (l_extraction_type = 'INCREMENTAL' and

Line 3524: from PJI_PJP_PROJ_BATCH_MAP map,

3520: 'RBS_ASSOC',
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');

Line 3538: from PJI_PJP_PROJ_BATCH_MAP

3534: LAST_UPDATE_DATE = sysdate
3535: where l_extraction_type = 'FULL' and
3536: EXTRACTION_STATUS = 'F' and
3537: PROJECT_ID in (select PROJECT_ID
3538: from PJI_PJP_PROJ_BATCH_MAP
3539: where WORKER_ID = p_worker_id);
3540:
3541: for c in lock_headers(p_worker_id) loop
3542: update PJI_PJP_WBS_HEADER wbs_hdr

Line 3870: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;

3866: return;
3867: end if;
3868: -- Changes for bug 6266824
3869: /* Commented for bug 6266824
3870: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
3871: if p_worker_id = 1 then
3872: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
3873: elsif p_worker_id = 2 then
3874: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;

Line 3872: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;

3868: -- Changes for bug 6266824
3869: /* Commented for bug 6266824
3870: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
3871: if p_worker_id = 1 then
3872: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
3873: elsif p_worker_id = 2 then
3874: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
3875: elsif p_worker_id = 3 then
3876: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;

Line 3874: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;

3870: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
3871: if p_worker_id = 1 then
3872: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
3873: elsif p_worker_id = 2 then
3874: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
3875: elsif p_worker_id = 3 then
3876: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
3877: elsif p_worker_id = 4 then
3878: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;

Line 3876: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;

3872: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
3873: elsif p_worker_id = 2 then
3874: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
3875: elsif p_worker_id = 3 then
3876: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
3877: elsif p_worker_id = 4 then
3878: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
3879: elsif p_worker_id = 5 then
3880: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;

Line 3878: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;

3874: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
3875: elsif p_worker_id = 3 then
3876: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
3877: elsif p_worker_id = 4 then
3878: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
3879: elsif p_worker_id = 5 then
3880: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
3881: elsif p_worker_id = 6 then
3882: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;

Line 3880: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;

3876: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
3877: elsif p_worker_id = 4 then
3878: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
3879: elsif p_worker_id = 5 then
3880: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
3881: elsif p_worker_id = 6 then
3882: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
3883: elsif p_worker_id = 7 then
3884: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;

Line 3882: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;

3878: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
3879: elsif p_worker_id = 5 then
3880: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
3881: elsif p_worker_id = 6 then
3882: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
3883: elsif p_worker_id = 7 then
3884: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
3885: elsif p_worker_id = 8 then
3886: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;

Line 3884: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;

3880: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
3881: elsif p_worker_id = 6 then
3882: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
3883: elsif p_worker_id = 7 then
3884: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
3885: elsif p_worker_id = 8 then
3886: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
3887: elsif p_worker_id = 9 then
3888: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;

Line 3886: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;

3882: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
3883: elsif p_worker_id = 7 then
3884: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
3885: elsif p_worker_id = 8 then
3886: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
3887: elsif p_worker_id = 9 then
3888: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;
3889: elsif p_worker_id = 10 then
3890: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;

Line 3888: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;

3884: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
3885: elsif p_worker_id = 8 then
3886: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
3887: elsif p_worker_id = 9 then
3888: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;
3889: elsif p_worker_id = 10 then
3890: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;
3891: end if;
3892: */

Line 3890: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;

3886: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
3887: elsif p_worker_id = 9 then
3888: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;
3889: elsif p_worker_id = 10 then
3890: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;
3891: end if;
3892: */
3893: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3894:

Line 3981: from PJI_PJP_PROJ_BATCH_MAP map

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);
3983:
3984: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;
3985:

Line 3984: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;

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);
3983:
3984: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;
3985:
3986: -- mark current iteration as successful
3987:
3988: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);