APPS.JTF_RS_TABLE_ATTRIBUTES_PKG dependencies on JTF_RS_TABLE_ATTRIBUTES_TL

Line 90: insert into JTF_RS_TABLE_ATTRIBUTES_TL (

86: X_LAST_UPDATED_BY,
87: X_LAST_UPDATE_LOGIN
88: );
89:
90: insert into JTF_RS_TABLE_ATTRIBUTES_TL (
91: ATTRIBUTE_ID,
92: USER_ATTRIBUTE_NAME,
93: CREATED_BY,
94: CREATION_DATE,

Line 114: from JTF_RS_TABLE_ATTRIBUTES_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from JTF_RS_TABLE_ATTRIBUTES_TL T
115: where T.ATTRIBUTE_ID = X_ATTRIBUTE_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 215: update JTF_RS_TABLE_ATTRIBUTES_TL set

211: if (sql%notfound) then
212: raise no_data_found;
213: end if;
214:
215: update JTF_RS_TABLE_ATTRIBUTES_TL set
216: USER_ATTRIBUTE_NAME = X_USER_ATTRIBUTE_NAME,
217: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
219: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 233: delete from JTF_RS_TABLE_ATTRIBUTES_TL

229: procedure DELETE_ROW (
230: X_ATTRIBUTE_ID in NUMBER
231: ) is
232: begin
233: delete from JTF_RS_TABLE_ATTRIBUTES_TL
234: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
235:
236: if (sql%notfound) then
237: raise no_data_found;

Line 251: delete from JTF_RS_TABLE_ATTRIBUTES_TL T

247:
248: procedure ADD_LANGUAGE
249: is
250: begin
251: delete from JTF_RS_TABLE_ATTRIBUTES_TL T
252: where not exists
253: (select NULL
254: from JTF_RS_TABLE_ATTRIBUTES_B B
255: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 258: update JTF_RS_TABLE_ATTRIBUTES_TL T set (

254: from JTF_RS_TABLE_ATTRIBUTES_B B
255: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
256: );
257:
258: update JTF_RS_TABLE_ATTRIBUTES_TL T set (
259: USER_ATTRIBUTE_NAME
260: ) = (select
261: B.USER_ATTRIBUTE_NAME
262: from JTF_RS_TABLE_ATTRIBUTES_TL B

Line 262: from JTF_RS_TABLE_ATTRIBUTES_TL B

258: update JTF_RS_TABLE_ATTRIBUTES_TL T set (
259: USER_ATTRIBUTE_NAME
260: ) = (select
261: B.USER_ATTRIBUTE_NAME
262: from JTF_RS_TABLE_ATTRIBUTES_TL B
263: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
264: and B.LANGUAGE = T.SOURCE_LANG)
265: where (
266: T.ATTRIBUTE_ID,

Line 271: from JTF_RS_TABLE_ATTRIBUTES_TL SUBB, JTF_RS_TABLE_ATTRIBUTES_TL SUBT

267: T.LANGUAGE
268: ) in (select
269: SUBT.ATTRIBUTE_ID,
270: SUBT.LANGUAGE
271: from JTF_RS_TABLE_ATTRIBUTES_TL SUBB, JTF_RS_TABLE_ATTRIBUTES_TL SUBT
272: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
273: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
274: and (SUBB.USER_ATTRIBUTE_NAME <> SUBT.USER_ATTRIBUTE_NAME
275: ));

Line 277: insert into JTF_RS_TABLE_ATTRIBUTES_TL (

273: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
274: and (SUBB.USER_ATTRIBUTE_NAME <> SUBT.USER_ATTRIBUTE_NAME
275: ));
276:
277: insert into JTF_RS_TABLE_ATTRIBUTES_TL (
278: ATTRIBUTE_ID,
279: USER_ATTRIBUTE_NAME,
280: CREATED_BY,
281: CREATION_DATE,

Line 297: from JTF_RS_TABLE_ATTRIBUTES_TL B, FND_LANGUAGES L

293: B.LAST_UPDATE_DATE,
294: B.LAST_UPDATE_LOGIN,
295: L.LANGUAGE_CODE,
296: B.SOURCE_LANG
297: from JTF_RS_TABLE_ATTRIBUTES_TL B, FND_LANGUAGES L
298: where L.INSTALLED_FLAG in ('I', 'B')
299: and B.LANGUAGE = userenv('LANG')
300: and not exists
301: (select NULL

Line 302: from JTF_RS_TABLE_ATTRIBUTES_TL T

298: where L.INSTALLED_FLAG in ('I', 'B')
299: and B.LANGUAGE = userenv('LANG')
300: and not exists
301: (select NULL
302: from JTF_RS_TABLE_ATTRIBUTES_TL T
303: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
304: and T.LANGUAGE = L.LANGUAGE_CODE);
305: end ADD_LANGUAGE;
306:

Line 316: update jtf_rs_table_attributes_tl set

312: x_last_update_login in number)
313: is
314: begin
315:
316: update jtf_rs_table_attributes_tl set
317: user_attribute_name = nvl(x_user_attribute_name,user_attribute_name),
318: last_update_date = nvl(x_last_update_date,sysdate),
319: last_updated_by = x_last_updated_by,
320: last_update_login = 0,