APPS.RRS_SITESTH_PKG dependencies on RRS_SITES_TL

Line 90: insert into RRS_SITES_TL (

86: X_LAST_UPDATE_LOGIN,
87: X_ORGANIZATION_ID
88: );
89:
90: insert into RRS_SITES_TL (
91: SITE_ID,
92: NAME,
93: CREATED_BY,
94: CREATION_DATE,

Line 116: from RRS_SITES_TL T

112: from FND_LANGUAGES L
113: where L.INSTALLED_FLAG in ('I', 'B')
114: and not exists
115: (select NULL
116: from RRS_SITES_TL T
117: where T.SITE_ID = l_site_id
118: and T.LANGUAGE = L.LANGUAGE_CODE);
119:
120: open c;

Line 177: from RRS_SITES_TL

173: cursor c1 is select
174: NAME,
175: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG,
176: DESCRIPTION
177: from RRS_SITES_TL
178: where SITE_ID = X_SITE_ID
179: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
180: for update of SITE_ID nowait;
181: begin

Line 293: update RRS_SITES_TL set

289: if (sql%notfound) then
290: raise no_data_found;
291: end if;
292:
293: update RRS_SITES_TL set
294: NAME = X_NAME,
295: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
296: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
297: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 312: delete from RRS_SITES_TL

308: procedure DELETE_ROW (
309: X_SITE_ID in NUMBER
310: ) is
311: begin
312: delete from RRS_SITES_TL
313: where SITE_ID = X_SITE_ID;
314:
315: if (sql%notfound) then
316: raise no_data_found;

Line 330: delete from RRS_SITES_TL T

326:
327: procedure ADD_LANGUAGE
328: is
329: begin
330: delete from RRS_SITES_TL T
331: where not exists
332: (select NULL
333: from RRS_SITES_B B
334: where B.SITE_ID = T.SITE_ID

Line 337: update RRS_SITES_TL T set (

333: from RRS_SITES_B B
334: where B.SITE_ID = T.SITE_ID
335: );
336:
337: update RRS_SITES_TL T set (
338: NAME,
339: DESCRIPTION
340: ) = (select
341: B.NAME,

Line 343: from RRS_SITES_TL B

339: DESCRIPTION
340: ) = (select
341: B.NAME,
342: B.DESCRIPTION
343: from RRS_SITES_TL B
344: where B.SITE_ID = T.SITE_ID
345: and B.LANGUAGE = T.SOURCE_LANG)
346: where (
347: T.SITE_ID,

Line 352: from RRS_SITES_TL SUBB, RRS_SITES_TL SUBT

348: T.LANGUAGE
349: ) in (select
350: SUBT.SITE_ID,
351: SUBT.LANGUAGE
352: from RRS_SITES_TL SUBB, RRS_SITES_TL SUBT
353: where SUBB.SITE_ID = SUBT.SITE_ID
354: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
355: and (SUBB.NAME <> SUBT.NAME
356: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 361: insert into RRS_SITES_TL (

357: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
358: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
359: ));
360:
361: insert into RRS_SITES_TL (
362: SITE_ID,
363: NAME,
364: CREATED_BY,
365: CREATION_DATE,

Line 383: from RRS_SITES_TL B, FND_LANGUAGES L

379: B.LAST_UPDATE_LOGIN,
380: L.LANGUAGE_CODE,
381: B.SOURCE_LANG,
382: B.DESCRIPTION
383: from RRS_SITES_TL B, FND_LANGUAGES L
384: where L.INSTALLED_FLAG in ('I', 'B')
385: and B.LANGUAGE = userenv('LANG')
386: and not exists
387: (select NULL

Line 388: from RRS_SITES_TL T

384: where L.INSTALLED_FLAG in ('I', 'B')
385: and B.LANGUAGE = userenv('LANG')
386: and not exists
387: (select NULL
388: from RRS_SITES_TL T
389: where T.SITE_ID = B.SITE_ID
390: and T.LANGUAGE = L.LANGUAGE_CODE);
391: end ADD_LANGUAGE;
392: