eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RBS_VERSIONS_PVT dependencies on PA_RBS_VERSIONS_PVT

Line 1: Package Body Pa_Rbs_Versions_Pvt as

1: Package Body Pa_Rbs_Versions_Pvt as
2: --$Header: PARBSVVB.pls 120.5 2011/12/28 11:18:48 djambhek ship $
3:
4: Procedure Create_Working_Version_Record(
5: P_Mode IN Varchar2 Default Null,

Line 43: P_Creation_Date => Pa_Rbs_Versions_Pvt.G_Creation_Date,

39: P_Resource_Class_Flag => P_Resource_Class_Flag, --Added for CBS::13535688
40: P_Rule_Based_Flag => P_Rule_Based_Flag,
41: P_Validated_Flag => P_Validated_Flag,
42: P_Status_Code => P_Status_Code,
43: P_Creation_Date => Pa_Rbs_Versions_Pvt.G_Creation_Date,
44: P_Created_By => Pa_Rbs_Versions_Pvt.G_Created_By,
45: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
46: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
47: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,

Line 44: P_Created_By => Pa_Rbs_Versions_Pvt.G_Created_By,

40: P_Rule_Based_Flag => P_Rule_Based_Flag,
41: P_Validated_Flag => P_Validated_Flag,
42: P_Status_Code => P_Status_Code,
43: P_Creation_Date => Pa_Rbs_Versions_Pvt.G_Creation_Date,
44: P_Created_By => Pa_Rbs_Versions_Pvt.G_Created_By,
45: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
46: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
47: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
48: X_Record_Version_Number => X_Record_Version_Number,

Line 45: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,

41: P_Validated_Flag => P_Validated_Flag,
42: P_Status_Code => P_Status_Code,
43: P_Creation_Date => Pa_Rbs_Versions_Pvt.G_Creation_Date,
44: P_Created_By => Pa_Rbs_Versions_Pvt.G_Created_By,
45: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
46: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
47: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
48: X_Record_Version_Number => X_Record_Version_Number,
49: X_Rbs_Version_Id => X_RBS_Version_Id,

Line 46: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,

42: P_Status_Code => P_Status_Code,
43: P_Creation_Date => Pa_Rbs_Versions_Pvt.G_Creation_Date,
44: P_Created_By => Pa_Rbs_Versions_Pvt.G_Created_By,
45: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
46: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
47: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
48: X_Record_Version_Number => X_Record_Version_Number,
49: X_Rbs_Version_Id => X_RBS_Version_Id,
50: X_Error_Msg_Data => X_Error_Msg_Data);

Line 47: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,

43: P_Creation_Date => Pa_Rbs_Versions_Pvt.G_Creation_Date,
44: P_Created_By => Pa_Rbs_Versions_Pvt.G_Created_By,
45: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
46: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
47: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
48: X_Record_Version_Number => X_Record_Version_Number,
49: X_Rbs_Version_Id => X_RBS_Version_Id,
50: X_Error_Msg_Data => X_Error_Msg_Data);
51:

Line 98: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,

94: P_Version_Start_Date => P_Version_Start_Date,
95: P_Job_Group_Id => P_Job_Group_Id,
96: P_Record_Version_Number => P_Record_Version_Number,
97: P_Res_Class_Flag => P_Res_Class_Flag , --Added for CBS::13535688
98: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
99: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
100: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
101: X_Record_Version_Number => X_Record_Version_Number,
102: X_Error_Msg_Data => X_Error_Msg_Data);

Line 99: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,

95: P_Job_Group_Id => P_Job_Group_Id,
96: P_Record_Version_Number => P_Record_Version_Number,
97: P_Res_Class_Flag => P_Res_Class_Flag , --Added for CBS::13535688
98: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
99: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
100: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
101: X_Record_Version_Number => X_Record_Version_Number,
102: X_Error_Msg_Data => X_Error_Msg_Data);
103:

Line 100: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,

96: P_Record_Version_Number => P_Record_Version_Number,
97: P_Res_Class_Flag => P_Res_Class_Flag , --Added for CBS::13535688
98: P_Last_Update_Date => Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
99: P_Last_Updated_By => Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
100: P_Last_Update_Login => Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
101: X_Record_Version_Number => X_Record_Version_Number,
102: X_Error_Msg_Data => X_Error_Msg_Data);
103:
104: Pa_Debug.G_Stage := 'Check if Pa_Rbs_Versions_Pkg.Update_Row() procedure returned error msg.';

Line 200: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Version() procedure.';

