APPS.PA_RBS_HEADER_PVT dependencies on PA_RBS_VERSIONS_B

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 163: Pa_Debug.G_Stage := 'Insert a working version into Pa_Rbs_Versions_B table directly here.';

159: Open c_Rbs_Version_Id_Seq;
160: Fetch c_Rbs_Version_Id_Seq Into X_Rbs_Version_Id;
161: Close c_Rbs_Version_Id_Seq;
162:
163: Pa_Debug.G_Stage := 'Insert a working version into Pa_Rbs_Versions_B table directly here.';
164: Insert Into Pa_Rbs_Versions_B(
165: Rbs_Header_Id,
166: Rbs_Version_Id,
167: Version_Number,

Line 164: Insert Into Pa_Rbs_Versions_B(

160: Fetch c_Rbs_Version_Id_Seq Into X_Rbs_Version_Id;
161: Close c_Rbs_Version_Id_Seq;
162:
163: Pa_Debug.G_Stage := 'Insert a working version into Pa_Rbs_Versions_B table directly here.';
164: Insert Into Pa_Rbs_Versions_B(
165: Rbs_Header_Id,
166: Rbs_Version_Id,
167: Version_Number,
168: Version_Start_Date,

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 517: Pa_Rbs_Versions_B

513: Rbs_Version_Id
514: Into
515: l_Rbs_Version_Id
516: From
517: Pa_Rbs_Versions_B
518: Where
519: Rbs_Header_Id = P_RbsHeaderId
520: And Status_Code = 'WORKING';
521:

Line 530: Update Pa_Rbs_Versions_B

526:
527: End If;
528:
529: Pa_Debug.G_Stage := 'Directly update the rbs working version.';
530: Update Pa_Rbs_Versions_B
531: Set
532: Version_Start_Date = P_EffectiveFrom,
533: Last_Update_Date = l_Last_Update_Date,
534: Last_Updated_By = l_Last_Updated_By,

Line 612: Pa_Rbs_Versions_b Verb,

608: /* Checking PA_RBS_ELEMENTS */
609:
610: Select count(*) INTO l_count
611: From
612: Pa_Rbs_Versions_b Verb,
613: Pa_Rbs_Elements ele
614: Where
615: Verb.rbs_header_id=P_RBS_ID
616: And