APPS.JTF_RS_GROUPS_AUD_PKG dependencies on JTF_RS_GROUPS_AUD_TL

Line 81: insert into JTF_RS_GROUPS_AUD_TL (

77: X_LAST_UPDATED_BY,
78: X_LAST_UPDATE_LOGIN
79: );
80:
81: insert into JTF_RS_GROUPS_AUD_TL (
82: GROUP_AUDIT_ID,
83: NEW_GROUP_NAME,
84: OLD_GROUP_NAME,
85: NEW_GROUP_DESC,

Line 111: from JTF_RS_GROUPS_AUD_TL T

107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from JTF_RS_GROUPS_AUD_TL T
112: where T.GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
113: and T.LANGUAGE = L.LANGUAGE_CODE);
114:
115: open c;

Line 174: from JTF_RS_GROUPS_AUD_TL

170: OLD_GROUP_NAME,
171: NEW_GROUP_DESC,
172: OLD_GROUP_DESC,
173: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
174: from JTF_RS_GROUPS_AUD_TL
175: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
176: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
177: for update of GROUP_AUDIT_ID nowait;
178: begin

Line 295: update JTF_RS_GROUPS_AUD_TL set

291: if (sql%notfound) then
292: raise no_data_found;
293: end if;
294:
295: update JTF_RS_GROUPS_AUD_TL set
296: NEW_GROUP_NAME = X_NEW_GROUP_NAME,
297: OLD_GROUP_NAME = X_OLD_GROUP_NAME,
298: NEW_GROUP_DESC = X_NEW_GROUP_DESC,
299: OLD_GROUP_DESC = X_OLD_GROUP_DESC,

Line 316: delete from JTF_RS_GROUPS_AUD_TL

312: procedure DELETE_ROW (
313: X_GROUP_AUDIT_ID in NUMBER
314: ) is
315: begin
316: delete from JTF_RS_GROUPS_AUD_TL
317: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID;
318:
319: if (sql%notfound) then
320: raise no_data_found;

Line 334: delete from JTF_RS_GROUPS_AUD_TL T

330:
331: procedure ADD_LANGUAGE
332: is
333: begin
334: delete from JTF_RS_GROUPS_AUD_TL T
335: where not exists
336: (select NULL
337: from JTF_RS_GROUPS_AUD_B B
338: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID

Line 341: update JTF_RS_GROUPS_AUD_TL T set (

337: from JTF_RS_GROUPS_AUD_B B
338: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID
339: );
340:
341: update JTF_RS_GROUPS_AUD_TL T set (
342: NEW_GROUP_NAME,
343: OLD_GROUP_NAME,
344: NEW_GROUP_DESC,
345: OLD_GROUP_DESC

Line 351: from JTF_RS_GROUPS_AUD_TL B

347: B.NEW_GROUP_NAME,
348: B.OLD_GROUP_NAME,
349: B.NEW_GROUP_DESC,
350: B.OLD_GROUP_DESC
351: from JTF_RS_GROUPS_AUD_TL B
352: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID
353: and B.LANGUAGE = T.SOURCE_LANG)
354: where (
355: T.GROUP_AUDIT_ID,

Line 360: from JTF_RS_GROUPS_AUD_TL SUBB, JTF_RS_GROUPS_AUD_TL SUBT

356: T.LANGUAGE
357: ) in (select
358: SUBT.GROUP_AUDIT_ID,
359: SUBT.LANGUAGE
360: from JTF_RS_GROUPS_AUD_TL SUBB, JTF_RS_GROUPS_AUD_TL SUBT
361: where SUBB.GROUP_AUDIT_ID = SUBT.GROUP_AUDIT_ID
362: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
363: and (SUBB.NEW_GROUP_NAME <> SUBT.NEW_GROUP_NAME
364: or (SUBB.NEW_GROUP_NAME is null and SUBT.NEW_GROUP_NAME is not null)

Line 377: insert into JTF_RS_GROUPS_AUD_TL (

373: or (SUBB.OLD_GROUP_DESC is null and SUBT.OLD_GROUP_DESC is not null)
374: or (SUBB.OLD_GROUP_DESC is not null and SUBT.OLD_GROUP_DESC is null)
375: ));
376:
377: insert into JTF_RS_GROUPS_AUD_TL (
378: GROUP_AUDIT_ID,
379: NEW_GROUP_NAME,
380: OLD_GROUP_NAME,
381: NEW_GROUP_DESC,

Line 403: from JTF_RS_GROUPS_AUD_TL B, FND_LANGUAGES L

399: B.LAST_UPDATE_DATE,
400: B.LAST_UPDATE_LOGIN,
401: L.LANGUAGE_CODE,
402: B.SOURCE_LANG
403: from JTF_RS_GROUPS_AUD_TL B, FND_LANGUAGES L
404: where L.INSTALLED_FLAG in ('I', 'B')
405: and B.LANGUAGE = userenv('LANG')
406: and not exists
407: (select NULL

Line 408: from JTF_RS_GROUPS_AUD_TL T

404: where L.INSTALLED_FLAG in ('I', 'B')
405: and B.LANGUAGE = userenv('LANG')
406: and not exists
407: (select NULL
408: from JTF_RS_GROUPS_AUD_TL T
409: where T.GROUP_AUDIT_ID = B.GROUP_AUDIT_ID
410: and T.LANGUAGE = L.LANGUAGE_CODE);
411: end ADD_LANGUAGE;
412:

Line 426: Update jtf_rs_groups_aud_tl set

422: x_last_update_login in number)
423: is
424: begin
425:
426: Update jtf_rs_groups_aud_tl set
427: new_group_name = nvl(x_new_group_name,new_group_name),
428: new_group_desc = nvl(x_new_group_desc,new_group_desc),
429: old_group_name = nvl(x_old_group_name,old_group_name),
430: old_group_desc = nvl(x_old_group_desc,old_group_desc),