[Home] [Help]
PACKAGE: APPS.PA_RBS_HEADER_PVT
Source
1 PACKAGE PA_RBS_HEADER_PVT AUTHID CURRENT_USER AS
2 --$Header: PARBSHVS.pls 120.0.12020000.2 2013/03/27 17:52:58 bpottipa ship $
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 P_Cbs_Enabled IN Varchar2 Default NULL, --bug#15834912
12 P_ACTIVE_FLAG IN Varchar2 Default NULL, --bug#15834912
13 X_RbsHeaderId OUT NOCOPY Number,
14 x_return_status OUT NOCOPY Varchar2,
15 x_msg_data OUT NOCOPY Varchar2,
16 x_msg_count OUT NOCOPY NUMBER );
17
18 PROCEDURE Insert_Versions(
19 p_rbsHeaderId IN Number,
20 p_name IN Varchar2,
21 p_description IN Varchar2 Default Null,
22 p_effectiveFrom IN Date,
23 X_Rbs_Version_Id OUT NOCOPY Number,
24 x_return_status OUT NOCOPY Varchar2,
25 x_msg_data OUT NOCOPY Varchar2,
26 x_msg_count OUT NOCOPY Number );
27
28 Procedure Insert_Structure_Element(
29 P_Rbs_Version_Id IN Number,
30 X_Rbs_Element_Id OUT NOCOPY Number,
31 X_Return_Status OUT NOCOPY Varchar2,
32 X_Error_Msg_Data OUT NOCOPY Varchar2,
33 X_Msg_Count OUT NOCOPY Number);
34
35 PROCEDURE Update_Header(
36 p_rbsHeaderId IN Number,
37 p_name IN Varchar2,
38 p_description IN Varchar2,
39 p_effectiveFrom IN Date,
40 p_effectiveTo IN Date,
41 p_use_for_alloc_flag IN Varchar2,
42 P_ACTIVE_FLAG IN Varchar2 Default NULL, --bug#15834912
43 x_return_status OUT NOCOPY Varchar2,
44 x_msg_data OUT NOCOPY Varchar2,
45 x_msg_count OUT NOCOPY Number);
46
47 PROCEDURE Update_Versions(
48 p_rbsHeaderId IN Number,
49 p_rbsVersionId IN Number Default Null,
50 p_name IN Varchar2,
51 p_description IN Varchar2 Default Null,
52 p_effectiveFrom IN Date,
53 P_Rec_Version_Num IN Number Default Null,
54 x_return_status OUT NOCOPY Varchar2,
55 x_msg_data OUT NOCOPY Varchar2,
56 x_msg_count OUT NOCOPY Number);
57
58 FUNCTION Validate_Rbs_For_Allocations( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2;
59
60 END PA_RBS_HEADER_PVT;