APPS.JTF_AE_PROFPROPS dependencies on JTF_PROFILEPROPERTIES_TL

Line 51: insert into JTF_PROFILEPROPERTIES_TL (

47: X_LAST_UPDATED_BY,
48: X_LAST_UPDATE_LOGIN
49: );
50:
51: insert into JTF_PROFILEPROPERTIES_TL (
52: SECURITY_GROUP_ID,
53: PROFILEPROPERTIES_ID,
54: PROPERTYNAME,
55: PROP_DESCRIPTION,

Line 79: from JTF_PROFILEPROPERTIES_TL T

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

Line 119: from JTF_PROFILEPROPERTIES_TL

115: cursor c1 is select
116: PROPERTYNAME,
117: PROP_DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from JTF_PROFILEPROPERTIES_TL
120: where PROFILEPROPERTIES_ID = X_PROFILEPROPERTIES_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of PROFILEPROPERTIES_ID nowait;
123: begin

Line 195: update JTF_PROFILEPROPERTIES_TL set

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: update JTF_PROFILEPROPERTIES_TL set
196: PROPERTYNAME = X_PROPERTYNAME,
197: PROP_DESCRIPTION = X_PROP_DESCRIPTION,
198: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
199: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 214: delete from JTF_PROFILEPROPERTIES_TL

210: procedure DELETE_ROW (
211: X_PROFILEPROPERTIES_ID in NUMBER
212: ) is
213: begin
214: delete from JTF_PROFILEPROPERTIES_TL
215: where PROFILEPROPERTIES_ID = X_PROFILEPROPERTIES_ID;
216:
217: if (sql%notfound) then
218: raise no_data_found;

Line 232: delete from JTF_PROFILEPROPERTIES_TL T

228:
229: procedure ADD_LANGUAGE
230: is
231: begin
232: delete from JTF_PROFILEPROPERTIES_TL T
233: where not exists
234: (select NULL
235: from JTF_PROFILEPROPERTIES_B B
236: where B.PROFILEPROPERTIES_ID = T.PROFILEPROPERTIES_ID

Line 239: update JTF_PROFILEPROPERTIES_TL T set (

235: from JTF_PROFILEPROPERTIES_B B
236: where B.PROFILEPROPERTIES_ID = T.PROFILEPROPERTIES_ID
237: );
238:
239: update JTF_PROFILEPROPERTIES_TL T set (
240: PROPERTYNAME,
241: PROP_DESCRIPTION
242: ) = (select
243: B.PROPERTYNAME,

Line 245: from JTF_PROFILEPROPERTIES_TL B

241: PROP_DESCRIPTION
242: ) = (select
243: B.PROPERTYNAME,
244: B.PROP_DESCRIPTION
245: from JTF_PROFILEPROPERTIES_TL B
246: where B.PROFILEPROPERTIES_ID = T.PROFILEPROPERTIES_ID
247: and B.LANGUAGE = T.SOURCE_LANG)
248: where (
249: T.PROFILEPROPERTIES_ID,

Line 254: from JTF_PROFILEPROPERTIES_TL SUBB, JTF_PROFILEPROPERTIES_TL SUBT

250: T.LANGUAGE
251: ) in (select
252: SUBT.PROFILEPROPERTIES_ID,
253: SUBT.LANGUAGE
254: from JTF_PROFILEPROPERTIES_TL SUBB, JTF_PROFILEPROPERTIES_TL SUBT
255: where SUBB.PROFILEPROPERTIES_ID = SUBT.PROFILEPROPERTIES_ID
256: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
257: and (SUBB.PROPERTYNAME <> SUBT.PROPERTYNAME
258: or (SUBB.PROPERTYNAME is null and SUBT.PROPERTYNAME is not null)

Line 265: insert into JTF_PROFILEPROPERTIES_TL (

261: or (SUBB.PROP_DESCRIPTION is null and SUBT.PROP_DESCRIPTION is not null)
262: or (SUBB.PROP_DESCRIPTION is not null and SUBT.PROP_DESCRIPTION is null)
263: ));
264:
265: insert into JTF_PROFILEPROPERTIES_TL (
266: SECURITY_GROUP_ID,
267: PROFILEPROPERTIES_ID,
268: PROPERTYNAME,
269: DESCRIPTION,

Line 291: from JTF_PROFILEPROPERTIES_TL B, FND_LANGUAGES L

287: B.LAST_UPDATED_BY,
288: B.LAST_UPDATE_LOGIN,
289: L.LANGUAGE_CODE,
290: B.SOURCE_LANG
291: from JTF_PROFILEPROPERTIES_TL B, FND_LANGUAGES L
292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL

Line 296: from JTF_PROFILEPROPERTIES_TL T

292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL
296: from JTF_PROFILEPROPERTIES_TL T
297: where T.PROFILEPROPERTIES_ID = B.PROFILEPROPERTIES_ID
298: and T.LANGUAGE = L.LANGUAGE_CODE);
299: end ADD_LANGUAGE;
300:

Line 309: update JTF_PROFILEPROPERTIES_TL set

305: X_OWNER in VARCHAR2
306: ) is
307:
308: begin
309: update JTF_PROFILEPROPERTIES_TL set
310: PROPERTYNAME = X_PROPERTYNAME,
311: PROP_DESCRIPTION = X_PROP_DESCRIPTION,
312: SOURCE_LANG = userenv('LANG'),
313: last_update_date = sysdate,