APPS.PA_RBS_HEADER_PVT dependencies on PA_RBS_VERSIONS_TL

Line 116: -- Note : This API will insert a record into PA_RBS_VERSIONS_B and PA_RBS_VERSIONS_TL table which is the working version.

112: -- Purpose : This API will be used to create working version for the RBS header.
113: -- : This API will be called from following package:
114: -- : 1.PA_RBS_HEADER_PUB package,Insert_Header procedure
115:
116: -- Note : This API will insert a record into PA_RBS_VERSIONS_B and PA_RBS_VERSIONS_TL table which is the working version.
117:
118: -- Assumptions :
119:
120: -- Parameters Type Required Description and Purpose

Line 197: Pa_Debug.G_Stage := 'Insert working versions into Pa_Rbs_Versions_TL table directly here.';

193: l_Last_Updated_By,
194: l_Last_Update_Login,
195: 1 );
196:
197: Pa_Debug.G_Stage := 'Insert working versions into Pa_Rbs_Versions_TL table directly here.';
198: Insert Into Pa_Rbs_Versions_TL(
199: Rbs_Version_Id,
200: Name,
201: Description,

Line 198: Insert Into Pa_Rbs_Versions_TL(

194: l_Last_Update_Login,
195: 1 );
196:
197: Pa_Debug.G_Stage := 'Insert working versions into Pa_Rbs_Versions_TL table directly here.';
198: Insert Into Pa_Rbs_Versions_TL(
199: Rbs_Version_Id,
200: Name,
201: Description,
202: Language,

Line 229: Pa_Rbs_Versions_TL T

225: And Not Exists
226: (Select
227: Null
228: From
229: Pa_Rbs_Versions_TL T
230: Where
231: T.Rbs_Version_Id=X_Rbs_Version_Id
232: And
233: T.Language=L.Language_Code);

Line 476: -- Note : This API will Updates working version for Rbs header in PA_RBS_VERSIONS_B and PA_RBS_VERSIONS_TL table.

472: -- Purpose : This API will be used to update working version for the RBS header.
473: -- : This API will be called from following package:
474: -- : 1.PA_RBS_HEADER_PUB package,Update_Header procedure
475:
476: -- Note : This API will Updates working version for Rbs header in PA_RBS_VERSIONS_B and PA_RBS_VERSIONS_TL table.
477:
478: -- Assumptions :
479:
480: -- Parameters Type Required Description and Purpose

Line 557: Pa_Debug.G_Stage := 'Directly update the pa_rbs_versions_tl table.';

553: Raise No_Data_Found;
554:
555: End If;
556:
557: Pa_Debug.G_Stage := 'Directly update the pa_rbs_versions_tl table.';
558: Update Pa_Rbs_Versions_TL
559: Set
560: Name = P_Name,
561: Description = Nvl(Description,P_Description),

Line 558: Update Pa_Rbs_Versions_TL

554:
555: End If;
556:
557: Pa_Debug.G_Stage := 'Directly update the pa_rbs_versions_tl table.';
558: Update Pa_Rbs_Versions_TL
559: Set
560: Name = P_Name,
561: Description = Nvl(Description,P_Description),
562: Last_Update_Date = l_Last_Update_Date,