APPS.JTF_RS_DYNAMIC_GROUPS_PKG dependencies on JTF_RS_DYNAMIC_GROUPS_TL

Line 99: insert into JTF_RS_DYNAMIC_GROUPS_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into JTF_RS_DYNAMIC_GROUPS_TL (
100: GROUP_ID,
101: CREATED_BY,
102: CREATION_DATE,
103: LAST_UPDATED_BY,

Line 125: from JTF_RS_DYNAMIC_GROUPS_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from JTF_RS_DYNAMIC_GROUPS_TL T
126: where T.GROUP_ID = X_GROUP_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: open c;

Line 234: update JTF_RS_DYNAMIC_GROUPS_TL set

230: if (sql%notfound) then
231: raise no_data_found;
232: end if;
233:
234: update JTF_RS_DYNAMIC_GROUPS_TL set
235: GROUP_NAME = X_GROUP_NAME,
236: GROUP_DESC = X_GROUP_DESC,
237: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
238: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 253: delete from JTF_RS_DYNAMIC_GROUPS_TL

249: procedure DELETE_ROW (
250: X_GROUP_ID in NUMBER
251: ) is
252: begin
253: delete from JTF_RS_DYNAMIC_GROUPS_TL
254: where GROUP_ID = X_GROUP_ID;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 271: delete from JTF_RS_DYNAMIC_GROUPS_TL T

267:
268: procedure ADD_LANGUAGE
269: is
270: begin
271: delete from JTF_RS_DYNAMIC_GROUPS_TL T
272: where not exists
273: (select NULL
274: from JTF_RS_DYNAMIC_GROUPS_B B
275: where B.GROUP_ID = T.GROUP_ID

Line 278: update JTF_RS_DYNAMIC_GROUPS_TL T set (

274: from JTF_RS_DYNAMIC_GROUPS_B B
275: where B.GROUP_ID = T.GROUP_ID
276: );
277:
278: update JTF_RS_DYNAMIC_GROUPS_TL T set (
279: GROUP_NAME,
280: GROUP_DESC
281: ) = (select
282: B.GROUP_NAME,

Line 284: from JTF_RS_DYNAMIC_GROUPS_TL B

280: GROUP_DESC
281: ) = (select
282: B.GROUP_NAME,
283: B.GROUP_DESC
284: from JTF_RS_DYNAMIC_GROUPS_TL B
285: where B.GROUP_ID = T.GROUP_ID
286: and B.LANGUAGE = T.SOURCE_LANG)
287: where (
288: T.GROUP_ID,

Line 293: from JTF_RS_DYNAMIC_GROUPS_TL SUBB, JTF_RS_DYNAMIC_GROUPS_TL SUBT

289: T.LANGUAGE
290: ) in (select
291: SUBT.GROUP_ID,
292: SUBT.LANGUAGE
293: from JTF_RS_DYNAMIC_GROUPS_TL SUBB, JTF_RS_DYNAMIC_GROUPS_TL SUBT
294: where SUBB.GROUP_ID = SUBT.GROUP_ID
295: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
296: and (SUBB.GROUP_NAME <> SUBT.GROUP_NAME
297: or SUBB.GROUP_DESC <> SUBT.GROUP_DESC

Line 302: insert into JTF_RS_DYNAMIC_GROUPS_TL (

298: or (SUBB.GROUP_DESC is null and SUBT.GROUP_DESC is not null)
299: or (SUBB.GROUP_DESC is not null and SUBT.GROUP_DESC is null)
300: ));
301:
302: insert into JTF_RS_DYNAMIC_GROUPS_TL (
303: GROUP_ID,
304: CREATED_BY,
305: CREATION_DATE,
306: LAST_UPDATED_BY,

Line 324: from JTF_RS_DYNAMIC_GROUPS_TL B, FND_LANGUAGES L

320: B.GROUP_NAME,
321: B.GROUP_DESC,
322: L.LANGUAGE_CODE,
323: B.SOURCE_LANG
324: from JTF_RS_DYNAMIC_GROUPS_TL B, FND_LANGUAGES L
325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL

Line 329: from JTF_RS_DYNAMIC_GROUPS_TL T

325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL
329: from JTF_RS_DYNAMIC_GROUPS_TL T
330: where T.GROUP_ID = B.GROUP_ID
331: and T.LANGUAGE = L.LANGUAGE_CODE);
332: end ADD_LANGUAGE;
333:

Line 345: Update jtf_rs_dynamic_groups_tl set

341: x_last_update_login in number)
342: is
343: begin
344:
345: Update jtf_rs_dynamic_groups_tl set
346: group_name = nvl(x_group_name,group_name),
347: group_desc = nvl(x_group_desc,group_desc),
348: last_update_date = nvl(x_last_update_date,sysdate),
349: last_updated_by = x_last_updated_by,