1 Package Pa_Rbs_Versions_Pub AUTHID CURRENT_USER AS
2 --$Header: PARBSVPS.pls 120.3 2011/12/28 11:01:14 djambhek ship $
3
4 --Package constant used for package version validation
5 G_API_VERSION_NUMBER CONSTANT Number := 1;
6 G_PKG_NAME CONSTANT Varchar2(30) := 'PA_RBS_VERSIONS_PUB';
7
8
9 -- =======================================================================
10 -- Start of Comments
11 -- API Name : Update_Working_Version
12 -- Type : Public
13 -- Pre-Reqs : None
14 -- Type : Procedure
15 -- Function : This procedure allows for the update of the current working version for a rbs header.
16 --
17 -- Parameters:
18 --
19 -- IN
20 -- P_Commit - Varchar2 Default Fnd_Api.G_False
21 -- P_Init_Msg_List - Varchar2 Default Fnd_Api.G_True
22 -- P_Api_Version_Number - Number
23 -- P_RBS_Version_Id - Number
24 -- P_Name - Varchar2(240)
25 -- P_Description - Varchar2(2000)
26 -- P_Version_Start_Date - Date
27 -- P_Job_Group_Id - Number
28 -- P_Record_Version_Number - Number
29 -- P_Init_Debugging_Flag - Varchar2 Default 'Y'
30 -- OUT
31 -- X_Record_Version_Number - Number
32 -- X_Return_Status - Varchar2(1)
33 -- X_Msg_Count - Number
34 -- X_Error_Msg_Data - Varchar2(30)
35 /*-------------------------------------------------------------------------*/
36
37 Procedure Update_Working_Version(
38 P_Commit IN Varchar2 Default Fnd_Api.G_False,
39 P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
40 P_API_Version_Number IN Number,
41 P_RBS_Version_Id IN Number,
42 P_Name IN Varchar2,
43 P_Description IN Varchar2,
44 P_Version_Start_Date IN Date,
45 P_Job_Group_Id IN Number,
46 P_Record_Version_Number IN Number,
47 P_Res_Class_Flag IN VARCHAR2 Default 'Y', --Added for CBS::13535688
48 P_Init_Debugging_Flag IN Varchar2 Default 'Y',
49 X_Record_Version_Number OUT NOCOPY Number,
50 X_Return_Status OUT NOCOPY Varchar2,
51 X_Msg_Count OUT NOCOPY Number,
52 X_Error_Msg_Data OUT NOCOPY Varchar2);
53
54 -- =======================================================================
55 -- Start of Comments
56 -- API Name : Delete_Working_Version
57 -- Type : Public
58 -- Pre-Reqs : None
59 -- Type : Procedure
60 -- Function : This procedure deletes the working rbs version as well as it elements/nodes.
61 --
62 -- Parameters:
63 --
64 -- IN
65 -- P_Commit - Varchar2 Default Fnd_Api.G_False
66 -- P_Init_Msg_List - Varchar2 Default Fnd_Api.G_True
67 -- P_Api_Version_Number - Number
68 -- P_RBS_Version_Id - Number(15)
69 -- P_Record_Version_Number - Number(15)
70 -- OUT
71 -- X_Return_Status - Varchar2(1)
72 -- X_Msg_Count - Number
73 -- X_Error_Msg_Data - Varchar2(30)
74 --
75 /*-------------------------------------------------------------------------*/
76
77 Procedure Delete_Working_Version(
78 P_Commit IN Varchar2 Default Fnd_Api.G_False,
79 P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
80 P_Api_Version_Number IN Number,
81 P_RBS_Version_Id IN Number,
82 P_Record_Version_Number IN Number,
83 X_Return_Status OUT NOCOPY Varchar2,
84 X_Msg_Count OUT NOCOPY Number,
85 X_Error_Msg_Data OUT NOCOPY Varchar2);
86
87
88 -- =======================================================================
89 -- Start of Comments
90 -- API Name : Create_Working_Version
91 -- Type : Public
92 -- Pre-Reqs : None
93 -- Type : Procedure
94 -- Function : This procedure create a new working rbs version based on a previously frozen rbs version.
95 --
96 -- Parameters:
97 --
98 -- IN
99 -- P_Commit - Varchar2 Default Fnd_Api.G_False,
100 -- P_Init_Msg_List - Varchar2 Default Fnd_Api.G_True,
101 -- P_Api_Version_Number - Number
102 -- P_RBS_Version_Id - Number(15) is the frozen version id to copy from(should not be null copying)
103 -- P_Rbs_Header_Id - Number(15) is Header for the frozen and the working version
104 -- P_Rec_Version_Number - Number(15) is from the current working version
105 -- OUT
106 -- X_Return_Status - Varchar2(1)
107 -- X_Msg_Count - Number
108 -- X_Error_Msg_Data - Varchar2(30)
109 --
110 /*-------------------------------------------------------------------------*/
111
112 Procedure Create_Working_Version (
113 P_Commit IN Varchar2 Default Fnd_Api.G_False,
114 P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
115 P_Api_Version_Number IN Number,
116 P_RBS_Version_Id IN Number Default Null,
117 P_Rbs_Header_Id IN Number,
118 P_Rec_Version_Number IN Number Default Null,
119 P_Init_Debugging_Flag IN Varchar2 Default 'Y',
120 X_Return_Status OUT NOCOPY Varchar2,
121 X_Msg_Count OUT NOCOPY Number,
122 X_Error_Msg_Data OUT NOCOPY Varchar2 );
123
124
125 -- =======================================================================
126 -- Start of Comments
127 -- API Name : Freeze_Working_Version
128 -- Type : Public
129 -- Pre-Reqs : None
130 -- Type : Procedure
131 -- Function : This procedure freezes the working version and inturn creates a new working rbs version based on a this version.
132 --
133 -- Parameters:
134 --
135 -- IN
136 -- P_Commit - Varchar2 Default Fnd_Api.G_False,
137 -- P_Init_Msg_List - Varchar2 Default Fnd_Api.G_True,
138 -- P_rbs_Version_Id - Number(15) is the version id of the version to be freezed
139 -- P_rbs_version_record_ver_num - Number(15) is the record version number of the version to be freezed
140 -- P_Init_Debugging_Flag - Vachar2(1)
141 -- OUT
142 -- X_Return_Status - Varchar2(1)
143 -- X_Msg_Count - Number
144 -- X_Error_Msg_Data - Varchar2(30)
145 --
146 /*-------------------------------------------------------------------------*/
147 Procedure Freeze_Working_Version(
148 P_Commit IN Varchar2 Default Fnd_Api.G_False,
149 P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
150 P_Rbs_Version_Id IN Number,
151 P_Rbs_Version_Record_Ver_Num IN Number Default Null,
152 P_Init_Debugging_Flag IN Varchar2 Default 'Y',
153 X_Return_Status OUT NOCOPY Varchar2,
154 X_Msg_Count OUT NOCOPY Number,
155 X_Error_Msg_Data OUT NOCOPY Varchar2);
156
157 End Pa_Rbs_Versions_Pub;