APPS.PA_RBS_VERSIONS_PUB dependencies on PA_RBS_VERSIONS_B

Line 61: Pa_Rbs_Versions_B

57: Select
58: Status_Code,
59: Job_Group_Id
60: From
61: Pa_Rbs_Versions_B
62: Where
63: Rbs_Version_Id = P_Rbs_Version_Id
64: And Status_Code = 'WORKING'
65: And Record_Version_Number = P_Rec_Num

Line 79: Pa_Rbs_Versions_B V

75: TL.Name
76: From
77: Pa_Rbs_Headers_B H,
78: Pa_Rbs_Headers_TL TL,
79: Pa_Rbs_Versions_B V
80: Where
81: TL.Rbs_Header_Id = H.Rbs_Header_Id
82: And UserEnv('LANG') in (TL.Language, TL.Source_Lang)
83: And H.Rbs_Header_Id = V.Rbs_Header_Id

Line 92: Pa_Rbs_Versions_B

88: Cursor GetLatestFrozenRbsVersionId(P_Id IN Number) Is
89: Select
90: Max(Rbs_Version_Id)
91: From
92: Pa_Rbs_Versions_B
93: Where
94: Rbs_Header_Id = P_Id
95: And Status_Code <> 'WORKING';
96:

Line 102: Pa_Rbs_Versions_B

98: Select
99: Version_Start_Date,
100: Version_End_Date
101: From
102: Pa_Rbs_Versions_B
103: Where
104: Rbs_Version_Id = P_Id;
105:
106: l_Prior_Rbs_Ver_Id Number(15) := Null;

Line 631: Pa_Rbs_Versions_B

627: Cursor GetLatestFrozenRbsVersionId(l_Rbs_Header_Id IN Number) Is
628: Select
629: Max(Rbs_Version_Id)
630: From
631: Pa_Rbs_Versions_B
632: Where
633: Rbs_Header_Id = l_Rbs_Header_Id
634: And Status_Code <> 'WORKING';
635:

Line 641: Pa_Rbs_Versions_B

637: Select
638: Version_Start_Date,
639: Nvl(Version_End_Date,SysDate) Version_End_Date
640: From
641: Pa_Rbs_Versions_B
642: Where
643: Rbs_Version_Id = P_Rbs_Ver_Id;
644:
645: l_Ver_Dates_Rec c_GetVersionDates%RowType;

Line 651: Pa_Rbs_Versions_B

647: Cursor c_Record_Ver_No is
648: Select
649: Record_Version_Number
650: From
651: Pa_Rbs_Versions_B
652: Where
653: Rbs_Version_Id = P_Rbs_Version_Id
654: For Update Of Version_Start_Date NoWait;
655:

Line 742: Pa_Rbs_Versions_B

738: Into
739: l_Version_Start_Date,
740: l_Rbs_Header_Id
741: From
742: Pa_Rbs_Versions_B
743: Where
744: Rbs_Version_Id = P_Rbs_Version_Id;
745:
746: --commented out since checking of this flag is not needed to copy hierarchy of elements when we freeze a version

Line 932: Update Pa_Rbs_Versions_B

928:
929: End IF; --End of changes made for bug 3659078. modified for bug 3703364
930:
931: Pa_Debug.G_Stage := 'Mark the working version as frozen.';
932: Update Pa_Rbs_Versions_B
933: Set
934: Status_code = 'FROZEN'
935: Where
936: Rbs_Version_Id = P_Rbs_Version_Id;

Line 960: Update Pa_Rbs_Versions_B

956:
957: End If;
958:
959:
960: Update Pa_Rbs_Versions_B
961: Set
962: Version_End_Date = l_end_date
963: Where
964: Rbs_Version_Id = l_Latest_Freezed_Version_Id;

Line 979: FROM pa_rbs_versions_b

975: ******************************************************************/
976: BEGIN
977: SELECT count(*)
978: INTO l_count
979: FROM pa_rbs_versions_b
980: where rbs_header_id = l_rbs_header_id;
981: EXCEPTION
982: WHEN OTHERS THEN
983: l_count := 0;

Line 987: Update pa_rbs_versions_b

983: l_count := 0;
984: END;
985:
986: IF l_count = 1 THEN
987: Update pa_rbs_versions_b
988: Set current_reporting_flag = 'Y'
989: where rbs_version_id = p_rbs_version_id;
990: END IF;
991:

Line 1003: UPDATE pa_rbs_versions_b

999: FROM pa_rbs_prj_assignments
1000: WHERE rbs_header_id = l_rbs_header_id;
1001:
1002: IF l_assoc_count = 0 THEN
1003: UPDATE pa_rbs_versions_b
1004: SET current_reporting_flag = 'Y'
1005: WHERE rbs_version_id = p_rbs_version_id;
1006:
1007: UPDATE pa_rbs_versions_b

Line 1007: UPDATE pa_rbs_versions_b

1003: UPDATE pa_rbs_versions_b
1004: SET current_reporting_flag = 'Y'
1005: WHERE rbs_version_id = p_rbs_version_id;
1006:
1007: UPDATE pa_rbs_versions_b
1008: SET current_reporting_flag = NULL
1009: WHERE rbs_header_id = l_rbs_header_id
1010: AND rbs_version_id <> p_rbs_version_id;
1011: