APPS.JTF_AUTH_PERMISSIONS_PKG dependencies on JTF_AUTH_PERMISSIONS_TL

Line 57: insert into JTF_AUTH_PERMISSIONS_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: );
56:
57: insert into JTF_AUTH_PERMISSIONS_TL (
58: PERMISSION_DESC_ID,
59: PERMISSION_DESC,
60: DESCRIPTION,
61: CREATION_DATE,

Line 83: from JTF_AUTH_PERMISSIONS_TL T

79: from FND_LANGUAGES L
80: where L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from JTF_AUTH_PERMISSIONS_TL T
84: where T.PERMISSION_DESC_ID = X_JTF_AUTH_PERMISSION_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 127: from JTF_AUTH_PERMISSIONS_TL

123: cursor c1 is select
124: PERMISSION_DESC,
125: DESCRIPTION,
126: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
127: from JTF_AUTH_PERMISSIONS_TL
128: where PERMISSION_DESC_ID = X_JTF_AUTH_PERMISSION_ID
129: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
130: for update of PERMISSION_DESC_ID nowait;
131: begin

Line 211: update JTF_AUTH_PERMISSIONS_TL set

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: update JTF_AUTH_PERMISSIONS_TL set
212: PERMISSION_DESC = X_PERMISSION_DESC,
213: DESCRIPTION = X_DESCRIPTION,
214: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
215: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 230: delete from JTF_AUTH_PERMISSIONS_TL

226: procedure DELETE_ROW (
227: X_JTF_AUTH_PERMISSION_ID in NUMBER
228: ) is
229: begin
230: delete from JTF_AUTH_PERMISSIONS_TL
231: where PERMISSION_DESC_ID = X_JTF_AUTH_PERMISSION_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 248: delete from JTF_AUTH_PERMISSIONS_TL T

244:
245: procedure ADD_LANGUAGE
246: is
247: begin
248: delete from JTF_AUTH_PERMISSIONS_TL T
249: where not exists
250: (select NULL
251: from JTF_AUTH_PERMISSIONS_B B
252: where B.JTF_AUTH_PERMISSION_ID = T.PERMISSION_DESC_ID

Line 255: update JTF_AUTH_PERMISSIONS_TL T set (

251: from JTF_AUTH_PERMISSIONS_B B
252: where B.JTF_AUTH_PERMISSION_ID = T.PERMISSION_DESC_ID
253: );
254:
255: update JTF_AUTH_PERMISSIONS_TL T set (
256: PERMISSION_DESC,
257: DESCRIPTION
258: ) = (select
259: B.PERMISSION_DESC,

Line 261: from JTF_AUTH_PERMISSIONS_TL B

257: DESCRIPTION
258: ) = (select
259: B.PERMISSION_DESC,
260: B.DESCRIPTION
261: from JTF_AUTH_PERMISSIONS_TL B
262: where B.PERMISSION_DESC_ID = T.PERMISSION_DESC_ID
263: and B.LANGUAGE = T.SOURCE_LANG)
264: where (
265: T.PERMISSION_DESC_ID,

Line 270: from JTF_AUTH_PERMISSIONS_TL SUBB, JTF_AUTH_PERMISSIONS_TL SUBT

266: T.LANGUAGE
267: ) in (select
268: SUBT.PERMISSION_DESC_ID,
269: SUBT.LANGUAGE
270: from JTF_AUTH_PERMISSIONS_TL SUBB, JTF_AUTH_PERMISSIONS_TL SUBT
271: where SUBB.PERMISSION_DESC_ID = SUBT.PERMISSION_DESC_ID
272: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
273: and (SUBB.PERMISSION_DESC <> SUBT.PERMISSION_DESC
274: or (SUBB.PERMISSION_DESC is null and SUBT.PERMISSION_DESC is not null)

Line 281: insert into JTF_AUTH_PERMISSIONS_TL (

277: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
278: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
279: ));
280:
281: insert into JTF_AUTH_PERMISSIONS_TL (
282: PERMISSION_DESC_ID,
283: PERMISSION_DESC,
284: DESCRIPTION,
285: CREATION_DATE,

Line 303: from JTF_AUTH_PERMISSIONS_TL B, FND_LANGUAGES L

299: B.LAST_UPDATED_BY,
300: B.LAST_UPDATE_LOGIN,
301: L.LANGUAGE_CODE,
302: B.SOURCE_LANG
303: from JTF_AUTH_PERMISSIONS_TL B, FND_LANGUAGES L
304: where L.INSTALLED_FLAG in ('I', 'B')
305: and B.LANGUAGE = userenv('LANG')
306: and not exists
307: (select NULL

Line 308: from JTF_AUTH_PERMISSIONS_TL T

304: where L.INSTALLED_FLAG in ('I', 'B')
305: and B.LANGUAGE = userenv('LANG')
306: and not exists
307: (select NULL
308: from JTF_AUTH_PERMISSIONS_TL T
309: where T.PERMISSION_DESC_ID = B.PERMISSION_DESC_ID
310: and T.LANGUAGE = L.LANGUAGE_CODE);
311: end ADD_LANGUAGE;
312:

Line 323: update JTF_AUTH_PERMISSIONS_TL set

319: X_OWNER in VARCHAR2 -- owner fields
320: ) is
321:
322: begin
323: update JTF_AUTH_PERMISSIONS_TL set
324: PERMISSION_DESC = x_PERMISSION_DESC,
325: DESCRIPTION = x_DESCRIPTION,
326: LAST_UPDATE_DATE = sysdate,
327: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),