APPS.PA_RBS_HEADER_PVT dependencies on PA_RBS_VERSIONS_B

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

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

Line 168: Insert Into Pa_Rbs_Versions_B(

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

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

519: Rbs_Version_Id
520: Into
521: l_Rbs_Version_Id
522: From
523: Pa_Rbs_Versions_B
524: Where
525: Rbs_Header_Id = P_RbsHeaderId
526: And Status_Code = 'WORKING';
527:

Line 536: Update Pa_Rbs_Versions_B

532:
533: End If;
534:
535: Pa_Debug.G_Stage := 'Directly update the rbs working version.';
536: Update Pa_Rbs_Versions_B
537: Set
538: Version_Start_Date = P_EffectiveFrom,
539: Last_Update_Date = l_Last_Update_Date,
540: Last_Updated_By = l_Last_Updated_By,

Line 618: Pa_Rbs_Versions_b Verb,

614: /* Checking PA_RBS_ELEMENTS */
615:
616: Select count(*) INTO l_count
617: From
618: Pa_Rbs_Versions_b Verb,
619: Pa_Rbs_Elements ele
620: Where
621: Verb.rbs_header_id=P_RBS_ID
622: And