DBA Data[Home] [Help]

PACKAGE: APPS.PA_CBS_LEVEL_HIERARCHY_PVT

Source


1 PACKAGE PA_CBS_LEVEL_HIERARCHY_PVT AUTHID CURRENT_USER AS
2 --$Header: PACBSLVS.pls 120.0.12020000.2 2013/03/25 11:14:34 bnoorbha noship $
3 
4 
5 Procedure Insert_Level(
6 	P_CbsHeaderId	    	 IN         Number,
7 	P_Structure_Level		 IN         Number,
8 	P_Cost_Category          IN         Varchar2,
9 	P_Meaning          		 IN         Varchar2,
10 	P_Description 	         IN         Varchar2 Default NULL,
11 	P_Record_Version_Number	 IN         Number,
12 	X_Return_Status      	 OUT NOCOPY Varchar2,
13 	X_Msg_Data 	     		 OUT NOCOPY Varchar2,
14 	X_Msg_Count 	     	 OUT NOCOPY Number);
15 
16 PROCEDURE Update_Level(
17 	P_CbsStructLevelId	     IN         Number,
18 	P_CbsHeaderId	    	 IN         Number,
19 	P_Structure_Level		 IN         Number,
20 	P_Cost_Category          IN         Varchar2,
21 	P_Meaning          		 IN         Varchar2,
22 	P_Description 	         IN         Varchar2 Default NULL,
23 	P_Record_Version_Number	 IN         Number,
24 	X_Record_Version_Number	 OUT NOCOPY  Number,
25 	X_Return_Status      	 OUT NOCOPY Varchar2,
26 	X_Msg_Data 	     		 OUT NOCOPY Varchar2,
27 	X_Msg_Count 	     	 OUT NOCOPY Number);
28 
29 PROCEDURE Delete_Level(
30 	P_CbsStructLevelId	      IN         Number,
31 	P_CbsHeaderId	          IN         Number,
32 	P_Structure_Level		 IN         Number,
33 	P_Cost_Category          IN         Varchar2,
34 	P_Record_Version_Number	 IN         Number,
35 	X_Return_Status       	 OUT NOCOPY Varchar2,
36 	X_Msg_Data 	      		 OUT NOCOPY Varchar2,
37 	X_Msg_Count 	      	 OUT NOCOPY Number);
38 
39 FUNCTION IS_CBS_USED(
40  P_Cbs_Header_Id           IN         Number) return varchar2;
41 
42 END PA_CBS_LEVEL_HIERARCHY_PVT;