APPS.PJI_PJP_SUM_MAIN dependencies on PJI_FP_AGGR_PJP1

Line 996: DELETE PJI_FP_AGGR_PJP1 where worker_id = p_worker_id;

992:
993: if l_count > 0 then
994:
995: DELETE PJI_FM_EXTR_PLNVER4 where worker_id = p_worker_id;
996: DELETE PJI_FP_AGGR_PJP1 where worker_id = p_worker_id;
997:
998: INSERT INTO PJI_FM_EXTR_PLNVER4
999: (
1000: WORKER_ID ,

Line 1177: INSERT INTO PJI_FP_AGGR_PJP1

1173: -- prg_rollup_flag = 'Y' lines if required
1174: -- Commit;
1175: -- pji_utils.write2log('Inserting all the positive plan version data into the PJP1 table for futher ');
1176:
1177: INSERT INTO PJI_FP_AGGR_PJP1
1178: (
1179: WORKER_ID
1180: , PROJECT_ID
1181: , PROJECT_ORG_ID

Line 1360: insert into PJI_FP_AGGR_PJP1

1356:
1357: -- pji_utils.write2log('In loop of rollup_fpr_wbs'||l_level);
1358: -- rollup project hiearchy
1359:
1360: insert into PJI_FP_AGGR_PJP1
1361: (
1362: WORKER_ID,
1363: RECORD_TYPE,
1364: PRG_LEVEL,

Line 2085: PJI_FP_AGGR_PJP1 pjp1,

2081: pjp1.CUSTOM13,
2082: pjp1.CUSTOM14,
2083: pjp1.CUSTOM15
2084: from
2085: PJI_FP_AGGR_PJP1 pjp1,
2086: PJI_PJP_WBS_HEADER wbs_hdr,
2087: PA_XBS_DENORM wbs,
2088: PJI_XBS_DENORM prg,
2089: (

Line 2239: PJI_FP_AGGR_PJP1 pjp1,

2235: pjp1.CUSTOM13,
2236: pjp1.CUSTOM14,
2237: pjp1.CUSTOM15
2238: from
2239: PJI_FP_AGGR_PJP1 pjp1,
2240: PJI_PJP_WBS_HEADER wbs_hdr,
2241: PJI_XBS_DENORM prg,
2242: (
2243: select 'Y' CB_FLAG,

Line 2454: FROM PJI_FP_AGGR_PJP1 pjp1

2450: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
2451: , l_last_update_date
2452: , l_last_updated_by
2453: , l_last_update_login
2454: FROM PJI_FP_AGGR_PJP1 pjp1
2455: , pji_time_cal_period_v cal
2456: WHERE
2457: pjp1.worker_id = p_worker_id
2458: AND pjp1.plan_version_id = whdr.plan_version_id

Line 2464: WHERE exists (select 1 from pji_fp_aggr_pjp1 ver where worker_id = p_worker_id

2460: AND pjp1.plan_type_id = whdr.plan_type_id
2461: AND pjp1.time_id = cal.cal_period_id
2462: AND pjp1.calendar_type IN ('P', 'G') -- Non time ph and ent cals don't need to be considered.
2463: )
2464: WHERE exists (select 1 from pji_fp_aggr_pjp1 ver where worker_id = p_worker_id
2465: and ver.project_id = whdr.project_id
2466: and ver.plan_version_id = whdr.plan_version_id
2467: and ver.plan_type_id = whdr.plan_type_id);
2468:

Line 2693: FROM pji_fp_aggr_pjp1 tmp

2689: , CUSTOM13
2690: , CUSTOM14
2691: , CUSTOM15
2692: , tmp.plan_type_code
2693: FROM pji_fp_aggr_pjp1 tmp
2694: , pji_pjp_wbs_header ver3
2695: WHERE 1 = 1
2696: AND ver3.plan_version_id = tmp.plan_version_id
2697: AND ver3.plan_type_code = tmp.plan_type_code /* 4471527 */

Line 2719: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;

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);
2718:
2719: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2720:
2721: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);
2722:
2723: end if;

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

2717: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2718:
2719: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2720:
2721: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);
2722:
2723: end if;
2724:
2725: Begin