APPS.PJI_PERF_RPTG_PUB dependencies on PJI_ROLLUP_LEVEL_STATUS

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 292: DELETE FROM pji_rollup_level_status

288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:
291: IF p_plan_version_id_tbl.COUNT=0 and p_rbs_version_id_tbl.COUNT=0 then
292: DELETE FROM pji_rollup_level_status
293: WHERE project_id=p_project_id;
294:
295:
296: IF (SQL%ROWCOUNT > 0) THEN

Line 309: DELETE FROM pji_rollup_level_status

305: ELSIF p_plan_version_id_tbl.COUNT=0 and p_rbs_version_id_tbl.COUNT<>0 then
306:
307: FORALL j IN 1..p_rbs_version_id_tbl.COUNT
308:
309: DELETE FROM pji_rollup_level_status
310: WHERE project_id=p_project_id
311: and rbs_version_id=p_rbs_version_id_tbl(j);
312:
313:

Line 330: DELETE FROM pji_rollup_level_status

326: ELSIF p_plan_version_id_tbl.COUNT<>0 and p_rbs_version_id_tbl.COUNT=0 then
327:
328: FORALL i IN 1..p_plan_version_id_tbl.COUNT
329:
330: DELETE FROM pji_rollup_level_status
331: WHERE project_id=p_project_id
332: and plan_version_id=p_plan_version_id_tbl(i);
333:
334:

Line 350: DELETE FROM pji_rollup_level_status

346:
347: ELSIF p_plan_version_id_tbl.COUNT<>0 and p_rbs_version_id_tbl.COUNT<>0 then
348: FOR j IN 1..p_rbs_version_id_tbl.COUNT LOOP
349: FORALL i IN 1..p_plan_version_id_tbl.COUNT
350: DELETE FROM pji_rollup_level_status
351: WHERE project_id=p_project_id
352: and plan_version_id=p_plan_version_id_tbl(i)
353: and rbs_version_id=p_rbs_version_id_tbl(j);
354: