APPS.PA_RBS_HEADERS_PKG dependencies on PA_RBS_HEADERS_B

Line 14: -- Note : This API will make insert into PA_RBS_HEADERS_B and PA_RBS_HEADERS_TL table

10: -- Purpose : This API will create new RBS headers.
11: -- : This API will be called from following package:
12: -- : 1.PA_RBS_HEADER_PVT package,Insert_Header procedure
13:
14: -- Note : This API will make insert into PA_RBS_HEADERS_B and PA_RBS_HEADERS_TL table
15:
16: -- Assumptions :
17:
18: -- Parameters Type Required Description and Purpose

Line 42: Insert Into Pa_Rbs_Headers_B(

38: P_BusinessGroupId IN Number)
39: IS
40: BEGIN
41:
42: Insert Into Pa_Rbs_Headers_B(
43: Rbs_Header_Id,
44: Effective_From_Date,
45: Effective_To_Date,
46: Business_Group_Id,

Line 146: Update Pa_Rbs_Headers_B

142: Is
143:
144: Begin
145:
146: Update Pa_Rbs_Headers_B
147: Set Effective_From_Date = Nvl(P_EffectiveFrom,Effective_From_Date),
148: Effective_To_Date = P_EffectiveTo,
149: Use_For_Alloc_Flag = P_Use_For_Alloc_Flag,
150: Last_Update_Date = SysDate,

Line 183: from Pa_Rbs_Headers_b B

179: begin
180: delete from Pa_Rbs_Headers_TL T
181: where not exists
182: (select NULL
183: from Pa_Rbs_Headers_b B
184: where B.Rbs_Header_Id = T.Rbs_Header_Id
185: );
186:
187: update Pa_Rbs_Headers_TL T set (