APPS.PJI_PJP_SUM_MAIN dependencies on PJI_FP_AGGR_PJP1

Line 973: DELETE PJI_FP_AGGR_PJP1 where worker_id = p_worker_id;

969:
970: if l_count > 0 then
971:
972: DELETE PJI_FM_EXTR_PLNVER4 where worker_id = p_worker_id;
973: DELETE PJI_FP_AGGR_PJP1 where worker_id = p_worker_id;
974:
975: INSERT INTO PJI_FM_EXTR_PLNVER4
976: (
977: WORKER_ID ,

Line 1154: INSERT INTO PJI_FP_AGGR_PJP1

1150: -- prg_rollup_flag = 'Y' lines if required
1151: -- Commit;
1152: -- pji_utils.write2log('Inserting all the positive plan version data into the PJP1 table for futher ');
1153:
1154: INSERT INTO PJI_FP_AGGR_PJP1
1155: (
1156: WORKER_ID
1157: , PROJECT_ID
1158: , PROJECT_ORG_ID

Line 1337: insert into PJI_FP_AGGR_PJP1

1333:
1334: -- pji_utils.write2log('In loop of rollup_fpr_wbs'||l_level);
1335: -- rollup project hiearchy
1336:
1337: insert into PJI_FP_AGGR_PJP1
1338: (
1339: WORKER_ID,
1340: RECORD_TYPE,
1341: PRG_LEVEL,

Line 2062: PJI_FP_AGGR_PJP1 pjp1,

2058: pjp1.CUSTOM13,
2059: pjp1.CUSTOM14,
2060: pjp1.CUSTOM15
2061: from
2062: PJI_FP_AGGR_PJP1 pjp1,
2063: PJI_PJP_WBS_HEADER wbs_hdr,
2064: PA_XBS_DENORM wbs,
2065: PJI_XBS_DENORM prg,
2066: (

Line 2216: PJI_FP_AGGR_PJP1 pjp1,

2212: pjp1.CUSTOM13,
2213: pjp1.CUSTOM14,
2214: pjp1.CUSTOM15
2215: from
2216: PJI_FP_AGGR_PJP1 pjp1,
2217: PJI_PJP_WBS_HEADER wbs_hdr,
2218: PJI_XBS_DENORM prg,
2219: (
2220: select 'Y' CB_FLAG,

Line 2431: FROM PJI_FP_AGGR_PJP1 pjp1

2427: , MAX(GREATEST(cal.end_date, NVL(whdr.max_txn_date, cal.end_date))) end_date
2428: , l_last_update_date
2429: , l_last_updated_by
2430: , l_last_update_login
2431: FROM PJI_FP_AGGR_PJP1 pjp1
2432: , pji_time_cal_period_v cal
2433: WHERE
2434: pjp1.worker_id = p_worker_id
2435: AND pjp1.plan_version_id = whdr.plan_version_id

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

2437: AND pjp1.plan_type_id = whdr.plan_type_id
2438: AND pjp1.time_id = cal.cal_period_id
2439: AND pjp1.calendar_type IN ('P', 'G') -- Non time ph and ent cals don't need to be considered.
2440: )
2441: WHERE exists (select 1 from pji_fp_aggr_pjp1 ver where worker_id = p_worker_id
2442: and ver.project_id = whdr.project_id
2443: and ver.plan_version_id = whdr.plan_version_id
2444: and ver.plan_type_id = whdr.plan_type_id);
2445:

Line 2670: FROM pji_fp_aggr_pjp1 tmp

2666: , CUSTOM13
2667: , CUSTOM14
2668: , CUSTOM15
2669: , tmp.plan_type_code
2670: FROM pji_fp_aggr_pjp1 tmp
2671: , pji_pjp_wbs_header ver3
2672: WHERE 1 = 1
2673: AND ver3.plan_version_id = tmp.plan_version_id
2674: AND ver3.plan_type_code = tmp.plan_type_code /* 4471527 */

Line 2696: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;

2692: DELETE FROM pji_fm_extr_plnver4 where worker_id = p_worker_id;
2693:
2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2695:
2696: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2697:
2698: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);
2699:
2700: end if;

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

2694: --pji_utils.write2log('Deleted records from pji_fm_extr_plnver4'||sql%rowcount);
2695:
2696: DELETE FROM pji_fp_aggr_pjp1 where worker_id = p_worker_id;
2697:
2698: --pji_utils.write2log('Deleted records from pji_fp_aggr_pjp1'||sql%rowcount);
2699:
2700: end if;
2701:
2702: Begin