APPS.CS_KB_AUTOLINKS_PKG dependencies on CS_KB_AUTOLINKS_TL

Line 143: insert into CS_KB_AUTOLINKS_TL (

139: X_LAST_UPDATED_BY,
140: X_LAST_UPDATE_LOGIN
141: );
142:
143: insert into CS_KB_AUTOLINKS_TL (
144: TOKEN,
145: TOKEN_START_DELIM_CHARS,
146: TOKEN_END_DELIM_CHARS,
147: PARAM_END_DELIM_CHARS,

Line 177: from CS_KB_AUTOLINKS_TL T

173: from FND_LANGUAGES L
174: where L.INSTALLED_FLAG in ('I', 'B')
175: and not exists
176: (select NULL
177: from CS_KB_AUTOLINKS_TL T
178: where T.AUTOLINK_ID = X_AUTOLINK_ID
179: and T.LANGUAGE = L.LANGUAGE_CODE);
180:
181: open c;

Line 284: from CS_KB_AUTOLINKS_TL

280: TOKEN_START_DELIM_CHARS,
281: TOKEN_END_DELIM_CHARS,
282: PARAM_END_DELIM_CHARS,
283: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
284: from CS_KB_AUTOLINKS_TL
285: where AUTOLINK_ID = X_AUTOLINK_ID
286: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
287: for update of AUTOLINK_ID nowait;
288: begin

Line 477: update CS_KB_AUTOLINKS_TL set

473: if (sql%notfound) then
474: raise no_data_found;
475: end if;
476:
477: update CS_KB_AUTOLINKS_TL set
478: NAME = X_NAME,
479: DESCRIPTION = X_DESCRIPTION,
480: TOKEN = X_TOKEN,
481: TOKEN_START_DELIM_CHARS = X_TOKEN_START_DELIM_CHARS,

Line 500: delete from CS_KB_AUTOLINKS_TL

496: procedure DELETE_ROW (
497: X_AUTOLINK_ID in NUMBER
498: ) is
499: begin
500: delete from CS_KB_AUTOLINKS_TL
501: where AUTOLINK_ID = X_AUTOLINK_ID;
502:
503: if (sql%notfound) then
504: raise no_data_found;

Line 518: delete from CS_KB_AUTOLINKS_TL T

514:
515: procedure ADD_LANGUAGE
516: is
517: begin
518: delete from CS_KB_AUTOLINKS_TL T
519: where not exists
520: (select NULL
521: from CS_KB_AUTOLINKS_B B
522: where B.AUTOLINK_ID = T.AUTOLINK_ID

Line 525: update CS_KB_AUTOLINKS_TL T set (

521: from CS_KB_AUTOLINKS_B B
522: where B.AUTOLINK_ID = T.AUTOLINK_ID
523: );
524:
525: update CS_KB_AUTOLINKS_TL T set (
526: NAME,
527: DESCRIPTION,
528: TOKEN,
529: TOKEN_START_DELIM_CHARS,

Line 539: from CS_KB_AUTOLINKS_TL B

535: B.TOKEN,
536: B.TOKEN_START_DELIM_CHARS,
537: B.TOKEN_END_DELIM_CHARS,
538: B.PARAM_END_DELIM_CHARS
539: from CS_KB_AUTOLINKS_TL B
540: where B.AUTOLINK_ID = T.AUTOLINK_ID
541: and B.LANGUAGE = T.SOURCE_LANG)
542: where (
543: T.AUTOLINK_ID,

Line 548: from CS_KB_AUTOLINKS_TL SUBB, CS_KB_AUTOLINKS_TL SUBT

544: T.LANGUAGE
545: ) in (select
546: SUBT.AUTOLINK_ID,
547: SUBT.LANGUAGE
548: from CS_KB_AUTOLINKS_TL SUBB, CS_KB_AUTOLINKS_TL SUBT
549: where SUBB.AUTOLINK_ID = SUBT.AUTOLINK_ID
550: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
551: and (SUBB.NAME <> SUBT.NAME
552: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 567: insert into CS_KB_AUTOLINKS_TL (

563: or (SUBB.PARAM_END_DELIM_CHARS is null and SUBT.PARAM_END_DELIM_CHARS is not null)
564: or (SUBB.PARAM_END_DELIM_CHARS is not null and SUBT.PARAM_END_DELIM_CHARS is null)
565: ));
566:
567: insert into CS_KB_AUTOLINKS_TL (
568: TOKEN,
569: TOKEN_START_DELIM_CHARS,
570: TOKEN_END_DELIM_CHARS,
571: PARAM_END_DELIM_CHARS,

Line 597: from CS_KB_AUTOLINKS_TL B, FND_LANGUAGES L

593: B.NAME,
594: B.DESCRIPTION,
595: L.LANGUAGE_CODE,
596: B.SOURCE_LANG
597: from CS_KB_AUTOLINKS_TL B, FND_LANGUAGES L
598: where L.INSTALLED_FLAG in ('I', 'B')
599: and B.LANGUAGE = userenv('LANG')
600: and not exists
601: (select NULL

Line 602: from CS_KB_AUTOLINKS_TL T

598: where L.INSTALLED_FLAG in ('I', 'B')
599: and B.LANGUAGE = userenv('LANG')
600: and not exists
601: (select NULL
602: from CS_KB_AUTOLINKS_TL T
603: where T.AUTOLINK_ID = B.AUTOLINK_ID
604: and T.LANGUAGE = L.LANGUAGE_CODE);
605: end ADD_LANGUAGE;
606: