DBA Data[Home] [Help]

PACKAGE: APPS.PA_RBS_VERSIONS_PVT

Source


1 Package PA_RBS_VERSIONS_PVT AUTHID CURRENT_USER as
2 --$Header: PARBSVVS.pls 120.3 2011/12/28 11:05:13 djambhek ship $
3 
4 -- Standard Who
5 G_Last_Updated_By         Number(15) := Fnd_Global.User_Id;
6 G_Last_Update_Date        Date       := SysDate;
7 G_Creation_Date           Date       := SysDate;
8 G_Created_By              Number(15) := Fnd_Global.User_Id;
9 G_Last_Update_Login       Number(15) := Fnd_Global.Login_Id;
10 
11 Procedure Create_Working_Version_Record(
12 	P_Mode                  IN         Varchar2 Default Null,
13 	P_Version_Number	IN	   Number,
14 	P_Rbs_Header_Id		IN	   Number,
15 	P_Record_Version_Number IN         Number,
16 	P_Name			IN	   Varchar2,
17 	P_Description		IN	   Varchar2,
18 	P_Version_Start_Date	IN	   Date,
19 	P_Version_End_Date	IN	   Date,
20 	P_Job_Group_Id		IN	   Number,
21 	P_Resource_Class_Flag IN Varchar2 DEFAULT 'Y',  --Added for CBS::13535688
22 	P_Rule_Based_Flag	IN	   Varchar2,
23 	P_Validated_Flag	IN	   Varchar2,
24 	P_Status_Code		IN	   Varchar2,
25 	X_Record_Version_Number	OUT NOCOPY Number,
26 	X_RBS_Version_Id	OUT NOCOPY Number,
27 	X_Error_Msg_Data	OUT NOCOPY Varchar2 );
28 
29 Procedure Update_Working_Version(
30 	P_RBS_Version_Id	IN	   Number,
31 	P_Name			IN	   Varchar2,
32 	P_Description		IN	   Varchar2,
33 	P_Version_Start_Date	IN	   Date	,
34 	P_Job_Group_Id		IN	   Number,
35 	P_Record_Version_Number	IN	   Number,
36 	P_Res_Class_Flag     IN VARCHAR2 DEFAULT 'Y',  --Added for CBS::13535688
37 	X_Record_Version_Number OUT NOCOPY Number,
38 	X_Error_Msg_Data	OUT NOCOPY Varchar2 );
39 
40 Procedure Delete_Working_Version(
41 	P_Mode                  IN         Varchar2 Default Null,
42         P_RBS_Version_Id        IN         Number,
43         P_Record_Version_Number IN         Number,
44         X_Error_Msg_Data        OUT NOCOPY Varchar2);
45 
46 Procedure Create_New_Working_Version(
47 	P_Rbs_Version_Id        IN         Number,
48 	P_Rbs_Header_Id         IN         Number,
49 	P_Record_Version_Number IN         Number,
50 	X_Error_Msg_Data        OUT NOCOPY Varchar2);
51 
52 Procedure Copy_Frozen_Rbs_Version(
53 	P_Rbs_Version_Id        IN  Number,
54 	P_Rbs_Header_Id         IN  Number,
55 	P_Record_Version_Number IN  Number,
56 	X_Rbs_Version_Id        OUT NOCOPY Number,
57 	X_Error_Msg_Data        OUT NOCOPY Varchar2);
58 
59 Procedure Copy_Frozen_Rbs_Elements(
60 	P_Rbs_Version_From_Id IN         Number,
61 	P_Rbs_Version_To_Id   IN         Number,
62 	X_Error_Msg_Data      OUT NOCOPY Varchar2);
63 
64 Procedure Set_Reporting_Flag(
65         p_rbs_version_id   IN  Number,
66         x_return_status    OUT NOCOPY Varchar2);
67 
68 
69 END PA_RBS_VERSIONS_PVT;