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 40: Insert Into Pa_Rbs_Headers_B(

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

Line 139: Update Pa_Rbs_Headers_B

135: Is
136:
137: Begin
138:
139: Update Pa_Rbs_Headers_B
140: Set Effective_From_Date = Nvl(P_EffectiveFrom,Effective_From_Date),
141: Effective_To_Date = P_EffectiveTo,
142: Use_For_Alloc_Flag = P_Use_For_Alloc_Flag,
143: Last_Update_Date = SysDate,

Line 175: from Pa_Rbs_Headers_b B

171: begin
172: delete from Pa_Rbs_Headers_TL T
173: where not exists
174: (select NULL
175: from Pa_Rbs_Headers_b B
176: where B.Rbs_Header_Id = T.Rbs_Header_Id
177: );
178:
179: update Pa_Rbs_Headers_TL T set (