APPS.PA_RBS_VERSIONS_PKG dependencies on PA_RBS_VERSIONS_TL

Line 100: Insert Into Pa_Rbs_Versions_TL (

96: P_Created_By,
97: P_Last_Update_Login,
98: X_Record_Version_Number );
99:
100: Insert Into Pa_Rbs_Versions_TL (
101: Rbs_Version_Id,
102: Name,
103: Description,
104: Creation_Date,

Line 130: Pa_Rbs_Versions_TL T

126: And Not Exists
127: (select
128: Null
129: From
130: Pa_Rbs_Versions_TL T
131: Where
132: T.Rbs_Version_Id = X_Rbs_Version_Id
133: and T.Language = L.Language_Code);
134:

Line 204: Update Pa_Rbs_Versions_TL

200: If Sql%NotFound Then
201: Raise REC_VER_NUM_MISMATCH;
202: End If;
203:
204: Update Pa_Rbs_Versions_TL
205: Set Name = P_Name,
206: Description = P_Description,
207: Last_Update_Date = P_Last_Update_Date,
208: Last_Updated_By = P_Last_Updated_By,

Line 263: Pa_Rbs_Versions_TL

259:
260:
261: Delete
262: From
263: Pa_Rbs_Versions_TL
264: Where
265: Rbs_Version_Id = P_Rbs_Version_Id;
266:
267: Exception

Line 280: delete from pa_rbs_versions_tl T

276:
277: procedure ADD_LANGUAGE
278: is
279: begin
280: delete from pa_rbs_versions_tl T
281: where not exists
282: (select NULL
283: from pa_rbs_versions_b B
284: where B.RBS_VERSION_ID = T.RBS_VERSION_ID

Line 287: update pa_rbs_versions_tl T set (

283: from pa_rbs_versions_b B
284: where B.RBS_VERSION_ID = T.RBS_VERSION_ID
285: );
286:
287: update pa_rbs_versions_tl T set (
288: NAME,
289: DESCRIPTION
290: ) = (select
291: B.NAME,

Line 293: from pa_rbs_versions_tl b

289: DESCRIPTION
290: ) = (select
291: B.NAME,
292: B.DESCRIPTION
293: from pa_rbs_versions_tl b
294: where B.RBS_VERSION_ID = T.RBS_VERSION_ID
295: and B.LANGUAGE = T.SOURCE_LANG)
296: where (
297: T.RBS_VERSION_ID,

Line 302: from pa_rbs_versions_tl SUBB, pa_rbs_versions_tl SUBT

298: T.LANGUAGE
299: ) in (select
300: SUBT.RBS_VERSION_ID,
301: SUBT.LANGUAGE
302: from pa_rbs_versions_tl SUBB, pa_rbs_versions_tl SUBT
303: where SUBB.RBS_VERSION_ID = SUBT.RBS_VERSION_ID
304: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
305: and (SUBB.NAME <> SUBT.NAME
306: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 311: insert into pa_rbs_versions_tl (

307: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
308: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
309: ));
310:
311: insert into pa_rbs_versions_tl (
312: LAST_UPDATE_LOGIN,
313: CREATION_DATE,
314: CREATED_BY,
315: LAST_UPDATE_DATE,

Line 333: from pa_rbs_versions_tl B, FND_LANGUAGES L

329: B.NAME,
330: B.DESCRIPTION,
331: L.LANGUAGE_CODE,
332: B.SOURCE_LANG
333: from pa_rbs_versions_tl B, FND_LANGUAGES L
334: where L.INSTALLED_FLAG in ('I', 'B')
335: and B.LANGUAGE = userenv('LANG')
336: and not exists
337: (select NULL

Line 338: from pa_rbs_versions_tl T

334: where L.INSTALLED_FLAG in ('I', 'B')
335: and B.LANGUAGE = userenv('LANG')
336: and not exists
337: (select NULL
338: from pa_rbs_versions_tl T
339: where T.RBS_VERSION_ID = B.RBS_VERSION_ID
340: and T.LANGUAGE = L.LANGUAGE_CODE);
341: end ADD_LANGUAGE;
342: