APPS.PA_RBS_VERSIONS_PVT dependencies on PA_RBS_VERSIONS_B

Line 289: Pa_Rbs_Versions_B

285: Job_Group_Id,
286: Rule_Based_Flag,
287: Version_End_Date
288: From
289: Pa_Rbs_Versions_B
290: Where
291: Rbs_Version_Id = P_Id;
292:
293: Cursor GetDetails2(P_Id IN Number) Is

Line 312: Pa_Rbs_Versions_B

308: Select
309: Record_Version_Number,
310: Rbs_Version_Id
311: From
312: Pa_Rbs_Versions_B
313: Where
314: Rbs_Header_Id = P_Rbs_Header_Id
315: And Status_Code = 'WORKING'
316: For Update Of Status_Code NoWait;

Line 322: Pa_Rbs_Versions_B

318: Cursor GetMaxFrozenRbsVersionId(P_Id IN Number) Is
319: Select
320: Max(Rbs_Version_Id)
321: From
322: Pa_Rbs_Versions_B
323: Where
324: Rbs_Header_Id = P_Rbs_Header_Id
325: And Status_Code <> 'WORKING';
326:

Line 372: Pa_Debug.G_Stage := 'Get details from record in pa_rbs_versions_b to copy from.';

368: l_Rbs_Version_From_Id := P_Rbs_Version_Id;
369:
370: End If;
371:
372: Pa_Debug.G_Stage := 'Get details from record in pa_rbs_versions_b to copy from.';
373: /* To get the details of selected version*/
374: Open GetDetails(l_Rbs_Version_From_Id);
375: Fetch GetDetails Into GetDetails_Rec;
376: If GetDetails%NotFound Then

Line 394: Pa_Debug.G_Stage := 'Get working version record data from pa_rbs_versions_b.';

390: Close GetDetails2;
391:
392: End If;
393:
394: Pa_Debug.G_Stage := 'Get working version record data from pa_rbs_versions_b.';
395: Open C;
396: Fetch C Into l_rvn, l_Rbs_Version_Id;
397: Close C;
398:

Line 470: Pa_Rbs_Versions_B

466: Nvl(Max(Version_Number),0) + 1
467: Into
468: l_Version_Number
469: From
470: Pa_Rbs_Versions_B
471: Where
472: Rbs_Header_Id = P_Rbs_Header_Id;
473:
474: Pa_Debug.G_Stage := 'Get the Rbs Name from pa_rbs_headers_tl.';

Line 786: Pa_Rbs_Versions_B

782: Rbs_Header_Id
783: Into
784: l_Rbs_Header_Id
785: From
786: Pa_Rbs_Versions_B
787: Where
788: Rbs_Version_Id = P_Rbs_Version_Id;
789:
790: Exception

Line 797: Pa_Rbs_Versions_B

793: Return;
794: End;
795:
796: Update
797: Pa_Rbs_Versions_B
798: Set
799: Current_Reporting_Flag = Null
800: Where
801: Rbs_Header_Id = l_Rbs_Header_Id;

Line 804: Pa_Rbs_Versions_B

800: Where
801: Rbs_Header_Id = l_Rbs_Header_Id;
802:
803: Update
804: Pa_Rbs_Versions_B
805: Set
806: Current_Reporting_Flag = 'Y'
807: Where
808: Rbs_Header_Id = l_Rbs_Header_Id