APPS.CS_KB_SOLN_CATEGORIES_PKG dependencies on CS_KB_SOLN_CATEGORIES_TL

Line 62: insert into CS_KB_SOLN_CATEGORIES_TL

58: X_VISIBILITY_ID
59: );
60:
61: /* create translation table record(s) */
62: insert into CS_KB_SOLN_CATEGORIES_TL
63: (
64: CATEGORY_ID,
65: NAME,
66: DESCRIPTION,

Line 90: from CS_KB_SOLN_CATEGORIES_TL T

86: from FND_LANGUAGES L
87: where L.INSTALLED_FLAG in ('I', 'B')
88: and not exists
89: (select NULL
90: from CS_KB_SOLN_CATEGORIES_TL T
91: where T.CATEGORY_ID = X_CATEGORY_ID
92: and T.LANGUAGE = L.LANGUAGE_CODE);
93:
94:

Line 134: update cs_kb_soln_categories_tl

130: then
131: raise NO_DATA_FOUND;
132: end if;
133:
134: update cs_kb_soln_categories_tl
135: set
136: name = X_NAME,
137: description = X_DESCRIPTION,
138: last_update_date = X_LAST_UPDATE_DATE,

Line 158: delete from cs_kb_soln_categories_tl

154: X_CATEGORY_ID in NUMBER
155: )
156: is
157: begin
158: delete from cs_kb_soln_categories_tl
159: where category_id = X_CATEGORY_ID;
160:
161: if (sql%notfound) then
162: raise no_data_found;

Line 194: delete from CS_KB_SOLN_CATEGORIES_TL T

190:
191: procedure ADD_LANGUAGE
192: is
193: begin
194: delete from CS_KB_SOLN_CATEGORIES_TL T
195: where not exists
196: (select NULL
197: from CS_KB_SOLN_CATEGORIES_B B
198: where B.CATEGORY_ID = T.CATEGORY_ID

Line 201: update CS_KB_SOLN_CATEGORIES_TL T

197: from CS_KB_SOLN_CATEGORIES_B B
198: where B.CATEGORY_ID = T.CATEGORY_ID
199: );
200:
201: update CS_KB_SOLN_CATEGORIES_TL T
202: set ( NAME, DESCRIPTION ) =
203: ( select
204: T2.NAME,
205: T2.DESCRIPTION

Line 206: from CS_KB_SOLN_CATEGORIES_TL T2

202: set ( NAME, DESCRIPTION ) =
203: ( select
204: T2.NAME,
205: T2.DESCRIPTION
206: from CS_KB_SOLN_CATEGORIES_TL T2
207: where T2.CATEGORY_ID = T.CATEGORY_ID
208: and T2.LANGUAGE = T.SOURCE_LANG
209: )
210: where

Line 218: from CS_KB_SOLN_CATEGORIES_TL SUBB, CS_KB_SOLN_CATEGORIES_TL SUBT

214: ) in
215: ( select
216: SUBT.CATEGORY_ID,
217: SUBT.LANGUAGE
218: from CS_KB_SOLN_CATEGORIES_TL SUBB, CS_KB_SOLN_CATEGORIES_TL SUBT
219: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.NAME <> SUBT.NAME
222: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 229: insert into CS_KB_SOLN_CATEGORIES_TL

225: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
226: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null))
227: );
228:
229: insert into CS_KB_SOLN_CATEGORIES_TL
230: (
231: CATEGORY_ID,
232: NAME,
233: DESCRIPTION,

Line 252: from CS_KB_SOLN_CATEGORIES_TL T, FND_LANGUAGES L

248: T.LAST_UPDATED_BY,
249: T.LAST_UPDATE_LOGIN,
250: L.LANGUAGE_CODE,
251: T.SOURCE_LANG
252: from CS_KB_SOLN_CATEGORIES_TL T, FND_LANGUAGES L
253: where L.INSTALLED_FLAG in ('I', 'B')
254: and T.LANGUAGE = userenv('LANG')
255: and not exists
256: (select NULL

Line 257: from CS_KB_SOLN_CATEGORIES_TL T2

253: where L.INSTALLED_FLAG in ('I', 'B')
254: and T.LANGUAGE = userenv('LANG')
255: and not exists
256: (select NULL
257: from CS_KB_SOLN_CATEGORIES_TL T2
258: where T2.CATEGORY_ID = T.CATEGORY_ID
259: and T2.LANGUAGE = L.LANGUAGE_CODE);
260: end ADD_LANGUAGE;
261:

Line 271: update CS_KB_SOLN_CATEGORIES_TL

267: X_OWNER in VARCHAR2
268: )
269: is
270: begin
271: update CS_KB_SOLN_CATEGORIES_TL
272: set
273: name = X_NAME,
274: description = X_DESCRIPTION,
275: last_update_date = sysdate,