APPS.JTF_PREFAB_POLICIES_PKG dependencies on JTF_PREFAB_POLICIES_TL

Line 78: insert into JTF_PREFAB_POLICIES_TL (

74: X_LAST_UPDATED_BY,
75: X_LAST_UPDATE_LOGIN
76: );
77:
78: insert into JTF_PREFAB_POLICIES_TL (
79: POLICY_ID,
80: DESCRIPTION,
81: CREATED_BY,
82: CREATION_DATE,

Line 104: from JTF_PREFAB_POLICIES_TL T

100: from FND_LANGUAGES L
101: where L.INSTALLED_FLAG in ('I', 'B')
102: and not exists
103: (select NULL
104: from JTF_PREFAB_POLICIES_TL T
105: where T.POLICY_ID = X_POLICY_ID
106: and T.LANGUAGE = L.LANGUAGE_CODE);
107:
108: open c;

Line 161: from JTF_PREFAB_POLICIES_TL

157:
158: cursor c1 is select
159: DESCRIPTION,
160: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
161: from JTF_PREFAB_POLICIES_TL
162: where POLICY_ID = X_POLICY_ID
163: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
164: for update of POLICY_ID nowait;
165: begin

Line 259: update JTF_PREFAB_POLICIES_TL set

255: if (sql%notfound) then
256: raise no_data_found;
257: end if;
258:
259: update JTF_PREFAB_POLICIES_TL set
260: DESCRIPTION = X_DESCRIPTION,
261: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
263: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 277: delete from JTF_PREFAB_POLICIES_TL

273: procedure DELETE_ROW (
274: X_POLICY_ID in NUMBER
275: ) is
276: begin
277: delete from JTF_PREFAB_POLICIES_TL
278: where POLICY_ID = X_POLICY_ID;
279:
280: if (sql%notfound) then
281: raise no_data_found;

Line 295: delete from JTF_PREFAB_POLICIES_TL T

291:
292: procedure ADD_LANGUAGE
293: is
294: begin
295: delete from JTF_PREFAB_POLICIES_TL T
296: where not exists
297: (select NULL
298: from JTF_PREFAB_POLICIES_B B
299: where B.POLICY_ID = T.POLICY_ID

Line 302: update JTF_PREFAB_POLICIES_TL T set (

298: from JTF_PREFAB_POLICIES_B B
299: where B.POLICY_ID = T.POLICY_ID
300: );
301:
302: update JTF_PREFAB_POLICIES_TL T set (
303: DESCRIPTION
304: ) = (select
305: B.DESCRIPTION
306: from JTF_PREFAB_POLICIES_TL B

Line 306: from JTF_PREFAB_POLICIES_TL B

302: update JTF_PREFAB_POLICIES_TL T set (
303: DESCRIPTION
304: ) = (select
305: B.DESCRIPTION
306: from JTF_PREFAB_POLICIES_TL B
307: where B.POLICY_ID = T.POLICY_ID
308: and B.LANGUAGE = T.SOURCE_LANG)
309: where (
310: T.POLICY_ID,

Line 315: from JTF_PREFAB_POLICIES_TL SUBB, JTF_PREFAB_POLICIES_TL SUBT

311: T.LANGUAGE
312: ) in (select
313: SUBT.POLICY_ID,
314: SUBT.LANGUAGE
315: from JTF_PREFAB_POLICIES_TL SUBB, JTF_PREFAB_POLICIES_TL SUBT
316: where SUBB.POLICY_ID = SUBT.POLICY_ID
317: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
318: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
319: ));

Line 321: insert into JTF_PREFAB_POLICIES_TL (

317: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
318: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
319: ));
320:
321: insert into JTF_PREFAB_POLICIES_TL (
322: POLICY_ID,
323: DESCRIPTION,
324: CREATED_BY,
325: CREATION_DATE,

Line 343: from JTF_PREFAB_POLICIES_TL B, FND_LANGUAGES L

339: B.LAST_UPDATE_LOGIN,
340: -- B.SECURITY_GROUP_ID,
341: L.LANGUAGE_CODE,
342: B.SOURCE_LANG
343: from JTF_PREFAB_POLICIES_TL B, FND_LANGUAGES L
344: where L.INSTALLED_FLAG in ('I', 'B')
345: and B.LANGUAGE = userenv('LANG')
346: and not exists
347: (select NULL

Line 348: from JTF_PREFAB_POLICIES_TL T

344: where L.INSTALLED_FLAG in ('I', 'B')
345: and B.LANGUAGE = userenv('LANG')
346: and not exists
347: (select NULL
348: from JTF_PREFAB_POLICIES_TL T
349: where T.POLICY_ID = B.POLICY_ID
350: and T.LANGUAGE = L.LANGUAGE_CODE);
351: end ADD_LANGUAGE;
352:

Line 497: FROM JTF_PREFAB_POLICIES_B b, JTF_PREFAB_POLICIES_TL tl

493:
494: begin
495: SELECT tl.POLICY_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
496: INTO l_policy_id, db_luby, db_ludate
497: FROM JTF_PREFAB_POLICIES_B b, JTF_PREFAB_POLICIES_TL tl
498: WHERE b.POLICY_ID = tl.POLICY_ID AND
499: b.APPLICATION_ID = X_APPLICATION_ID AND
500: b.POLICY_NAME = X_POLICY_NAME AND
501: tl.LANGUAGE = userenv('LANG');

Line 508: update JTF_PREFAB_POLICIES_TL set

504: ((f_luby = 0) AND (db_luby = 1)) OR
505: ((f_luby = db_luby) AND (f_ludate > db_ludate))
506: )
507: then
508: update JTF_PREFAB_POLICIES_TL set
509: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
510: LAST_UPDATE_DATE = f_ludate,
511: LAST_UPDATED_BY = f_luby,
512: LAST_UPDATE_LOGIN = 0,