APPS.JTF_EVT_TYPES_PKG dependencies on JTF_EVT_TYPES_TL

Line 38: insert into JTF_EVT_TYPES_TL (

34: X_LAST_UPDATED_BY,
35: X_LAST_UPDATE_LOGIN
36: );
37:
38: insert into JTF_EVT_TYPES_TL (
39: LAST_UPDATE_LOGIN,
40: SECURITY_GROUP_ID,
41: CREATED_BY,
42: JTF_EVT_TYPES_ID,

Line 64: from JTF_EVT_TYPES_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and not exists
63: (select NULL
64: from JTF_EVT_TYPES_TL T
65: where T.JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: open c;

Line 95: from JTF_EVT_TYPES_TL

91:
92: cursor c1 is select
93: JTF_EVT_TYPES_DESC,
94: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
95: from JTF_EVT_TYPES_TL
96: where JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID
97: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
98: for update of JTF_EVT_TYPES_ID nowait;
99: begin

Line 155: update JTF_EVT_TYPES_TL set

151: if (sql%notfound) then
152: raise no_data_found;
153: end if;
154:
155: update JTF_EVT_TYPES_TL set
156: JTF_EVT_TYPES_DESC = X_JTF_EVT_TYPES_DESC,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
158: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
159: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 173: delete from JTF_EVT_TYPES_TL

169: procedure DELETE_ROW (
170: X_JTF_EVT_TYPES_ID in NUMBER
171: ) is
172: begin
173: delete from JTF_EVT_TYPES_TL
174: where JTF_EVT_TYPES_ID = X_JTF_EVT_TYPES_ID;
175:
176: if (sql%notfound) then
177: raise no_data_found;

Line 191: delete from JTF_EVT_TYPES_TL T

187:
188: procedure ADD_LANGUAGE
189: is
190: begin
191: delete from JTF_EVT_TYPES_TL T
192: where not exists
193: (select NULL
194: from JTF_EVT_TYPES_B B
195: where B.JTF_EVT_TYPES_ID = T.JTF_EVT_TYPES_ID

Line 198: update JTF_EVT_TYPES_TL T set (

194: from JTF_EVT_TYPES_B B
195: where B.JTF_EVT_TYPES_ID = T.JTF_EVT_TYPES_ID
196: );
197:
198: update JTF_EVT_TYPES_TL T set (
199: JTF_EVT_TYPES_DESC
200: ) = (select
201: B.JTF_EVT_TYPES_DESC
202: from JTF_EVT_TYPES_TL B

Line 202: from JTF_EVT_TYPES_TL B

198: update JTF_EVT_TYPES_TL T set (
199: JTF_EVT_TYPES_DESC
200: ) = (select
201: B.JTF_EVT_TYPES_DESC
202: from JTF_EVT_TYPES_TL B
203: where B.JTF_EVT_TYPES_ID = T.JTF_EVT_TYPES_ID
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.JTF_EVT_TYPES_ID,

Line 211: from JTF_EVT_TYPES_TL SUBB, JTF_EVT_TYPES_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.JTF_EVT_TYPES_ID,
210: SUBT.LANGUAGE
211: from JTF_EVT_TYPES_TL SUBB, JTF_EVT_TYPES_TL SUBT
212: where SUBB.JTF_EVT_TYPES_ID = SUBT.JTF_EVT_TYPES_ID
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.JTF_EVT_TYPES_DESC <> SUBT.JTF_EVT_TYPES_DESC
215: or (SUBB.JTF_EVT_TYPES_DESC is null and SUBT.JTF_EVT_TYPES_DESC is not null)

Line 219: insert into JTF_EVT_TYPES_TL (

215: or (SUBB.JTF_EVT_TYPES_DESC is null and SUBT.JTF_EVT_TYPES_DESC is not null)
216: or (SUBB.JTF_EVT_TYPES_DESC is not null and SUBT.JTF_EVT_TYPES_DESC is null)
217: ));
218:
219: insert into JTF_EVT_TYPES_TL (
220: LAST_UPDATE_LOGIN,
221: SECURITY_GROUP_ID,
222: CREATED_BY,
223: JTF_EVT_TYPES_ID,

Line 241: from JTF_EVT_TYPES_TL B, FND_LANGUAGES L

237: B.LAST_UPDATED_BY,
238: B.CREATION_DATE,
239: L.LANGUAGE_CODE,
240: B.SOURCE_LANG
241: from JTF_EVT_TYPES_TL B, FND_LANGUAGES L
242: where L.INSTALLED_FLAG in ('I', 'B')
243: and B.LANGUAGE = userenv('LANG')
244: and not exists
245: (select NULL

Line 246: from JTF_EVT_TYPES_TL T

242: where L.INSTALLED_FLAG in ('I', 'B')
243: and B.LANGUAGE = userenv('LANG')
244: and not exists
245: (select NULL
246: from JTF_EVT_TYPES_TL T
247: where T.JTF_EVT_TYPES_ID = B.JTF_EVT_TYPES_ID
248: and T.LANGUAGE = L.LANGUAGE_CODE);
249: end ADD_LANGUAGE;
250:

Line 258: update JTF_EVT_TYPES_TL set

254: X_OWNER in VARCHAR2 -- owner field
255: ) is
256:
257: begin
258: update JTF_EVT_TYPES_TL set
259: JTF_EVT_TYPES_DESC = x_JTF_EVT_TYPES_DESC,
260: LAST_UPDATE_DATE = sysdate,
261: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),
262: LAST_UPDATE_LOGIN = 0,