APPS.JTF_RS_GROUPS_PKG dependencies on JTF_RS_GROUPS_TL

Line 102: insert into JTF_RS_GROUPS_TL (

98: X_LAST_UPDATED_BY,
99: X_LAST_UPDATE_LOGIN
100: );
101:
102: insert into JTF_RS_GROUPS_TL (
103: GROUP_ID,
104: CREATED_BY,
105: CREATION_DATE,
106: LAST_UPDATED_BY,

Line 128: from JTF_RS_GROUPS_TL T

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

Line 239: update JTF_RS_GROUPS_TL set

235: if (sql%notfound) then
236: raise no_data_found;
237: end if;
238:
239: update JTF_RS_GROUPS_TL set
240: GROUP_NAME = X_GROUP_NAME,
241: GROUP_DESC = X_GROUP_DESC,
242: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
243: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 258: delete from JTF_RS_GROUPS_TL

254: procedure DELETE_ROW (
255: X_GROUP_ID in NUMBER
256: ) is
257: begin
258: delete from JTF_RS_GROUPS_TL
259: where GROUP_ID = X_GROUP_ID;
260:
261: if (sql%notfound) then
262: raise no_data_found;

Line 276: delete from JTF_RS_GROUPS_TL T

272:
273: procedure ADD_LANGUAGE
274: is
275: begin
276: delete from JTF_RS_GROUPS_TL T
277: where not exists
278: (select NULL
279: from JTF_RS_GROUPS_B B
280: where B.GROUP_ID = T.GROUP_ID

Line 283: update JTF_RS_GROUPS_TL T set (

279: from JTF_RS_GROUPS_B B
280: where B.GROUP_ID = T.GROUP_ID
281: );
282:
283: update JTF_RS_GROUPS_TL T set (
284: GROUP_NAME,
285: GROUP_DESC
286: ) = (select
287: B.GROUP_NAME,

Line 289: from JTF_RS_GROUPS_TL B

285: GROUP_DESC
286: ) = (select
287: B.GROUP_NAME,
288: B.GROUP_DESC
289: from JTF_RS_GROUPS_TL B
290: where B.GROUP_ID = T.GROUP_ID
291: and B.LANGUAGE = T.SOURCE_LANG)
292: where (
293: T.GROUP_ID,

Line 298: from JTF_RS_GROUPS_TL SUBB, JTF_RS_GROUPS_TL SUBT

294: T.LANGUAGE
295: ) in (select
296: SUBT.GROUP_ID,
297: SUBT.LANGUAGE
298: from JTF_RS_GROUPS_TL SUBB, JTF_RS_GROUPS_TL SUBT
299: where SUBB.GROUP_ID = SUBT.GROUP_ID
300: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
301: and (SUBB.GROUP_NAME <> SUBT.GROUP_NAME
302: or SUBB.GROUP_DESC <> SUBT.GROUP_DESC

Line 307: insert into JTF_RS_GROUPS_TL (

303: or (SUBB.GROUP_DESC is null and SUBT.GROUP_DESC is not null)
304: or (SUBB.GROUP_DESC is not null and SUBT.GROUP_DESC is null)
305: ));
306:
307: insert into JTF_RS_GROUPS_TL (
308: GROUP_ID,
309: CREATED_BY,
310: CREATION_DATE,
311: LAST_UPDATED_BY,

Line 329: from JTF_RS_GROUPS_TL B, FND_LANGUAGES L

325: B.GROUP_NAME,
326: B.GROUP_DESC,
327: L.LANGUAGE_CODE,
328: B.SOURCE_LANG
329: from JTF_RS_GROUPS_TL B, FND_LANGUAGES L
330: where L.INSTALLED_FLAG in ('I', 'B')
331: and B.LANGUAGE = userenv('LANG')
332: and not exists
333: (select NULL

Line 334: from JTF_RS_GROUPS_TL T

330: where L.INSTALLED_FLAG in ('I', 'B')
331: and B.LANGUAGE = userenv('LANG')
332: and not exists
333: (select NULL
334: from JTF_RS_GROUPS_TL T
335: where T.GROUP_ID = B.GROUP_ID
336: and T.LANGUAGE = L.LANGUAGE_CODE);
337: end ADD_LANGUAGE;
338:

Line 350: Update jtf_rs_groups_tl set

346: x_last_update_login in number)
347: is
348: begin
349:
350: Update jtf_rs_groups_tl set
351: group_name = nvl(x_group_name,group_name),
352: group_desc = nvl(x_group_desc,group_desc),
353: last_update_date = nvl(x_last_update_date,sysdate),
354: last_updated_by = x_last_updated_by,