1 PACKAGE PA_RBS_HEADER_PVT AS
2 --$Header: PARBSHVS.pls 120.0 2005/05/30 17:32:42 appldev noship $
3
4
5 PROCEDURE Insert_Header(
6 P_Name IN Varchar2,
7 P_Description IN Varchar2,
8 P_EffectiveFrom IN Date,
9 P_EffectiveTo IN Date,
10 P_Use_For_Alloc_Flag IN Varchar2,
11 X_RbsHeaderId OUT NOCOPY 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 Insert_Versions(
17 p_rbsHeaderId IN Number,
18 p_name IN Varchar2,
19 p_description IN Varchar2 Default Null,
20 p_effectiveFrom IN Date,
21 X_Rbs_Version_Id OUT NOCOPY Number,
22 x_return_status OUT NOCOPY Varchar2,
23 x_msg_data OUT NOCOPY Varchar2,
24 x_msg_count OUT NOCOPY Number );
25
26 Procedure Insert_Structure_Element(
27 P_Rbs_Version_Id IN Number,
28 X_Rbs_Element_Id OUT NOCOPY Number,
29 X_Return_Status OUT NOCOPY Varchar2,
30 X_Error_Msg_Data OUT NOCOPY Varchar2,
31 X_Msg_Count OUT NOCOPY Number);
32
33 PROCEDURE Update_Header(
34 p_rbsHeaderId IN Number,
35 p_name IN Varchar2,
36 p_description IN Varchar2,
37 p_effectiveFrom IN Date,
38 p_effectiveTo IN Date,
39 p_use_for_alloc_flag IN Varchar2,
40 x_return_status OUT NOCOPY Varchar2,
41 x_msg_data OUT NOCOPY Varchar2,
42 x_msg_count OUT NOCOPY Number);
43
44 PROCEDURE Update_Versions(
45 p_rbsHeaderId IN Number,
46 p_rbsVersionId IN Number Default Null,
47 p_name IN Varchar2,
48 p_description IN Varchar2 Default Null,
49 p_effectiveFrom IN Date,
50 P_Rec_Version_Num IN Number Default Null,
51 x_return_status OUT NOCOPY Varchar2,
52 x_msg_data OUT NOCOPY Varchar2,
53 x_msg_count OUT NOCOPY Number);
54
55 FUNCTION Validate_Rbs_For_Allocations( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2;
56
57 END PA_RBS_HEADER_PVT;