APPS.PJI_PERF_RPTG_PUB dependencies on PJI_FP_XBS_ACCUM_F

Line 14: -- PJI_FP_XBS_ACCUM_F,PJI_ROLLUP_LEVEL_STATUS table based on the

10: --------------------------------------------------------------------------------
11: --Name: Create_resource_rollup
12: --Type: Procedure
13: --Description:This procedure can be used to create smart lines in
14: -- PJI_FP_XBS_ACCUM_F,PJI_ROLLUP_LEVEL_STATUS table based on the
15: -- RBS for list of Workplans/Financial Plans and Actual transaction.
16: --
17: --History:
18: -- 30-JUN-2006 DEGUPTA Created

Line 298: DELETE FROM pji_fp_xbs_accum_f

294:
295:
296: IF (SQL%ROWCOUNT > 0) THEN
297:
298: DELETE FROM pji_fp_xbs_accum_f
299: WHERE project_id=p_project_id
300: AND (rbs_aggr_level = 'R'
301: OR (rbs_aggr_level = 'L'
302: AND wbs_rollup_flag = 'Y')) ;

Line 317: DELETE FROM pji_fp_xbs_accum_f

313:
314: IF (SQL%ROWCOUNT > 0) THEN
315: FORALL j IN 1..p_rbs_version_id_tbl.COUNT
316:
317: DELETE FROM pji_fp_xbs_accum_f
318: WHERE project_id=p_project_id
319: and rbs_version_id=p_rbs_version_id_tbl(j)
320: AND (rbs_aggr_level = 'R'
321: OR (rbs_aggr_level = 'L'

Line 338: DELETE FROM pji_fp_xbs_accum_f

334:
335: IF (SQL%ROWCOUNT > 0) THEN
336: FORALL i IN 1..p_plan_version_id_tbl.COUNT
337:
338: DELETE FROM pji_fp_xbs_accum_f
339: WHERE project_id=p_project_id
340: and plan_version_id=p_plan_version_id_tbl(i)
341: AND (rbs_aggr_level = 'R'
342: OR (rbs_aggr_level = 'L'

Line 359: DELETE FROM pji_fp_xbs_accum_f

355:
356: IF (SQL%ROWCOUNT > 0) THEN
357: FORALL i IN 1..p_plan_version_id_tbl.COUNT
358:
359: DELETE FROM pji_fp_xbs_accum_f
360: WHERE project_id=p_project_id
361: and plan_version_id=p_plan_version_id_tbl(i)
362: and rbs_version_id=p_rbs_version_id_tbl(j)
363: AND (rbs_aggr_level = 'R'