APPS.JTF_RS_ROLES_PKG dependencies on JTF_RS_ROLES_TL

Line 108: insert into JTF_RS_ROLES_TL (

104: X_LAST_UPDATED_BY,
105: X_LAST_UPDATE_LOGIN
106: );
107:
108: insert into JTF_RS_ROLES_TL (
109: ROLE_ID,
110: CREATED_BY,
111: CREATION_DATE,
112: LAST_UPDATED_BY,

Line 134: from JTF_RS_ROLES_TL T

130: from FND_LANGUAGES L
131: where L.INSTALLED_FLAG in ('I', 'B')
132: and not exists
133: (select NULL
134: from JTF_RS_ROLES_TL T
135: where T.ROLE_ID = X_ROLE_ID
136: and T.LANGUAGE = L.LANGUAGE_CODE);
137:
138: open c;

Line 249: update JTF_RS_ROLES_TL set

245: if (sql%notfound) then
246: raise no_data_found;
247: end if;
248:
249: update JTF_RS_ROLES_TL set
250: ROLE_NAME = X_ROLE_NAME,
251: ROLE_DESC = X_ROLE_DESC,
252: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
253: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 274: Update jtf_rs_roles_tl set

270: x_last_update_login in number)
271: is
272: begin
273:
274: Update jtf_rs_roles_tl set
275: role_name = nvl(x_role_name,role_name),
276: role_desc = nvl(x_role_desc,role_desc),
277: last_update_date = nvl(x_last_update_date,sysdate),
278: last_updated_by = x_last_updated_by,

Line 413: delete from JTF_RS_ROLES_TL

409: procedure DELETE_ROW (
410: X_ROLE_ID in NUMBER
411: ) is
412: begin
413: delete from JTF_RS_ROLES_TL
414: where ROLE_ID = X_ROLE_ID;
415:
416: if (sql%notfound) then
417: raise no_data_found;

Line 431: delete from JTF_RS_ROLES_TL T

427:
428: procedure ADD_LANGUAGE
429: is
430: begin
431: delete from JTF_RS_ROLES_TL T
432: where not exists
433: (select NULL
434: from JTF_RS_ROLES_B B
435: where B.ROLE_ID = T.ROLE_ID

Line 438: update JTF_RS_ROLES_TL T set (

434: from JTF_RS_ROLES_B B
435: where B.ROLE_ID = T.ROLE_ID
436: );
437:
438: update JTF_RS_ROLES_TL T set (
439: ROLE_NAME,
440: ROLE_DESC
441: ) = (select
442: B.ROLE_NAME,

Line 444: from JTF_RS_ROLES_TL B

440: ROLE_DESC
441: ) = (select
442: B.ROLE_NAME,
443: B.ROLE_DESC
444: from JTF_RS_ROLES_TL B
445: where B.ROLE_ID = T.ROLE_ID
446: and B.LANGUAGE = T.SOURCE_LANG)
447: where (
448: T.ROLE_ID,

Line 453: from JTF_RS_ROLES_TL SUBB, JTF_RS_ROLES_TL SUBT

449: T.LANGUAGE
450: ) in (select
451: SUBT.ROLE_ID,
452: SUBT.LANGUAGE
453: from JTF_RS_ROLES_TL SUBB, JTF_RS_ROLES_TL SUBT
454: where SUBB.ROLE_ID = SUBT.ROLE_ID
455: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
456: and (SUBB.ROLE_NAME <> SUBT.ROLE_NAME
457: or SUBB.ROLE_DESC <> SUBT.ROLE_DESC

Line 462: insert into JTF_RS_ROLES_TL (

458: or (SUBB.ROLE_DESC is null and SUBT.ROLE_DESC is not null)
459: or (SUBB.ROLE_DESC is not null and SUBT.ROLE_DESC is null)
460: ));
461:
462: insert into JTF_RS_ROLES_TL (
463: ROLE_ID,
464: CREATED_BY,
465: CREATION_DATE,
466: LAST_UPDATED_BY,

Line 484: from JTF_RS_ROLES_TL B, FND_LANGUAGES L

480: B.ROLE_NAME,
481: B.ROLE_DESC,
482: L.LANGUAGE_CODE,
483: B.SOURCE_LANG
484: from JTF_RS_ROLES_TL B, FND_LANGUAGES L
485: where L.INSTALLED_FLAG in ('I', 'B')
486: and B.LANGUAGE = userenv('LANG')
487: and not exists
488: (select NULL

Line 489: from JTF_RS_ROLES_TL T

485: where L.INSTALLED_FLAG in ('I', 'B')
486: and B.LANGUAGE = userenv('LANG')
487: and not exists
488: (select NULL
489: from JTF_RS_ROLES_TL T
490: where T.ROLE_ID = B.ROLE_ID
491: and T.LANGUAGE = L.LANGUAGE_CODE);
492: end ADD_LANGUAGE;
493: