APPS.RA_TERMS_TABLE_HANDLER dependencies on RA_TERMS_TL

Line 115: insert into RA_TERMS_TL (

111: X_LAST_UPDATED_BY,
112: X_LAST_UPDATE_LOGIN
113: );
114:
115: insert into RA_TERMS_TL (
116: TERM_ID,
117: DESCRIPTION,
118: NAME,
119: LAST_UPDATE_DATE,

Line 141: from RA_TERMS_TL T

137: from FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B')
139: and not exists
140: (select NULL
141: from RA_TERMS_TL T
142: where T.TERM_ID = X_TERM_ID
143: and T.LANGUAGE = L.LANGUAGE_CODE);
144:
145: open c;

Line 225: from RA_TERMS_TL

221: cursor c1 is select
222: NAME,
223: DESCRIPTION,
224: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
225: from RA_TERMS_TL
226: where TERM_ID = X_TERM_ID
227: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
228: for update of TERM_ID nowait;
229: begin

Line 382: update RA_TERMS_TL set

378: if (sql%notfound) then
379: raise no_data_found;
380: end if;
381:
382: update RA_TERMS_TL set
383: NAME = X_NAME,
384: DESCRIPTION = X_DESCRIPTION,
385: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
386: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 401: delete from RA_TERMS_TL

397: procedure DELETE_ROW (
398: X_TERM_ID in NUMBER
399: ) is
400: begin
401: delete from RA_TERMS_TL
402: where TERM_ID = X_TERM_ID;
403:
404: if (sql%notfound) then
405: raise no_data_found;

Line 419: delete from RA_TERMS_TL T

415:
416: procedure ADD_LANGUAGE
417: is
418: begin
419: delete from RA_TERMS_TL T
420: where not exists
421: (select NULL
422: from RA_TERMS_B B
423: where B.TERM_ID = T.TERM_ID

Line 426: update RA_TERMS_TL T set (

422: from RA_TERMS_B B
423: where B.TERM_ID = T.TERM_ID
424: );
425:
426: update RA_TERMS_TL T set (
427: NAME,
428: DESCRIPTION
429: ) = (select
430: B.NAME,

Line 432: from RA_TERMS_TL B

428: DESCRIPTION
429: ) = (select
430: B.NAME,
431: B.DESCRIPTION
432: from RA_TERMS_TL B
433: where B.TERM_ID = T.TERM_ID
434: and B.LANGUAGE = T.SOURCE_LANG)
435: where (
436: T.TERM_ID,

Line 441: from RA_TERMS_TL SUBB, RA_TERMS_TL SUBT

437: T.LANGUAGE
438: ) in (select
439: SUBT.TERM_ID,
440: SUBT.LANGUAGE
441: from RA_TERMS_TL SUBB, RA_TERMS_TL SUBT
442: where SUBB.TERM_ID = SUBT.TERM_ID
443: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
444: and (SUBB.NAME <> SUBT.NAME
445: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 450: insert into RA_TERMS_TL (

446: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
447: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
448: ));
449:
450: insert into RA_TERMS_TL (
451: TERM_ID,
452: DESCRIPTION,
453: NAME,
454: LAST_UPDATE_DATE,

Line 472: from RA_TERMS_TL B, FND_LANGUAGES L

468: B.LAST_UPDATED_BY,
469: B.LAST_UPDATE_LOGIN,
470: L.LANGUAGE_CODE,
471: B.SOURCE_LANG
472: from RA_TERMS_TL B, FND_LANGUAGES L
473: where L.INSTALLED_FLAG in ('I', 'B')
474: and B.LANGUAGE = userenv('LANG')
475: and not exists
476: (select NULL

Line 477: from RA_TERMS_TL T

473: where L.INSTALLED_FLAG in ('I', 'B')
474: and B.LANGUAGE = userenv('LANG')
475: and not exists
476: (select NULL
477: from RA_TERMS_TL T
478: where T.TERM_ID = B.TERM_ID
479: and T.LANGUAGE = L.LANGUAGE_CODE);
480: end ADD_LANGUAGE;
481:

Line 619: update RA_TERMS_TL

615: begin
616:
617: -- only update rows that have not been altered by user
618:
619: update RA_TERMS_TL
620: set description = X_DESCRIPTION,
621: name = X_NAME,
622: source_lang = userenv('LANG'),
623: last_update_date = sysdate,