APPS.JTF_AE_PROFMAPS dependencies on JTF_PROFILE_MAPPINGS_TL

Line 42: insert into JTF_PROFILE_MAPPINGS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into JTF_PROFILE_MAPPINGS_TL (
43: LAST_UPDATED_BY,
44: CREATION_DATE,
45: CREATED_BY,
46: LAST_UPDATE_DATE,

Line 70: from JTF_PROFILE_MAPPINGS_TL T

66: from FND_LANGUAGES L
67: where L.INSTALLED_FLAG in ('I', 'B')
68: and not exists
69: (select NULL
70: from JTF_PROFILE_MAPPINGS_TL T
71: where T.PROFILE_MAPPINGS_ID = X_PROFILE_MAPPINGS_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73:
74: open c;

Line 104: from JTF_PROFILE_MAPPINGS_TL

100: cursor c1 is select
101: BASETABLE,
102: PROFILENAME,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from JTF_PROFILE_MAPPINGS_TL
105: where PROFILE_MAPPINGS_ID = X_PROFILE_MAPPINGS_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of PROFILE_MAPPINGS_ID nowait;
108: begin

Line 171: update JTF_PROFILE_MAPPINGS_TL set

167: if (sql%notfound) then
168: raise no_data_found;
169: end if;
170:
171: update JTF_PROFILE_MAPPINGS_TL set
172: BASETABLE = X_BASETABLE,
173: PROFILENAME = X_PROFILENAME,
174: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
175: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 190: delete from JTF_PROFILE_MAPPINGS_TL

186: procedure DELETE_ROW (
187: X_PROFILE_MAPPINGS_ID in NUMBER
188: ) is
189: begin
190: delete from JTF_PROFILE_MAPPINGS_TL
191: where PROFILE_MAPPINGS_ID = X_PROFILE_MAPPINGS_ID;
192:
193: if (sql%notfound) then
194: raise no_data_found;

Line 208: delete from JTF_PROFILE_MAPPINGS_TL T

204:
205: procedure ADD_LANGUAGE
206: is
207: begin
208: delete from JTF_PROFILE_MAPPINGS_TL T
209: where not exists
210: (select NULL
211: from JTF_PROFILE_MAPPINGS_B B
212: where B.PROFILE_MAPPINGS_ID = T.PROFILE_MAPPINGS_ID

Line 215: update JTF_PROFILE_MAPPINGS_TL T set (

211: from JTF_PROFILE_MAPPINGS_B B
212: where B.PROFILE_MAPPINGS_ID = T.PROFILE_MAPPINGS_ID
213: );
214:
215: update JTF_PROFILE_MAPPINGS_TL T set (
216: BASETABLE,
217: PROFILENAME
218: ) = (select
219: B.BASETABLE,

Line 221: from JTF_PROFILE_MAPPINGS_TL B

217: PROFILENAME
218: ) = (select
219: B.BASETABLE,
220: B.PROFILENAME
221: from JTF_PROFILE_MAPPINGS_TL B
222: where B.PROFILE_MAPPINGS_ID = T.PROFILE_MAPPINGS_ID
223: and B.LANGUAGE = T.SOURCE_LANG)
224: where (
225: T.PROFILE_MAPPINGS_ID,

Line 230: from JTF_PROFILE_MAPPINGS_TL SUBB, JTF_PROFILE_MAPPINGS_TL SUBT

226: T.LANGUAGE
227: ) in (select
228: SUBT.PROFILE_MAPPINGS_ID,
229: SUBT.LANGUAGE
230: from JTF_PROFILE_MAPPINGS_TL SUBB, JTF_PROFILE_MAPPINGS_TL SUBT
231: where SUBB.PROFILE_MAPPINGS_ID = SUBT.PROFILE_MAPPINGS_ID
232: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
233: and (SUBB.BASETABLE <> SUBT.BASETABLE
234: or (SUBB.BASETABLE is null and SUBT.BASETABLE is not null)

Line 241: insert into JTF_PROFILE_MAPPINGS_TL (

237: or (SUBB.PROFILENAME is null and SUBT.PROFILENAME is not null)
238: or (SUBB.PROFILENAME is not null and SUBT.PROFILENAME is null)
239: ));
240:
241: insert into JTF_PROFILE_MAPPINGS_TL (
242: LAST_UPDATED_BY,
243: CREATION_DATE,
244: CREATED_BY,
245: LAST_UPDATE_DATE,

Line 267: from JTF_PROFILE_MAPPINGS_TL B, FND_LANGUAGES L

263: B.DESCRIPTION,
264: B.LAST_UPDATE_LOGIN,
265: L.LANGUAGE_CODE,
266: B.SOURCE_LANG
267: from JTF_PROFILE_MAPPINGS_TL B, FND_LANGUAGES L
268: where L.INSTALLED_FLAG in ('I', 'B')
269: and B.LANGUAGE = userenv('LANG')
270: and not exists
271: (select NULL

Line 272: from JTF_PROFILE_MAPPINGS_TL T

268: where L.INSTALLED_FLAG in ('I', 'B')
269: and B.LANGUAGE = userenv('LANG')
270: and not exists
271: (select NULL
272: from JTF_PROFILE_MAPPINGS_TL T
273: where T.PROFILE_MAPPINGS_ID = B.PROFILE_MAPPINGS_ID
274: and T.LANGUAGE = L.LANGUAGE_CODE);
275: end ADD_LANGUAGE;
276:

Line 285: update JTF_PROFILE_MAPPINGS_TL set

281: X_OWNER in VARCHAR2
282: ) is
283: begin
284:
285: update JTF_PROFILE_MAPPINGS_TL set
286: BASETABLE = X_BASETABLE,
287: PROFILENAME = X_PROFILENAME,
288: SOURCE_LANG = userenv('LANG'),
289: last_update_date = sysdate,