APPS.PA_RBS_HEADER_PVT dependencies on PA_RBS_VERSIONS_TL

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

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

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

189: l_Last_Updated_By,
190: l_Last_Update_Login,
191: 1 );
192:
193: Pa_Debug.G_Stage := 'Insert working versions into Pa_Rbs_Versions_TL table directly here.';
194: Insert Into Pa_Rbs_Versions_TL(
195: Rbs_Version_Id,
196: Name,
197: Description,

Line 194: Insert Into Pa_Rbs_Versions_TL(

190: l_Last_Update_Login,
191: 1 );
192:
193: Pa_Debug.G_Stage := 'Insert working versions into Pa_Rbs_Versions_TL table directly here.';
194: Insert Into Pa_Rbs_Versions_TL(
195: Rbs_Version_Id,
196: Name,
197: Description,
198: Language,

Line 225: Pa_Rbs_Versions_TL T

221: And Not Exists
222: (Select
223: Null
224: From
225: Pa_Rbs_Versions_TL T
226: Where
227: T.Rbs_Version_Id=X_Rbs_Version_Id
228: And
229: T.Language=L.Language_Code);

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

466: -- Purpose : This API will be used to update working version for the RBS header.
467: -- : This API will be called from following package:
468: -- : 1.PA_RBS_HEADER_PUB package,Update_Header procedure
469:
470: -- Note : This API will Updates working version for Rbs header in PA_RBS_VERSIONS_B and PA_RBS_VERSIONS_TL table.
471:
472: -- Assumptions :
473:
474: -- Parameters Type Required Description and Purpose

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

547: Raise No_Data_Found;
548:
549: End If;
550:
551: Pa_Debug.G_Stage := 'Directly update the pa_rbs_versions_tl table.';
552: Update Pa_Rbs_Versions_TL
553: Set
554: Name = P_Name,
555: Description = Nvl(Description,P_Description),

Line 552: Update Pa_Rbs_Versions_TL

548:
549: End If;
550:
551: Pa_Debug.G_Stage := 'Directly update the pa_rbs_versions_tl table.';
552: Update Pa_Rbs_Versions_TL
553: Set
554: Name = P_Name,
555: Description = Nvl(Description,P_Description),
556: Last_Update_Date = l_Last_Update_Date,