DBA Data[Home] [Help]

APPS.PA_RBS_VERSIONS_PKG dependencies on PA_RBS_VERSIONS_B

Line 37: Pa_RBS_Versions_B

33: Cursor Return_RowId(P_Id IN Number) is
34: Select
35: RowId
36: From
37: Pa_RBS_Versions_B
38: Where
39: RBS_Version_Id = P_Id;
40:
41: Cursor GetNextId is

Line 64: Insert Into Pa_Rbs_Versions_B (

60: Open GetNextId;
61: Fetch GetNextId Into X_Rbs_Version_Id;
62: Close GetNextId;
63:
64: Insert Into Pa_Rbs_Versions_B (
65: Rbs_Version_Id,
66: Version_Number,
67: Rbs_Header_Id,
68: Version_Start_Date,

Line 184: Update Pa_RBS_Versions_B

180: REC_VER_NUM_MISMATCH Exception;
181:
182: Begin
183:
184: Update Pa_RBS_Versions_B
185: Set Version_Start_Date = P_Version_Start_Date,
186: Job_Group_Id = P_Job_Group_Id,
187: Record_Version_Number = Record_Version_Number + 1,
188: Last_Update_Date = P_Last_Update_Date,

Line 246: Pa_Rbs_Versions_B

242: Begin
243:
244: Delete
245: From
246: Pa_Rbs_Versions_B
247: Where
248: RBS_Version_Id = P_RBS_Version_Id
249: And Record_Version_Number = P_Record_Version_Number;
250:

Line 278: from pa_rbs_versions_b B

274: begin
275: delete from pa_rbs_versions_tl T
276: where not exists
277: (select NULL
278: from pa_rbs_versions_b B
279: where B.RBS_VERSION_ID = T.RBS_VERSION_ID
280: );
281:
282: update pa_rbs_versions_tl T set (