APPS.RRS_SITE_GROUP_NODES_PKG dependencies on RRS_SITE_GROUP_NODES_TL

Line 46: insert into RRS_SITE_GROUP_NODES_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into RRS_SITE_GROUP_NODES_TL (
47: SITE_GROUP_NODE_ID,
48: NAME,
49: DESCRIPTION,
50: CREATED_BY,

Line 72: from RRS_SITE_GROUP_NODES_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from RRS_SITE_GROUP_NODES_TL T
73: where T.SITE_GROUP_NODE_ID = L_SITE_GROUP_NODE_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 103: from RRS_SITE_GROUP_NODES_TL

99: cursor c1 is select
100: NAME,
101: DESCRIPTION,
102: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
103: from RRS_SITE_GROUP_NODES_TL
104: where SITE_GROUP_NODE_ID = X_SITE_GROUP_NODE_ID
105: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
106: for update of SITE_GROUP_NODE_ID nowait;
107: begin

Line 162: update RRS_SITE_GROUP_NODES_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update RRS_SITE_GROUP_NODES_TL set
163: NAME = X_NAME,
164: DESCRIPTION = X_DESCRIPTION,
165: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 181: delete from RRS_SITE_GROUP_NODES_TL

177: procedure DELETE_ROW (
178: X_SITE_GROUP_NODE_ID in NUMBER
179: ) is
180: begin
181: delete from RRS_SITE_GROUP_NODES_TL
182: where SITE_GROUP_NODE_ID = X_SITE_GROUP_NODE_ID;
183:
184: if (sql%notfound) then
185: raise no_data_found;

Line 199: delete from RRS_SITE_GROUP_NODES_TL T

195:
196: procedure ADD_LANGUAGE
197: is
198: begin
199: delete from RRS_SITE_GROUP_NODES_TL T
200: where not exists
201: (select NULL
202: from RRS_SITE_GROUP_NODES_B B
203: where B.SITE_GROUP_NODE_ID = T.SITE_GROUP_NODE_ID

Line 206: update RRS_SITE_GROUP_NODES_TL T set (

202: from RRS_SITE_GROUP_NODES_B B
203: where B.SITE_GROUP_NODE_ID = T.SITE_GROUP_NODE_ID
204: );
205:
206: update RRS_SITE_GROUP_NODES_TL T set (
207: NAME,
208: DESCRIPTION
209: ) = (select
210: B.NAME,

Line 212: from RRS_SITE_GROUP_NODES_TL B

208: DESCRIPTION
209: ) = (select
210: B.NAME,
211: B.DESCRIPTION
212: from RRS_SITE_GROUP_NODES_TL B
213: where B.SITE_GROUP_NODE_ID = T.SITE_GROUP_NODE_ID
214: and B.LANGUAGE = T.SOURCE_LANG)
215: where (
216: T.SITE_GROUP_NODE_ID,

Line 221: from RRS_SITE_GROUP_NODES_TL SUBB, RRS_SITE_GROUP_NODES_TL SUBT

217: T.LANGUAGE
218: ) in (select
219: SUBT.SITE_GROUP_NODE_ID,
220: SUBT.LANGUAGE
221: from RRS_SITE_GROUP_NODES_TL SUBB, RRS_SITE_GROUP_NODES_TL SUBT
222: where SUBB.SITE_GROUP_NODE_ID = SUBT.SITE_GROUP_NODE_ID
223: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
224: and (SUBB.NAME <> SUBT.NAME
225: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 230: insert into RRS_SITE_GROUP_NODES_TL (

226: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
227: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
228: ));
229:
230: insert into RRS_SITE_GROUP_NODES_TL (
231: SITE_GROUP_NODE_ID,
232: NAME,
233: DESCRIPTION,
234: CREATED_BY,

Line 252: from RRS_SITE_GROUP_NODES_TL B, FND_LANGUAGES L

248: B.LAST_UPDATE_DATE,
249: B.LAST_UPDATE_LOGIN,
250: L.LANGUAGE_CODE,
251: B.SOURCE_LANG
252: from RRS_SITE_GROUP_NODES_TL B, FND_LANGUAGES L
253: where L.INSTALLED_FLAG in ('I', 'B')
254: and B.LANGUAGE = userenv('LANG')
255: and not exists
256: (select NULL

Line 257: from RRS_SITE_GROUP_NODES_TL T

253: where L.INSTALLED_FLAG in ('I', 'B')
254: and B.LANGUAGE = userenv('LANG')
255: and not exists
256: (select NULL
257: from RRS_SITE_GROUP_NODES_TL T
258: where T.SITE_GROUP_NODE_ID = B.SITE_GROUP_NODE_ID
259: and T.LANGUAGE = L.LANGUAGE_CODE);
260: end ADD_LANGUAGE;
261: