APPS.JTF_RS_GROUPS_AUD_PKG dependencies on JTF_RS_GROUPS_AUD_TL

Line 87: insert into JTF_RS_GROUPS_AUD_TL (

83: X_NEW_TIME_ZONE,
84: X_OLD_TIME_ZONE
85: );
86:
87: insert into JTF_RS_GROUPS_AUD_TL (
88: GROUP_AUDIT_ID,
89: NEW_GROUP_NAME,
90: OLD_GROUP_NAME,
91: NEW_GROUP_DESC,

Line 117: from JTF_RS_GROUPS_AUD_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from JTF_RS_GROUPS_AUD_TL T
118: where T.GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from JTF_RS_GROUPS_AUD_TL

180: OLD_GROUP_NAME,
181: NEW_GROUP_DESC,
182: OLD_GROUP_DESC,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from JTF_RS_GROUPS_AUD_TL
185: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of GROUP_AUDIT_ID nowait;
188: begin

Line 313: update JTF_RS_GROUPS_AUD_TL set

309: if (sql%notfound) then
310: raise no_data_found;
311: end if;
312:
313: update JTF_RS_GROUPS_AUD_TL set
314: NEW_GROUP_NAME = X_NEW_GROUP_NAME,
315: OLD_GROUP_NAME = X_OLD_GROUP_NAME,
316: NEW_GROUP_DESC = X_NEW_GROUP_DESC,
317: OLD_GROUP_DESC = X_OLD_GROUP_DESC,

Line 334: delete from JTF_RS_GROUPS_AUD_TL

330: procedure DELETE_ROW (
331: X_GROUP_AUDIT_ID in NUMBER
332: ) is
333: begin
334: delete from JTF_RS_GROUPS_AUD_TL
335: where GROUP_AUDIT_ID = X_GROUP_AUDIT_ID;
336:
337: if (sql%notfound) then
338: raise no_data_found;

Line 352: delete from JTF_RS_GROUPS_AUD_TL T

348:
349: procedure ADD_LANGUAGE
350: is
351: begin
352: delete from JTF_RS_GROUPS_AUD_TL T
353: where not exists
354: (select NULL
355: from JTF_RS_GROUPS_AUD_B B
356: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID

Line 359: update JTF_RS_GROUPS_AUD_TL T set (

355: from JTF_RS_GROUPS_AUD_B B
356: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID
357: );
358:
359: update JTF_RS_GROUPS_AUD_TL T set (
360: NEW_GROUP_NAME,
361: OLD_GROUP_NAME,
362: NEW_GROUP_DESC,
363: OLD_GROUP_DESC

Line 369: from JTF_RS_GROUPS_AUD_TL B

365: B.NEW_GROUP_NAME,
366: B.OLD_GROUP_NAME,
367: B.NEW_GROUP_DESC,
368: B.OLD_GROUP_DESC
369: from JTF_RS_GROUPS_AUD_TL B
370: where B.GROUP_AUDIT_ID = T.GROUP_AUDIT_ID
371: and B.LANGUAGE = T.SOURCE_LANG)
372: where (
373: T.GROUP_AUDIT_ID,

Line 378: from JTF_RS_GROUPS_AUD_TL SUBB, JTF_RS_GROUPS_AUD_TL SUBT

374: T.LANGUAGE
375: ) in (select
376: SUBT.GROUP_AUDIT_ID,
377: SUBT.LANGUAGE
378: from JTF_RS_GROUPS_AUD_TL SUBB, JTF_RS_GROUPS_AUD_TL SUBT
379: where SUBB.GROUP_AUDIT_ID = SUBT.GROUP_AUDIT_ID
380: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
381: and (SUBB.NEW_GROUP_NAME <> SUBT.NEW_GROUP_NAME
382: or (SUBB.NEW_GROUP_NAME is null and SUBT.NEW_GROUP_NAME is not null)

Line 395: insert into JTF_RS_GROUPS_AUD_TL (

391: or (SUBB.OLD_GROUP_DESC is null and SUBT.OLD_GROUP_DESC is not null)
392: or (SUBB.OLD_GROUP_DESC is not null and SUBT.OLD_GROUP_DESC is null)
393: ));
394:
395: insert into JTF_RS_GROUPS_AUD_TL (
396: GROUP_AUDIT_ID,
397: NEW_GROUP_NAME,
398: OLD_GROUP_NAME,
399: NEW_GROUP_DESC,

Line 421: from JTF_RS_GROUPS_AUD_TL B, FND_LANGUAGES L

417: B.LAST_UPDATE_DATE,
418: B.LAST_UPDATE_LOGIN,
419: L.LANGUAGE_CODE,
420: B.SOURCE_LANG
421: from JTF_RS_GROUPS_AUD_TL B, FND_LANGUAGES L
422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL

Line 426: from JTF_RS_GROUPS_AUD_TL T

422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL
426: from JTF_RS_GROUPS_AUD_TL T
427: where T.GROUP_AUDIT_ID = B.GROUP_AUDIT_ID
428: and T.LANGUAGE = L.LANGUAGE_CODE);
429: end ADD_LANGUAGE;
430:

Line 444: Update jtf_rs_groups_aud_tl set

440: x_last_update_login in number)
441: is
442: begin
443:
444: Update jtf_rs_groups_aud_tl set
445: new_group_name = nvl(x_new_group_name,new_group_name),
446: new_group_desc = nvl(x_new_group_desc,new_group_desc),
447: old_group_name = nvl(x_old_group_name,old_group_name),
448: old_group_desc = nvl(x_old_group_desc,old_group_desc),