APPS.JTF_RS_GROUPS_PKG dependencies on JTF_RS_GROUPS_TL

Line 105: insert into JTF_RS_GROUPS_TL (

101: X_LAST_UPDATE_LOGIN,
102: X_TIME_ZONE
103: );
104:
105: insert into JTF_RS_GROUPS_TL (
106: GROUP_ID,
107: CREATED_BY,
108: CREATION_DATE,
109: LAST_UPDATED_BY,

Line 131: from JTF_RS_GROUPS_TL T

127: from FND_LANGUAGES L
128: where L.INSTALLED_FLAG in ('I', 'B')
129: and not exists
130: (select NULL
131: from JTF_RS_GROUPS_TL T
132: where T.GROUP_ID = X_GROUP_ID
133: and T.LANGUAGE = L.LANGUAGE_CODE);
134:
135: open c;

Line 244: update JTF_RS_GROUPS_TL set

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: update JTF_RS_GROUPS_TL set
245: GROUP_NAME = X_GROUP_NAME,
246: GROUP_DESC = X_GROUP_DESC,
247: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
248: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 263: delete from JTF_RS_GROUPS_TL

259: procedure DELETE_ROW (
260: X_GROUP_ID in NUMBER
261: ) is
262: begin
263: delete from JTF_RS_GROUPS_TL
264: where GROUP_ID = X_GROUP_ID;
265:
266: if (sql%notfound) then
267: raise no_data_found;

Line 281: delete from JTF_RS_GROUPS_TL T

277:
278: procedure ADD_LANGUAGE
279: is
280: begin
281: delete from JTF_RS_GROUPS_TL T
282: where not exists
283: (select NULL
284: from JTF_RS_GROUPS_B B
285: where B.GROUP_ID = T.GROUP_ID

Line 288: update JTF_RS_GROUPS_TL T set (

284: from JTF_RS_GROUPS_B B
285: where B.GROUP_ID = T.GROUP_ID
286: );
287:
288: update JTF_RS_GROUPS_TL T set (
289: GROUP_NAME,
290: GROUP_DESC
291: ) = (select
292: B.GROUP_NAME,

Line 294: from JTF_RS_GROUPS_TL B

290: GROUP_DESC
291: ) = (select
292: B.GROUP_NAME,
293: B.GROUP_DESC
294: from JTF_RS_GROUPS_TL B
295: where B.GROUP_ID = T.GROUP_ID
296: and B.LANGUAGE = T.SOURCE_LANG)
297: where (
298: T.GROUP_ID,

Line 303: from JTF_RS_GROUPS_TL SUBB, JTF_RS_GROUPS_TL SUBT

299: T.LANGUAGE
300: ) in (select
301: SUBT.GROUP_ID,
302: SUBT.LANGUAGE
303: from JTF_RS_GROUPS_TL SUBB, JTF_RS_GROUPS_TL SUBT
304: where SUBB.GROUP_ID = SUBT.GROUP_ID
305: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
306: and (SUBB.GROUP_NAME <> SUBT.GROUP_NAME
307: or SUBB.GROUP_DESC <> SUBT.GROUP_DESC

Line 312: insert into JTF_RS_GROUPS_TL (

308: or (SUBB.GROUP_DESC is null and SUBT.GROUP_DESC is not null)
309: or (SUBB.GROUP_DESC is not null and SUBT.GROUP_DESC is null)
310: ));
311:
312: insert into JTF_RS_GROUPS_TL (
313: GROUP_ID,
314: CREATED_BY,
315: CREATION_DATE,
316: LAST_UPDATED_BY,

Line 334: from JTF_RS_GROUPS_TL B, FND_LANGUAGES L

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

Line 339: from JTF_RS_GROUPS_TL T

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

Line 355: Update jtf_rs_groups_tl set

351: x_last_update_login in number)
352: is
353: begin
354:
355: Update jtf_rs_groups_tl set
356: group_name = nvl(x_group_name,group_name),
357: group_desc = nvl(x_group_desc,group_desc),
358: last_update_date = nvl(x_last_update_date,sysdate),
359: last_updated_by = x_last_updated_by,