APPS.JTF_AUTH_PRINCIPALS_PKG dependencies on JTF_AUTH_PRINCIPALS_TL

Line 54: insert into JTF_AUTH_PRINCIPALS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into JTF_AUTH_PRINCIPALS_TL (
55: PRINCIPAL_DESC_ID,
56: PRINCIPAL_DESC,
57: DESCRIPTION,
58: CREATION_DATE,

Line 80: from JTF_AUTH_PRINCIPALS_TL T

76: from FND_LANGUAGES L
77: where L.INSTALLED_FLAG in ('I', 'B')
78: and not exists
79: (select NULL
80: from JTF_AUTH_PRINCIPALS_TL T
81: where T.PRINCIPAL_DESC_ID = X_JTF_AUTH_PRINCIPAL_ID
82: and T.LANGUAGE = L.LANGUAGE_CODE);
83:
84: open c;

Line 122: from JTF_AUTH_PRINCIPALS_TL

118: cursor c1 is select
119: PRINCIPAL_DESC,
120: DESCRIPTION,
121: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
122: from JTF_AUTH_PRINCIPALS_TL
123: where PRINCIPAL_DESC_ID = X_JTF_AUTH_PRINCIPAL_ID
124: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
125: for update of PRINCIPAL_DESC_ID nowait;
126: begin

Line 203: update JTF_AUTH_PRINCIPALS_TL set

199: if (sql%notfound) then
200: raise no_data_found;
201: end if;
202:
203: update JTF_AUTH_PRINCIPALS_TL set
204: PRINCIPAL_DESC = X_PRINCIPAL_DESC,
205: DESCRIPTION = X_DESCRIPTION,
206: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
207: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 269: delete from JTF_AUTH_PRINCIPALS_TL T

265:
266: procedure ADD_LANGUAGE
267: is
268: begin
269: delete from JTF_AUTH_PRINCIPALS_TL T
270: where not exists
271: (select NULL
272: from JTF_AUTH_PRINCIPALS_B B
273: where B.JTF_AUTH_PRINCIPAL_ID = T.PRINCIPAL_DESC_ID

Line 276: update JTF_AUTH_PRINCIPALS_TL T set (

272: from JTF_AUTH_PRINCIPALS_B B
273: where B.JTF_AUTH_PRINCIPAL_ID = T.PRINCIPAL_DESC_ID
274: );
275:
276: update JTF_AUTH_PRINCIPALS_TL T set (
277: PRINCIPAL_DESC,
278: DESCRIPTION
279: ) = (select
280: B.PRINCIPAL_DESC,

Line 282: from JTF_AUTH_PRINCIPALS_TL B

278: DESCRIPTION
279: ) = (select
280: B.PRINCIPAL_DESC,
281: B.DESCRIPTION
282: from JTF_AUTH_PRINCIPALS_TL B
283: where B.PRINCIPAL_DESC_ID = T.PRINCIPAL_DESC_ID
284: and B.LANGUAGE = T.SOURCE_LANG)
285: where (
286: T.PRINCIPAL_DESC_ID,

Line 291: from JTF_AUTH_PRINCIPALS_TL SUBB, JTF_AUTH_PRINCIPALS_TL SUBT

287: T.LANGUAGE
288: ) in (select
289: SUBT.PRINCIPAL_DESC_ID,
290: SUBT.LANGUAGE
291: from JTF_AUTH_PRINCIPALS_TL SUBB, JTF_AUTH_PRINCIPALS_TL SUBT
292: where SUBB.PRINCIPAL_DESC_ID = SUBT.PRINCIPAL_DESC_ID
293: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
294: and (SUBB.PRINCIPAL_DESC <> SUBT.PRINCIPAL_DESC
295: or (SUBB.PRINCIPAL_DESC is null and SUBT.PRINCIPAL_DESC is not null)

Line 302: insert into JTF_AUTH_PRINCIPALS_TL (

298: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
299: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
300: ));
301:
302: insert into JTF_AUTH_PRINCIPALS_TL (
303: PRINCIPAL_DESC_ID,
304: PRINCIPAL_DESC,
305: DESCRIPTION,
306: CREATION_DATE,

Line 324: from JTF_AUTH_PRINCIPALS_TL B, FND_LANGUAGES L

320: B.LAST_UPDATED_BY,
321: B.LAST_UPDATE_LOGIN,
322: L.LANGUAGE_CODE,
323: B.SOURCE_LANG
324: from JTF_AUTH_PRINCIPALS_TL B, FND_LANGUAGES L
325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL

Line 329: from JTF_AUTH_PRINCIPALS_TL T

325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL
329: from JTF_AUTH_PRINCIPALS_TL T
330: where T.PRINCIPAL_DESC_ID = B.PRINCIPAL_DESC_ID
331: and T.LANGUAGE = L.LANGUAGE_CODE);
332: end ADD_LANGUAGE;
333:

Line 344: update JTF_AUTH_PRINCIPALS_TL set

340: X_OWNER in VARCHAR2 -- owner fields
341: ) is
342:
343: begin
344: update JTF_AUTH_PRINCIPALS_TL set
345: PRINCIPAL_DESC = x_PRINCIPAL_DESC,
346: DESCRIPTION = x_DESCRIPTION,
347: LAST_UPDATE_DATE = sysdate,
348: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),