APPS.JTF_UM_SUBSCRIPTIONS_PKG dependencies on JTF_UM_SUBSCRIPTIONS_TL

Line 68: insert into JTF_UM_SUBSCRIPTIONS_TL (

64: X_LAST_UPDATE_LOGIN,
65: X_AUTH_DELEGATION_ROLE_ID
66: )RETURNING SUBSCRIPTION_ID INTO X_SUBSCRIPTION_ID;
67:
68: insert into JTF_UM_SUBSCRIPTIONS_TL (
69: LAST_UPDATED_BY,
70: CREATION_DATE,
71: CREATED_BY,
72: LAST_UPDATE_LOGIN,

Line 96: from JTF_UM_SUBSCRIPTIONS_TL T

92: from FND_LANGUAGES L
93: where L.INSTALLED_FLAG in ('I', 'B')
94: and not exists
95: (select NULL
96: from JTF_UM_SUBSCRIPTIONS_TL T
97: where T.SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
98: and T.LANGUAGE = L.LANGUAGE_CODE);
99:
100: open c;

Line 144: from JTF_UM_SUBSCRIPTIONS_TL

140: cursor c1 is select
141: SUBSCRIPTION_NAME,
142: DESCRIPTION,
143: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
144: from JTF_UM_SUBSCRIPTIONS_TL
145: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
146: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
147: for update of SUBSCRIPTION_ID nowait;
148: begin

Line 230: update JTF_UM_SUBSCRIPTIONS_TL set

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: update JTF_UM_SUBSCRIPTIONS_TL set
231: SUBSCRIPTION_NAME = X_SUBSCRIPTION_NAME,
232: DESCRIPTION = X_DESCRIPTION,
233: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
234: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 249: delete from JTF_UM_SUBSCRIPTIONS_TL

245: procedure DELETE_ROW (
246: X_SUBSCRIPTION_ID in NUMBER
247: ) is
248: begin
249: delete from JTF_UM_SUBSCRIPTIONS_TL
250: where SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
251:
252: if (sql%notfound) then
253: raise no_data_found;

Line 267: delete from JTF_UM_SUBSCRIPTIONS_TL T

263:
264: procedure ADD_LANGUAGE
265: is
266: begin
267: delete from JTF_UM_SUBSCRIPTIONS_TL T
268: where not exists
269: (select NULL
270: from JTF_UM_SUBSCRIPTIONS_B B
271: where B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID

Line 274: update JTF_UM_SUBSCRIPTIONS_TL T set (

270: from JTF_UM_SUBSCRIPTIONS_B B
271: where B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID
272: );
273:
274: update JTF_UM_SUBSCRIPTIONS_TL T set (
275: SUBSCRIPTION_NAME,
276: DESCRIPTION
277: ) = (select
278: B.SUBSCRIPTION_NAME,

Line 280: from JTF_UM_SUBSCRIPTIONS_TL B

276: DESCRIPTION
277: ) = (select
278: B.SUBSCRIPTION_NAME,
279: B.DESCRIPTION
280: from JTF_UM_SUBSCRIPTIONS_TL B
281: where B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID
282: and B.LANGUAGE = T.SOURCE_LANG)
283: where (
284: T.SUBSCRIPTION_ID,

Line 289: from JTF_UM_SUBSCRIPTIONS_TL SUBB, JTF_UM_SUBSCRIPTIONS_TL SUBT

285: T.LANGUAGE
286: ) in (select
287: SUBT.SUBSCRIPTION_ID,
288: SUBT.LANGUAGE
289: from JTF_UM_SUBSCRIPTIONS_TL SUBB, JTF_UM_SUBSCRIPTIONS_TL SUBT
290: where SUBB.SUBSCRIPTION_ID = SUBT.SUBSCRIPTION_ID
291: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
292: and (SUBB.SUBSCRIPTION_NAME <> SUBT.SUBSCRIPTION_NAME
293: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 296: insert into JTF_UM_SUBSCRIPTIONS_TL (

292: and (SUBB.SUBSCRIPTION_NAME <> SUBT.SUBSCRIPTION_NAME
293: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
294: ));
295:
296: insert into JTF_UM_SUBSCRIPTIONS_TL (
297: LAST_UPDATED_BY,
298: CREATION_DATE,
299: CREATED_BY,
300: LAST_UPDATE_LOGIN,

Line 320: from JTF_UM_SUBSCRIPTIONS_TL B, FND_LANGUAGES L

316: B.SUBSCRIPTION_ID,
317: B.SUBSCRIPTION_NAME,
318: L.LANGUAGE_CODE,
319: B.SOURCE_LANG
320: from JTF_UM_SUBSCRIPTIONS_TL B, FND_LANGUAGES L
321: where L.INSTALLED_FLAG in ('I', 'B')
322: and B.LANGUAGE = userenv('LANG')
323: and not exists
324: (select NULL

Line 325: from JTF_UM_SUBSCRIPTIONS_TL T

321: where L.INSTALLED_FLAG in ('I', 'B')
322: and B.LANGUAGE = userenv('LANG')
323: and not exists
324: (select NULL
325: from JTF_UM_SUBSCRIPTIONS_TL T
326: where T.SUBSCRIPTION_ID = B.SUBSCRIPTION_ID
327: and T.LANGUAGE = L.LANGUAGE_CODE);
328: end ADD_LANGUAGE;
329:

Line 453: FROM JTF_UM_SUBSCRIPTIONS_TL

449: -- there is a row for this app_id and this app_short_name
450: -- Exception is thrown otherwise.
451: select LAST_UPDATED_BY, LAST_UPDATE_DATE
452: into db_luby, db_ludate
453: FROM JTF_UM_SUBSCRIPTIONS_TL
454: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
455: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
456:
457: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 459: update JTF_UM_SUBSCRIPTIONS_TL set

455: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
456:
457: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
458: db_ludate, X_CUSTOM_MODE)) then
459: update JTF_UM_SUBSCRIPTIONS_TL set
460: SUBSCRIPTION_NAME = X_SUBSCRIPTION_NAME,
461: DESCRIPTION = X_DESCRIPTION,
462: LAST_UPDATE_DATE = f_ludate,
463: LAST_UPDATED_BY = f_luby,