APPS.PA_RBS_HEADERS_PKG dependencies on PA_RBS_HEADERS_TL

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 72: Insert Into Pa_Rbs_Headers_TL(

68: Fnd_Global.Login_Id,
69: 1);
70:
71: --MLS changes incorporated.
72: Insert Into Pa_Rbs_Headers_TL(
73: Rbs_Header_Id,
74: Name,
75: Description,
76: Language,

Line 103: Pa_Rbs_Headers_TL T

99: And Not Exists
100: (Select
101: Null
102: From
103: Pa_Rbs_Headers_TL T
104: WHere
105: T.Rbs_Header_Id = P_RbsHeaderId
106: And T.Language = L.Language_Code);
107:

Line 121: -- Note : This API will updates PA_RBS_HEADER_B and PA_RBS_HEADERS_TL table

117: -- Purpose : This API will be used to update RBS headers.
118: -- : This API will be called from following package:
119: -- : 1.PA_RBS_HEADER_PVT package,Update_Header procedure
120:
121: -- Note : This API will updates PA_RBS_HEADER_B and PA_RBS_HEADERS_TL table
122:
123: -- Assumptions :
124:
125: -- Parameters Type Required Description and Purpose

Line 159: Update Pa_Rbs_Headers_TL

155: Where
156: Rbs_Header_Id = P_RbsHeaderId;
157:
158: --MLS changes incorporated.
159: Update Pa_Rbs_Headers_TL
160: Set
161: Name = P_Name,
162: Description = P_Description,
163: Last_update_date = SysDate,

Line 180: delete from Pa_Rbs_Headers_TL T

176:
177: procedure ADD_LANGUAGE
178: is
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

Line 187: update Pa_Rbs_Headers_TL T set (

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 (
188: NAME,
189: DESCRIPTION
190: ) = (select
191: B.NAME,

Line 193: from Pa_Rbs_Headers_TL b

189: DESCRIPTION
190: ) = (select
191: B.NAME,
192: B.DESCRIPTION
193: from Pa_Rbs_Headers_TL b
194: where B.Rbs_Header_Id = T.Rbs_Header_Id
195: and B.LANGUAGE = T.SOURCE_LANG)
196: where (
197: T.Rbs_Header_Id,

Line 202: from Pa_Rbs_Headers_TL SUBB, Pa_Rbs_Headers_TL SUBT

198: T.LANGUAGE
199: ) in (select
200: SUBT.Rbs_Header_Id,
201: SUBT.LANGUAGE
202: from Pa_Rbs_Headers_TL SUBB, Pa_Rbs_Headers_TL SUBT
203: where SUBB.Rbs_Header_Id = SUBT.Rbs_Header_Id
204: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
205: and (SUBB.NAME <> SUBT.NAME
206: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 211: insert into Pa_Rbs_Headers_TL (

207: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
208: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
209: ));
210:
211: insert into Pa_Rbs_Headers_TL (
212: LAST_UPDATE_LOGIN,
213: CREATION_DATE,
214: CREATED_BY,
215: LAST_UPDATE_DATE,

Line 233: from Pa_Rbs_Headers_TL B, FND_LANGUAGES L

229: B.NAME,
230: B.DESCRIPTION,
231: L.LANGUAGE_CODE,
232: B.SOURCE_LANG
233: from Pa_Rbs_Headers_TL B, FND_LANGUAGES L
234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL

Line 238: from Pa_Rbs_Headers_TL T

234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL
238: from Pa_Rbs_Headers_TL T
239: where T.Rbs_Header_Id = B.Rbs_Header_Id
240: and T.LANGUAGE = L.LANGUAGE_CODE);
241: end ADD_LANGUAGE;
242: