APPS.ICX_CAT_CATEGORIES_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 23: cursor C is select ROWID from ICX_CAT_CATEGORIES_TL

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

Line 28: insert into ICX_CAT_CATEGORIES_TL (

24: where RT_CATEGORY_ID = X_RT_CATEGORY_ID
25: and LANGUAGE = userenv('LANG');
26: X_ROWID VARCHAR2(64);
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 222: FROM ICX_CAT_CATEGORIES_TL

218: SELECT LAST_UPDATED_BY,
219: LAST_UPDATE_DATE
220: INTO DB_LUBY,
221: DB_LUDATE
222: FROM ICX_CAT_CATEGORIES_TL
223: WHERE LANGUAGE = USERENV('LANG')
224: AND RT_CATEGORY_ID = TO_NUMBER(X_RT_CATEGORY_ID); -- Update record, honoring customization mode.
225: -- Record should be updated only if:
226: -- a. CUSTOM_MODE = FORCE, or

Line 235: UPDATE ICX_CAT_CATEGORIES_TL

231: P_FILE_LUD => F_LUDATE,
232: P_DB_ID => DB_LUBY,
233: P_DB_LUD => DB_LUDATE,
234: P_CUSTOM_MODE => X_CUSTOM_MODE)) THEN
235: UPDATE ICX_CAT_CATEGORIES_TL
236: SET CATEGORY_NAME = X_CATEGORY_NAME,
237: UPPER_CATEGORY_NAME = UPPER(X_CATEGORY_NAME),
238: DESCRIPTION = X_DESCRIPTION,
239: LAST_UPDATE_DATE = SYSDATE,

Line 283: FROM ICX_CAT_CATEGORIES_TL

279: SELECT LAST_UPDATED_BY,
280: LAST_UPDATE_DATE
281: INTO DB_LUBY,
282: DB_LUDATE
283: FROM ICX_CAT_CATEGORIES_TL
284: WHERE LANGUAGE = USERENV('LANG')
285: AND RT_CATEGORY_ID = TO_NUMBER(X_RT_CATEGORY_ID); -- Update record, honoring customization mode.
286: -- Record should be updated only if:
287: -- a. CUSTOM_MODE = FORCE, or

Line 340: insert into ICX_CAT_CATEGORIES_TL (

336:
337: procedure ADD_LANGUAGE
338: is
339: begin
340: insert into ICX_CAT_CATEGORIES_TL (
341: RT_CATEGORY_ID,
342: CATEGORY_NAME,
343: UPPER_CATEGORY_NAME,
344: DESCRIPTION,

Line 384: from ICX_CAT_CATEGORIES_TL B, FND_LANGUAGES L

380: B.PROGRAM_ID,
381: B.PROGRAM_UPDATE_DATE,
382: L.LANGUAGE_CODE,
383: B.SOURCE_LANG
384: from ICX_CAT_CATEGORIES_TL B, FND_LANGUAGES L
385: where L.INSTALLED_FLAG in ('I', 'B')
386: and B.LANGUAGE = userenv('LANG')
387: and not exists
388: (select NULL

Line 389: from ICX_CAT_CATEGORIES_TL T

385: where L.INSTALLED_FLAG in ('I', 'B')
386: and B.LANGUAGE = userenv('LANG')
387: and not exists
388: (select NULL
389: from ICX_CAT_CATEGORIES_TL T
390: where T.RT_CATEGORY_ID = B.RT_CATEGORY_ID
391: and T.LANGUAGE = L.LANGUAGE_CODE);
392:
393: end ADD_LANGUAGE;