APPS.PJI_PERF_RPTG_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 138

  SELECT distinct WBS_VERSION_ID
  into l_wbs_version_id
  FROM PJI_PJP_WBS_HEADER
  WHERE PROJECT_ID = p_project_id
  AND PLAN_VERSION_ID = p_plan_version_id_tbl(1);

Line: 217

PROCEDURE Delete_resource_rollup
( p_api_version_number      IN   NUMBER      :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
 ,p_commit                  IN   VARCHAR2    := FND_API.G_FALSE
 ,p_init_msg_list           IN   VARCHAR2    := FND_API.G_FALSE
 ,x_msg_count               OUT NOCOPY NUMBER
 ,x_msg_data                OUT NOCOPY VARCHAR2
 ,x_return_status           OUT NOCOPY VARCHAR2
 ,p_project_id              IN   NUMBER
 ,p_plan_version_id_tbl     IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
 ,p_rbs_version_id_tbl      IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
) IS
   l_api_name         CONSTANT  VARCHAR2(30)     := 'Delete_resource_rollup';

Line: 241

    SAVEPOINT Delete_resource_pub;

Line: 292

    DELETE FROM pji_rollup_level_status
    WHERE project_id=p_project_id;

Line: 298

  	DELETE FROM pji_fp_xbs_accum_f
  	WHERE project_id=p_project_id
  	AND (rbs_aggr_level = 'R'
  		 OR (rbs_aggr_level = 'L'
	 	 AND wbs_rollup_flag = 'Y')) ;

Line: 309

      DELETE FROM pji_rollup_level_status
       WHERE project_id=p_project_id
       and rbs_version_id=p_rbs_version_id_tbl(j);

Line: 317

    	DELETE FROM pji_fp_xbs_accum_f
  	WHERE project_id=p_project_id
    and rbs_version_id=p_rbs_version_id_tbl(j)
  	AND (rbs_aggr_level = 'R'
  		 OR (rbs_aggr_level = 'L'
	 	 AND wbs_rollup_flag = 'Y')) ;

Line: 330

     DELETE FROM pji_rollup_level_status
     WHERE project_id=p_project_id
     and plan_version_id=p_plan_version_id_tbl(i);

Line: 338

    	DELETE FROM pji_fp_xbs_accum_f
  	WHERE project_id=p_project_id
    and plan_version_id=p_plan_version_id_tbl(i)
  	AND (rbs_aggr_level = 'R'
  		 OR (rbs_aggr_level = 'L'
	 	 AND wbs_rollup_flag = 'Y')) ;

Line: 350

         DELETE FROM pji_rollup_level_status
         WHERE project_id=p_project_id
         and plan_version_id=p_plan_version_id_tbl(i)
         and rbs_version_id=p_rbs_version_id_tbl(j);

Line: 359

           	DELETE FROM pji_fp_xbs_accum_f
        	WHERE project_id=p_project_id
            and plan_version_id=p_plan_version_id_tbl(i)
            and rbs_version_id=p_rbs_version_id_tbl(j)
  	        AND (rbs_aggr_level = 'R'
  		    OR (rbs_aggr_level = 'L'
	 	     AND wbs_rollup_flag = 'Y')) ;

Line: 377

    ROLLBACK to Delete_resource_pub;

Line: 382

       ROLLBACK TO delete_resource_pub;

Line: 390

      ROLLBACK TO delete_resource_pub;

Line: 398

      ROLLBACK TO delete_resource_pub;

Line: 413

END Delete_resource_rollup;