APPS.PA_RBS_VERSIONS_PVT dependencies on PA_RBS_VERSIONS_B

Line 294: Pa_Rbs_Versions_B

290: Rule_Based_Flag,
291: Version_End_Date,
292: RESOURCE_CLASS_FLAG --Added for CBS::13535688
293: From
294: Pa_Rbs_Versions_B
295: Where
296: Rbs_Version_Id = P_Id;
297:
298: Cursor GetDetails2(P_Id IN Number) Is

Line 317: Pa_Rbs_Versions_B

313: Select
314: Record_Version_Number,
315: Rbs_Version_Id
316: From
317: Pa_Rbs_Versions_B
318: Where
319: Rbs_Header_Id = P_Rbs_Header_Id
320: And Status_Code = 'WORKING'
321: For Update Of Status_Code NoWait;

Line 327: Pa_Rbs_Versions_B

323: Cursor GetMaxFrozenRbsVersionId(P_Id IN Number) Is
324: Select
325: Max(Rbs_Version_Id)
326: From
327: Pa_Rbs_Versions_B
328: Where
329: Rbs_Header_Id = P_Rbs_Header_Id
330: And Status_Code <> 'WORKING';
331:

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

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

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

395: Close GetDetails2;
396:
397: End If;
398:
399: Pa_Debug.G_Stage := 'Get working version record data from pa_rbs_versions_b.';
400: Open C;
401: Fetch C Into l_rvn, l_Rbs_Version_Id;
402: Close C;
403:

Line 475: Pa_Rbs_Versions_B

471: Nvl(Max(Version_Number),0) + 1
472: Into
473: l_Version_Number
474: From
475: Pa_Rbs_Versions_B
476: Where
477: Rbs_Header_Id = P_Rbs_Header_Id;
478:
479: Pa_Debug.G_Stage := 'Get the Rbs Name from pa_rbs_headers_tl.';

Line 793: Pa_Rbs_Versions_B

789: Rbs_Header_Id
790: Into
791: l_Rbs_Header_Id
792: From
793: Pa_Rbs_Versions_B
794: Where
795: Rbs_Version_Id = P_Rbs_Version_Id;
796:
797: Exception

Line 804: Pa_Rbs_Versions_B

800: Return;
801: End;
802:
803: Update
804: Pa_Rbs_Versions_B
805: Set
806: Current_Reporting_Flag = Null
807: Where
808: Rbs_Header_Id = l_Rbs_Header_Id;

Line 811: Pa_Rbs_Versions_B

807: Where
808: Rbs_Header_Id = l_Rbs_Header_Id;
809:
810: Update
811: Pa_Rbs_Versions_B
812: Set
813: Current_Reporting_Flag = 'Y'
814: Where
815: Rbs_Header_Id = l_Rbs_Header_Id