196: Pa_Debug.G_Stage := 'Entering Create_New_Working_Version().';
197: Pa_Debug.TrackPath('ADD','Create_New_Working_Version');
198:
199:
200: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Version() procedure.';
201: Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Version(
202: P_Rbs_Version_Id => P_Rbs_Version_Id, -- the frozen version being copied
203: P_Rbs_Header_Id => P_Rbs_Header_Id,
204: P_Record_Version_Number => P_Record_Version_Number, -- This is the record_version_number of the working version

Line 201: Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Version(

197: Pa_Debug.TrackPath('ADD','Create_New_Working_Version');
198:
199:
200: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Version() procedure.';
201: Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Version(
202: P_Rbs_Version_Id => P_Rbs_Version_Id, -- the frozen version being copied
203: P_Rbs_Header_Id => P_Rbs_Header_Id,
204: P_Record_Version_Number => P_Record_Version_Number, -- This is the record_version_number of the working version
205: X_Rbs_Version_Id => l_Rbs_Version_Id, -- The working version being copied to

Line 220: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Elements() procedure.';

216: Raise l_Error;
217:
218: End If;
219:
220: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Elements() procedure.';
221:
222:
223: Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Elements(
224: P_Rbs_Version_From_Id => P_Rbs_Version_Id, -- this is the frozen version being copied from

Line 223: Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Elements(

219:
220: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Elements() procedure.';
221:
222:
223: Pa_Rbs_Versions_Pvt.Copy_Frozen_Rbs_Elements(
224: P_Rbs_Version_From_Id => P_Rbs_Version_Id, -- this is the frozen version being copied from
225: P_Rbs_Version_To_Id => l_Rbs_Version_Id, -- this is the working version being copied to
226: X_Error_Msg_Data => X_Error_Msg_Data);
227:

Line 418: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Delete_Working_Version() procedure.';

414: If l_Rvn = P_Record_Version_Number Then
415:
416:
417: -- Delete the current working rbs version and its element/node records
418: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Delete_Working_Version() procedure.';
419: Pa_Rbs_Versions_Pvt.Delete_Working_Version(
420: P_Mode => 'COPYING_FROZEN_VERSION',
421: P_Rbs_Version_Id => l_Rbs_Version_Id,
422: P_Record_Version_Number => P_Record_Version_Number,

Line 419: Pa_Rbs_Versions_Pvt.Delete_Working_Version(

415:
416:
417: -- Delete the current working rbs version and its element/node records
418: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pvt.Delete_Working_Version() procedure.';
419: Pa_Rbs_Versions_Pvt.Delete_Working_Version(
420: P_Mode => 'COPYING_FROZEN_VERSION',
421: P_Rbs_Version_Id => l_Rbs_Version_Id,
422: P_Record_Version_Number => P_Record_Version_Number,
423: X_Error_Msg_Data => X_Error_Msg_Data);

Line 501: Pa_Rbs_Versions_Pvt.Create_Working_Version_Record(

497: Pa_Debug.G_Stage := 'Use the version end date of last frozen version to derive new start date adding 1 to it.';
498: GetDetails_Rec.Version_End_Date := GetDetails_Rec.Version_End_Date + 1;
499:
500: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pkg.Insert_Row() procedure from existing .';
501: Pa_Rbs_Versions_Pvt.Create_Working_Version_Record(
502: P_Mode => 'COPYING_FROZEN_VERSION',
503: P_Version_Number => l_Version_Number,
504: P_Rbs_Header_Id => P_Rbs_Header_Id,
505: P_Record_Version_Number => l_Rec_Version_Number,

Line 531: Pa_Rbs_Versions_Pvt.Create_Working_Version_Record(

527: Fetch c_GetHdrFromDate Into l_Hdr_From_Date;
528: Close c_GetHdrFromDate;
529:
530: Pa_Debug.G_Stage := 'Call Pa_Rbs_Versions_Pkg.Insert_Row() procedure brand new.';
531: Pa_Rbs_Versions_Pvt.Create_Working_Version_Record(
532: P_Mode => 'COPYING_FROZEN_VERSION',
533: P_Version_Number => l_Version_Number,
534: P_Rbs_Header_Id => P_Rbs_Header_Id,
535: P_Record_Version_Number => l_Rec_Version_Number,

Line 711: Pa_Rbs_Versions_Pvt.G_Last_Update_Date,

707: Rbs_Elements.User_Defined_Custom3_Id,
708: Rbs_Elements.User_Defined_Custom4_Id,
709: Rbs_Elements.User_Defined_Custom5_Id,
710: Rbs_Elements.User_Created_Flag,
711: Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
712: Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
713: Pa_Rbs_Versions_Pvt.G_Creation_Date,
714: Pa_Rbs_Versions_Pvt.G_Created_By,
715: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,

Line 712: Pa_Rbs_Versions_Pvt.G_Last_Updated_By,

708: Rbs_Elements.User_Defined_Custom4_Id,
709: Rbs_Elements.User_Defined_Custom5_Id,
710: Rbs_Elements.User_Created_Flag,
711: Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
712: Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
713: Pa_Rbs_Versions_Pvt.G_Creation_Date,
714: Pa_Rbs_Versions_Pvt.G_Created_By,
715: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
716: 1

Line 713: Pa_Rbs_Versions_Pvt.G_Creation_Date,

709: Rbs_Elements.User_Defined_Custom5_Id,
710: Rbs_Elements.User_Created_Flag,
711: Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
712: Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
713: Pa_Rbs_Versions_Pvt.G_Creation_Date,
714: Pa_Rbs_Versions_Pvt.G_Created_By,
715: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
716: 1
717: From

Line 714: Pa_Rbs_Versions_Pvt.G_Created_By,

710: Rbs_Elements.User_Created_Flag,
711: Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
712: Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
713: Pa_Rbs_Versions_Pvt.G_Creation_Date,
714: Pa_Rbs_Versions_Pvt.G_Created_By,
715: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
716: 1
717: From
718: Pa_Rbs_Elements_Temp Tmp,

Line 715: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,

711: Pa_Rbs_Versions_Pvt.G_Last_Update_Date,
712: Pa_Rbs_Versions_Pvt.G_Last_Updated_By,
713: Pa_Rbs_Versions_Pvt.G_Creation_Date,
714: Pa_Rbs_Versions_Pvt.G_Created_By,
715: Pa_Rbs_Versions_Pvt.G_Last_Update_Login,
716: 1
717: From
718: Pa_Rbs_Elements_Temp Tmp,
719: Pa_Rbs_Elements Rbs_Elements

Line 826: END Pa_Rbs_Versions_Pvt;

822:
823: End Set_Reporting_Flag;
824:
825:
826: END Pa_Rbs_Versions_Pvt;