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

62: Fnd_Global.Login_Id,
63: 1);
64:
65: --MLS changes incorporated.
66: Insert Into Pa_Rbs_Headers_TL(
67: Rbs_Header_Id,
68: Name,
69: Description,
70: Language,

Line 97: Pa_Rbs_Headers_TL T

93: And Not Exists
94: (Select
95: Null
96: From
97: Pa_Rbs_Headers_TL T
98: WHere
99: T.Rbs_Header_Id = P_RbsHeaderId
100: And T.Language = L.Language_Code);
101:

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

111: -- Purpose : This API will be used to update RBS headers.
112: -- : This API will be called from following package:
113: -- : 1.PA_RBS_HEADER_PVT package,Update_Header procedure
114:
115: -- Note : This API will updates PA_RBS_HEADER_B and PA_RBS_HEADERS_TL table
116:
117: -- Assumptions :
118:
119: -- Parameters Type Required Description and Purpose

Line 151: Update Pa_Rbs_Headers_TL

147: Where
148: Rbs_Header_Id = P_RbsHeaderId;
149:
150: --MLS changes incorporated.
151: Update Pa_Rbs_Headers_TL
152: Set
153: Name = P_Name,
154: Description = P_Description,
155: Last_update_date = SysDate,

Line 172: delete from Pa_Rbs_Headers_TL T

168:
169: procedure ADD_LANGUAGE
170: is
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

Line 179: update Pa_Rbs_Headers_TL T set (

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 (
180: NAME,
181: DESCRIPTION
182: ) = (select
183: B.NAME,

Line 185: from Pa_Rbs_Headers_TL b

181: DESCRIPTION
182: ) = (select
183: B.NAME,
184: B.DESCRIPTION
185: from Pa_Rbs_Headers_TL b
186: where B.Rbs_Header_Id = T.Rbs_Header_Id
187: and B.LANGUAGE = T.SOURCE_LANG)
188: where (
189: T.Rbs_Header_Id,

Line 194: from Pa_Rbs_Headers_TL SUBB, Pa_Rbs_Headers_TL SUBT

190: T.LANGUAGE
191: ) in (select
192: SUBT.Rbs_Header_Id,
193: SUBT.LANGUAGE
194: from Pa_Rbs_Headers_TL SUBB, Pa_Rbs_Headers_TL SUBT
195: where SUBB.Rbs_Header_Id = SUBT.Rbs_Header_Id
196: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
197: and (SUBB.NAME <> SUBT.NAME
198: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 203: insert into Pa_Rbs_Headers_TL (

199: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
200: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
201: ));
202:
203: insert into Pa_Rbs_Headers_TL (
204: LAST_UPDATE_LOGIN,
205: CREATION_DATE,
206: CREATED_BY,
207: LAST_UPDATE_DATE,

Line 225: from Pa_Rbs_Headers_TL B, FND_LANGUAGES L

221: B.NAME,
222: B.DESCRIPTION,
223: L.LANGUAGE_CODE,
224: B.SOURCE_LANG
225: from Pa_Rbs_Headers_TL B, FND_LANGUAGES L
226: where L.INSTALLED_FLAG in ('I', 'B')
227: and B.LANGUAGE = userenv('LANG')
228: and not exists
229: (select NULL

Line 230: from Pa_Rbs_Headers_TL T

226: where L.INSTALLED_FLAG in ('I', 'B')
227: and B.LANGUAGE = userenv('LANG')
228: and not exists
229: (select NULL
230: from Pa_Rbs_Headers_TL T
231: where T.Rbs_Header_Id = B.Rbs_Header_Id
232: and T.LANGUAGE = L.LANGUAGE_CODE);
233: end ADD_LANGUAGE;
234: