APPS.ICX_CAT_CONTENT_ZONES_PVT dependencies on ICX_CAT_CONTENT_ZONES_TL

Line 56: INSERT INTO ICX_CAT_CONTENT_ZONES_TL

52: X_LAST_UPDATE_DATE,
53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN);
55:
56: INSERT INTO ICX_CAT_CONTENT_ZONES_TL
57: (ZONE_ID,
58: NAME,
59: DESCRIPTION,
60: IMAGE,

Line 83: FROM ICX_CAT_CONTENT_ZONES_TL T

79: FROM FND_LANGUAGES L
80: WHERE L.INSTALLED_FLAG IN ('I', 'B')
81: AND NOT EXISTS
82: (SELECT NULL
83: FROM ICX_CAT_CONTENT_ZONES_TL T
84: WHERE T.ZONE_ID = X_ZONE_ID
85: AND T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: OPEN c;

Line 114: UPDATE ICX_CAT_CONTENT_ZONES_TL

110: X_LAST_UPDATE_DATE IN DATE,
111: X_LAST_UPDATED_BY IN NUMBER,
112: X_LAST_UPDATE_LOGIN IN NUMBER) IS
113: BEGIN
114: UPDATE ICX_CAT_CONTENT_ZONES_TL
115: SET NAME = X_NAME,
116: DESCRIPTION = X_DESCRIPTION,
117: IMAGE = X_IMAGE,
118: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 127: INSERT INTO ICX_CAT_CONTENT_ZONES_TL

123: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
124:
125: IF (SQL%NOTFOUND)
126: THEN
127: INSERT INTO ICX_CAT_CONTENT_ZONES_TL
128: (ZONE_ID,
129: NAME,
130: DESCRIPTION,
131: IMAGE,

Line 178: FROM ICX_CAT_CONTENT_ZONES_TL

174: SELECT LAST_UPDATED_BY,
175: LAST_UPDATE_DATE
176: INTO db_luby,
177: db_ludate
178: FROM ICX_CAT_CONTENT_ZONES_TL
179: WHERE LANGUAGE = userenv('LANG')
180: AND ZONE_ID = to_number(X_ZONE_ID);
181:
182: -- Bug : 6120281 - Start

Line 201: UPDATE ICX_CAT_CONTENT_ZONES_tl

197: p_db_id => db_luby,
198: p_db_lud => db_ludate,
199: p_custom_mode => X_CUSTOM_MODE))
200: THEN
201: UPDATE ICX_CAT_CONTENT_ZONES_tl
202: SET NAME = nvl(X_NAME,
203: NAME),
204: description = nvl(X_DESCRIPTION,
205: DESCRIPTION),

Line 253: FROM ICX_CAT_CONTENT_ZONES_TL

249: SELECT LAST_UPDATED_BY,
250: LAST_UPDATE_DATE
251: INTO db_luby,
252: db_ludate
253: FROM ICX_CAT_CONTENT_ZONES_TL
254: WHERE LANGUAGE = userenv('LANG')
255: AND ZONE_ID = to_number(X_ZONE_ID);
256:
257: -- Bug#3219138

Line 337: DELETE FROM ICX_CAT_CONTENT_ZONES_TL T

333: END LOAD_ROW;
334:
335: PROCEDURE ADD_LANGUAGE IS
336: BEGIN
337: DELETE FROM ICX_CAT_CONTENT_ZONES_TL T
338: WHERE NOT EXISTS (SELECT NULL
339: FROM ICX_CAT_CONTENT_ZONES_B B
340: WHERE B.ZONE_ID = T.ZONE_ID);
341:

Line 342: INSERT INTO ICX_CAT_CONTENT_ZONES_TL

338: WHERE NOT EXISTS (SELECT NULL
339: FROM ICX_CAT_CONTENT_ZONES_B B
340: WHERE B.ZONE_ID = T.ZONE_ID);
341:
342: INSERT INTO ICX_CAT_CONTENT_ZONES_TL
343: (LAST_UPDATE_LOGIN,
344: LAST_UPDATE_DATE,
345: LAST_UPDATED_BY,
346: CREATION_DATE,

Line 365: FROM ICX_CAT_CONTENT_ZONES_TL B,

361: B.DESCRIPTION,
362: B.IMAGE,
363: L.LANGUAGE_CODE,
364: B.SOURCE_LANG
365: FROM ICX_CAT_CONTENT_ZONES_TL B,
366: FND_LANGUAGES L
367: WHERE L.INSTALLED_FLAG IN ('I', 'B')
368: AND B.LANGUAGE = userenv('LANG')
369: AND NOT EXISTS

Line 371: FROM ICX_CAT_CONTENT_ZONES_TL T

367: WHERE L.INSTALLED_FLAG IN ('I', 'B')
368: AND B.LANGUAGE = userenv('LANG')
369: AND NOT EXISTS
370: (SELECT NULL
371: FROM ICX_CAT_CONTENT_ZONES_TL T
372: WHERE T.ZONE_ID = B.ZONE_ID
373: AND T.LANGUAGE = L.LANGUAGE_CODE);
374: END ADD_LANGUAGE;
375: