[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;