APPS.PA_CBS_LEVEL_HIERARCHY_PVT SQL Statements

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

Line: 23

Procedure Insert_Level(
	P_CbsHeaderId	    	 IN         Number,
	P_Structure_Level		 IN         Number,
	P_Cost_Category          IN         Varchar2,
	P_Meaning          		 IN         Varchar2,
	P_Description 	         IN         Varchar2 Default NULL,
	P_Record_Version_Number	 IN         Number,
	X_Return_Status      	 OUT NOCOPY Varchar2,
	X_Msg_Data 	     		 OUT NOCOPY Varchar2,
	X_Msg_Count 	     	 OUT NOCOPY Number)
IS
	UNABLE_TO_INSERT_LEVEL 		  Exception;

Line: 39

	select COST_CATEGORY from PA_CBS_HIERARCHY
	where CBS_HEADER_ID = P_CbsHeaderId and
	STRUCTURE_LEVEL = P_Structure_Level;

Line: 44

	Select PA_CBS_HIERARCHY_S.NextVal
    From Dual;

Line: 54

        pa_debug.init_err_stack('PA_CBS_LEVEL_HIERARCHY_PVT.Insert_Level');

Line: 58

	print_msg('PA_CBS_LEVEL_HIERARCHY_PVT.Insert_Level IN param(Scalar) values');

Line: 69

		RAISE UNABLE_TO_INSERT_LEVEL;

Line: 79

	INSERT INTO PA_CBS_HIERARCHY (
	CBS_STRUCT_LEVEL_ID	,
	CBS_HEADER_ID       ,
	STRUCTURE_LEVEL		,
	COST_CATEGORY		,
	MEANING				,
	LAST_UPDATE_DATE    ,
	LAST_UPDATED_BY     ,
	CREATION_DATE       ,
	CREATED_BY          ,
	LAST_UPDATE_LOGIN   ,
	DESCRIPTION			,
	RECORD_VERSION_NUMBER )
	VALUES (
	L_CbsStructLevelId	,
	P_CbsHeaderId		,
	P_Structure_Level	,
	P_Cost_Category		,
	P_Meaning			,
	SysDate				,
	Fnd_Global.User_Id	,
	SysDate				,
	Fnd_Global.User_Id	,
	Fnd_Global.Login_Id	,
	P_Description		,
	P_Record_Version_Number
	);

Line: 111

	When UNABLE_TO_INSERT_LEVEL Then
		X_Return_Status := 'U';

Line: 122

END Insert_Level;

Line: 125

PROCEDURE Update_Level(
	P_CbsStructLevelId	     IN         Number,
	P_CbsHeaderId	    	 IN         Number,
	P_Structure_Level		 IN         Number,
	P_Cost_Category          IN         Varchar2,
	P_Meaning          		 IN         Varchar2,
	P_Description 	         IN         Varchar2 Default NULL,
	P_Record_Version_Number	 IN         Number,
	X_Record_Version_Number	 OUT NOCOPY  Number,
	X_Return_Status      	 OUT NOCOPY Varchar2,
	X_Msg_Data 	     		 OUT NOCOPY Varchar2,
	X_Msg_Count 	     	 OUT NOCOPY Number)
IS
	UNABLE_TO_UPDATE_LEVEL Exception;

Line: 142

	select 'N' from dual;

Line: 151

        pa_debug.init_err_stack('PA_CBS_LEVEL_HIERARCHY_PVT.Update_Level');

Line: 155

	print_msg('PA_CBS_LEVEL_HIERARCHY_PVT.Update_Level IN param(Scalar) values');

Line: 170

		RAISE UNABLE_TO_UPDATE_LEVEL;

Line: 173

	UPDATE PA_CBS_HIERARCHY
	SET
	COST_CATEGORY			= 	P_Cost_Category,
	MEANING					= 	P_Meaning,
	DESCRIPTION				=	P_Description,
	RECORD_VERSION_NUMBER	=	RECORD_VERSION_NUMBER + 1,
	LAST_UPDATE_DATE		= 	Sysdate,
	LAST_UPDATED_BY			=	Fnd_Global.User_Id,
	LAST_UPDATE_LOGIN		=	Fnd_Global.Login_Id
	WHERE
	CBS_HEADER_ID				= 	P_CbsHeaderId
	AND STRUCTURE_LEVEL			= 	P_Structure_Level
	AND RECORD_VERSION_NUMBER	= 	P_Record_Version_Number
	AND CBS_STRUCT_LEVEL_ID		=	P_CbsStructLevelId;

Line: 191

	When UNABLE_TO_UPDATE_LEVEL Then
		X_Return_Status := 'U';

Line: 201

END Update_Level;

Line: 204

PROCEDURE Delete_Level(
	P_CbsStructLevelId	      IN         Number,
	P_CbsHeaderId	          IN         Number,
	P_Structure_Level		 IN         Number,
	P_Cost_Category          IN         Varchar2,
	P_Record_Version_Number	 IN         Number,
	X_Return_Status       	 OUT NOCOPY Varchar2,
	X_Msg_Data 	      		 OUT NOCOPY Varchar2,
	X_Msg_Count 	      	 OUT NOCOPY Number)
IS
	UNABLE_TO_DELETE_LEVEL Exception;

Line: 218

	select IS_CBS_USED(P_CbsHeaderId) from dual;

Line: 227

        pa_debug.init_err_stack('PA_CBS_LEVEL_HIERARCHY_PVT.Delete_Level');

Line: 231

	print_msg('PA_CBS_LEVEL_HIERARCHY_PVT.Delete_Level IN param(Scalar) values');

Line: 245

		RAISE UNABLE_TO_DELETE_LEVEL;

Line: 248

	delete from PA_RBS_ELEMENTS where
	rbs_level = (P_Structure_Level)+1 and
	rbs_version_id = (select rbs_version_id from pa_rbs_versions_b where rbs_header_id = P_CbsHeaderId);

Line: 252

	DELETE FROM PA_CBS_HIERARCHY
	WHERE CBS_HEADER_ID			= 	P_CbsHeaderId
	AND STRUCTURE_LEVEL			= 	P_Structure_Level
	AND RECORD_VERSION_NUMBER	= 	P_Record_Version_Number
	AND CBS_STRUCT_LEVEL_ID		=	P_CbsStructLevelId;

Line: 260

	When UNABLE_TO_DELETE_LEVEL Then
		X_Return_Status := 'U';

Line: 270

END Delete_Level;

Line: 278

 select 'Y' from dual where
EXISTS
(SELECT *
 FROM PA_PROJECTS_ALL
 WHERE CBS_VERSION_ID =
 (select rbs_version_id from pa_rbs_versions_b where rbs_header_id = P_CBS_HEADER_ID));