APPS.PJI_LAUNCH_UPP_MAIN dependencies on PJI_SYSTEM_PARAMETERS

Line 287: delete from pji_system_parameters

283: BEGIN
284:
285: -- Bug 14138486
286: -- Need to delete since there may be a previous LUPPD request which may have completed in error.
287: delete from pji_system_parameters
288: where name = 'PJI_STAGE3_REQ_LUPPD';
289: commit;
290:
291: IF p_submit_uppd_during_lppd = 'N' THEN

Line 308: delete from pji_system_parameters

304: AND a.phase_code in ('R','P','I')
305: AND rownum = 1;
306:
307: IF l_req_count = 1 THEN
308: delete from pji_system_parameters
309: where name = 'PJI_STAGE3_REQ_LUPPD';
310: commit;
311:
312: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');

Line 439: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,

435: -- bug 6276970 & 6505683
436: -- Sridhar Added below insert and update statement
437:
438: update pji_prg_group c set c.batch_name = ( select d1.value
439: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,
440: pji_prg_group b1
441: where a1.project_id = b1.project_id
442: and c.batch_name like '%-ERR'
443: and b1.prg_group = c.prg_group

Line 453: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,

449: where
450: c.batch_name like '%-ERR'
451: and exists
452: ( select 'x'
453: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,
454: pji_prg_group b2
455: where a2.project_id = b2.project_id
456: and b2.prg_group = c.prg_group
457: and to_number(substr(d2.name,8,instr(d2.name,'$',1) - 8)) = a2.worker_id -- Sridhar changed added substr june-11th V1_CHANGE

Line 465: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,

461:
462: -- Sridhar changed june-11th Added new Update Statement START V1_CHANGE
463:
464: update pji_prg_group c set c.batch_name = ( select d1.value
465: from pji_system_parameters d1 , pji_pjp_proj_batch_map a1,
466: pji_prg_group b1
467: where a1.project_id = b1.project_id
468: and c.batch_name like '%-ERR'
469: and b1.project_id = c.project_id

Line 479: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,

475: where
476: c.batch_name like '%-ERR'
477: and exists
478: ( select 'x'
479: from pji_system_parameters d2 , pji_pjp_proj_batch_map a2,
480: pji_prg_group b2
481: where a2.project_id = b2.project_id
482: and b2.project_id = c.project_id
483: and to_number(substr(d2.name,8,instr(d2.name,'$',1) - 8)) = a2.worker_id

Line 503: from pji_system_parameters a , pji_system_parameters b

499: UPDATE pji_prg_batch c
500: SET c.curr_request_id =
501: (
502: select b.value
503: from pji_system_parameters a , pji_system_parameters b
504: where a.name like 'PJI_PJP%FROM_PROJECT'
505: and to_number(substr(a.name,8,instr(a.name,'$',1) - 8)) = to_number(substr(b.name,8,instr(b.name,'$',1) - 8))
506: and b.name like 'PJI_PJP%PJI_PJP%'
507: and c.batch_name = a.value

Line 512: from pji_system_parameters a , pji_system_parameters b

508: and b.value is not null
509: )
510: WHERE exists
511: ( select b.value
512: from pji_system_parameters a , pji_system_parameters b
513: where a.name like 'PJI_PJP%FROM_PROJECT'
514: and to_number(substr(a.name,8,instr(a.name,'$',1) - 8)) = to_number(substr(b.name,8,instr(b.name,'$',1) - 8))
515: and b.name like 'PJI_PJP%PJI_PJP%'
516: and c.batch_name = a.value

Line 868: delete from pji_system_parameters

864: l_count_pending
865: );
866:
867: -- Bug 14138486
868: delete from pji_system_parameters
869: where name = 'PJI_STAGE3_REQ_LUPPD';
870: commit;
871: -- End Bug 14138486
872: