APPS.RRS_SITE_GROUPS_PKG dependencies on RRS_SITE_GROUPS_TL

Line 55: insert into RRS_SITE_GROUPS_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into RRS_SITE_GROUPS_TL (
56: SITE_GROUP_ID,
57: NAME,
58: DESCRIPTION,
59: CREATED_BY,

Line 81: from RRS_SITE_GROUPS_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from RRS_SITE_GROUPS_TL T
82: where T.SITE_GROUP_ID = L_SITE_GROUP_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 118: from RRS_SITE_GROUPS_TL

114: cursor c1 is select
115: NAME,
116: DESCRIPTION,
117: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
118: from RRS_SITE_GROUPS_TL
119: where SITE_GROUP_ID = X_SITE_GROUP_ID
120: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
121: for update of SITE_GROUP_ID nowait;
122: begin

Line 187: update RRS_SITE_GROUPS_TL set

183: if (sql%notfound) then
184: raise no_data_found;
185: end if;
186:
187: update RRS_SITE_GROUPS_TL set
188: NAME = X_NAME,
189: DESCRIPTION = X_DESCRIPTION,
190: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
191: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 206: delete from RRS_SITE_GROUPS_TL

202: procedure DELETE_ROW (
203: X_SITE_GROUP_ID in NUMBER
204: ) is
205: begin
206: delete from RRS_SITE_GROUPS_TL
207: where SITE_GROUP_ID = X_SITE_GROUP_ID;
208:
209: if (sql%notfound) then
210: raise no_data_found;

Line 224: delete from RRS_SITE_GROUPS_TL T

220:
221: procedure ADD_LANGUAGE
222: is
223: begin
224: delete from RRS_SITE_GROUPS_TL T
225: where not exists
226: (select NULL
227: from RRS_SITE_GROUPS_B B
228: where B.SITE_GROUP_ID = T.SITE_GROUP_ID

Line 231: update RRS_SITE_GROUPS_TL T set (

227: from RRS_SITE_GROUPS_B B
228: where B.SITE_GROUP_ID = T.SITE_GROUP_ID
229: );
230:
231: update RRS_SITE_GROUPS_TL T set (
232: NAME,
233: DESCRIPTION
234: ) = (select
235: B.NAME,

Line 237: from RRS_SITE_GROUPS_TL B

233: DESCRIPTION
234: ) = (select
235: B.NAME,
236: B.DESCRIPTION
237: from RRS_SITE_GROUPS_TL B
238: where B.SITE_GROUP_ID = T.SITE_GROUP_ID
239: and B.LANGUAGE = T.SOURCE_LANG)
240: where (
241: T.SITE_GROUP_ID,

Line 246: from RRS_SITE_GROUPS_TL SUBB, RRS_SITE_GROUPS_TL SUBT

242: T.LANGUAGE
243: ) in (select
244: SUBT.SITE_GROUP_ID,
245: SUBT.LANGUAGE
246: from RRS_SITE_GROUPS_TL SUBB, RRS_SITE_GROUPS_TL SUBT
247: where SUBB.SITE_GROUP_ID = SUBT.SITE_GROUP_ID
248: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
249: and (SUBB.NAME <> SUBT.NAME
250: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 255: insert into RRS_SITE_GROUPS_TL (

251: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
252: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
253: ));
254:
255: insert into RRS_SITE_GROUPS_TL (
256: SITE_GROUP_ID,
257: NAME,
258: DESCRIPTION,
259: CREATED_BY,

Line 277: from RRS_SITE_GROUPS_TL B, FND_LANGUAGES L

273: B.LAST_UPDATE_DATE,
274: B.LAST_UPDATE_LOGIN,
275: L.LANGUAGE_CODE,
276: B.SOURCE_LANG
277: from RRS_SITE_GROUPS_TL B, FND_LANGUAGES L
278: where L.INSTALLED_FLAG in ('I', 'B')
279: and B.LANGUAGE = userenv('LANG')
280: and not exists
281: (select NULL

Line 282: from RRS_SITE_GROUPS_TL T

278: where L.INSTALLED_FLAG in ('I', 'B')
279: and B.LANGUAGE = userenv('LANG')
280: and not exists
281: (select NULL
282: from RRS_SITE_GROUPS_TL T
283: where T.SITE_GROUP_ID = B.SITE_GROUP_ID
284: and T.LANGUAGE = L.LANGUAGE_CODE);
285: end ADD_LANGUAGE;
286: