APPS.ICX_CAT_CATEGORIES_PKG dependencies on ICX_CAT_CATEGORIES_TL

Line 24: cursor C is select ROWID from ICX_CAT_CATEGORIES_TL

20: X_PROGRAM_APPLICATION_ID in NUMBER,
21: X_PROGRAM_ID in NUMBER,
22: X_PROGRAM_UPDATE_DATE in DATE
23: ) is
24: cursor C is select ROWID from ICX_CAT_CATEGORIES_TL
25: where RT_CATEGORY_ID = X_RT_CATEGORY_ID
26: and LANGUAGE = userenv('LANG');
27: begin
28: insert into ICX_CAT_CATEGORIES_TL (

Line 28: insert into ICX_CAT_CATEGORIES_TL (

24: cursor C is select ROWID from ICX_CAT_CATEGORIES_TL
25: where RT_CATEGORY_ID = X_RT_CATEGORY_ID
26: and LANGUAGE = userenv('LANG');
27: begin
28: insert into ICX_CAT_CATEGORIES_TL (
29: RT_CATEGORY_ID,
30: CATEGORY_NAME,
31: UPPER_CATEGORY_NAME,
32: DESCRIPTION,

Line 74: from ICX_CAT_CATEGORIES_TL T

70: from FND_LANGUAGES L
71: where L.INSTALLED_FLAG in ('I', 'B')
72: and not exists
73: (select NULL
74: from ICX_CAT_CATEGORIES_TL T
75: where T.RT_CATEGORY_ID = X_RT_CATEGORY_ID
76: and T.LANGUAGE = L.LANGUAGE_CODE);
77:
78: open c;

Line 110: from ICX_CAT_CATEGORIES_TL

106: KEY,
107: TITLE,
108: ITEM_COUNT,
109: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
110: from ICX_CAT_CATEGORIES_TL
111: where RT_CATEGORY_ID = X_RT_CATEGORY_ID
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of RT_CATEGORY_ID nowait;
114: begin

Line 158: update ICX_CAT_CATEGORIES_TL set

154: X_PROGRAM_ID in NUMBER,
155: X_PROGRAM_UPDATE_DATE in DATE
156: ) is
157: begin
158: update ICX_CAT_CATEGORIES_TL set
159: CATEGORY_NAME = X_CATEGORY_NAME,
160: UPPER_CATEGORY_NAME = upper(X_CATEGORY_NAME),
161: DESCRIPTION = X_DESCRIPTION,
162: TYPE = X_TYPE,

Line 187: delete from ICX_CAT_CATEGORIES_TL

183: procedure DELETE_ROW (
184: X_RT_CATEGORY_ID in NUMBER
185: ) is
186: begin
187: delete from ICX_CAT_CATEGORIES_TL
188: where RT_CATEGORY_ID = X_RT_CATEGORY_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 205: update ICX_CAT_CATEGORIES_tl set

201: X_UPPER_CATEGORY_NAME in VARCHAR2,
202: X_DESCRIPTION in VARCHAR2 ) IS
203: begin
204:
205: update ICX_CAT_CATEGORIES_tl set
206: category_name = X_CATEGORY_NAME,
207: upper_category_name = upper(X_CATEGORY_NAME),
208: description = X_DESCRIPTION,
209: last_update_date = sysdate,

Line 288: update ICX_CAT_CATEGORIES_TL T set (

284: procedure ADD_LANGUAGE
285: is
286: begin
287: /* comment out for bug 2085107
288: update ICX_CAT_CATEGORIES_TL T set (
289: CATEGORY_NAME,
290: UPPER_CATEGORY_NAME,
291: DESCRIPTION
292: ) = (select

Line 296: from ICX_CAT_CATEGORIES_TL B

292: ) = (select
293: B.CATEGORY_NAME,
294: upper(B.CATEGORY_NAME),
295: B.DESCRIPTION
296: from ICX_CAT_CATEGORIES_TL B
297: where B.RT_CATEGORY_ID = T.RT_CATEGORY_ID
298: and B.LANGUAGE = T.SOURCE_LANG)
299: where (
300: T.RT_CATEGORY_ID,

Line 305: from ICX_CAT_CATEGORIES_TL SUBB, ICX_CAT_CATEGORIES_TL SUBT

301: T.LANGUAGE
302: ) in (select
303: SUBT.RT_CATEGORY_ID,
304: SUBT.LANGUAGE
305: from ICX_CAT_CATEGORIES_TL SUBB, ICX_CAT_CATEGORIES_TL SUBT
306: where SUBB.RT_CATEGORY_ID = SUBT.RT_CATEGORY_ID
307: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
308: and (SUBB.CATEGORY_NAME <> SUBT.CATEGORY_NAME
309: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 315: insert into ICX_CAT_CATEGORIES_TL (

311: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
312: ));
313: */
314:
315: insert into ICX_CAT_CATEGORIES_TL (
316: RT_CATEGORY_ID,
317: CATEGORY_NAME,
318: UPPER_CATEGORY_NAME,
319: DESCRIPTION,

Line 359: from ICX_CAT_CATEGORIES_TL B, FND_LANGUAGES L

355: B.PROGRAM_ID,
356: B.PROGRAM_UPDATE_DATE,
357: L.LANGUAGE_CODE,
358: B.SOURCE_LANG
359: from ICX_CAT_CATEGORIES_TL B, FND_LANGUAGES L
360: where L.INSTALLED_FLAG in ('I', 'B')
361: and B.LANGUAGE = userenv('LANG')
362: and not exists
363: (select NULL

Line 364: from ICX_CAT_CATEGORIES_TL T

360: where L.INSTALLED_FLAG in ('I', 'B')
361: and B.LANGUAGE = userenv('LANG')
362: and not exists
363: (select NULL
364: from ICX_CAT_CATEGORIES_TL T
365: where T.RT_CATEGORY_ID = B.RT_CATEGORY_ID
366: and T.LANGUAGE = L.LANGUAGE_CODE);
367:
368: end ADD_LANGUAGE;