APPS.ICX_CAT_CONTENT_ZONES_PVT dependencies on ICX_CAT_CONTENT_ZONES_B

Line 23: FROM ICX_CAT_CONTENT_ZONES_B

19: X_LAST_UPDATED_BY IN NUMBER,
20: X_LAST_UPDATE_LOGIN IN NUMBER) IS
21: CURSOR C IS
22: SELECT ROWID
23: FROM ICX_CAT_CONTENT_ZONES_B
24: WHERE ZONE_ID = X_ZONE_ID;
25: BEGIN
26:
27: INSERT INTO ICX_CAT_CONTENT_ZONES_B

Line 27: INSERT INTO ICX_CAT_CONTENT_ZONES_B

23: FROM ICX_CAT_CONTENT_ZONES_B
24: WHERE ZONE_ID = X_ZONE_ID;
25: BEGIN
26:
27: INSERT INTO ICX_CAT_CONTENT_ZONES_B
28: (ZONE_ID,
29: TYPE,
30: URL,
31: SUPPLIER_ATTRIBUTE_ACTION_FLAG,

Line 261: UPDATE ICX_CAT_CONTENT_ZONES_B

257: -- Bug#3219138
258: -- Always update the Type supported
259: -- irrespective of customization. Cst should not change the
260: -- type supported values.
261: UPDATE ICX_CAT_CONTENT_ZONES_B
262: SET TYPE = X_TYPE,
263: URL = X_URL,
264: SUPPLIER_ATTRIBUTE_ACTION_FLAG = X_SUPPLIER_ATTRIBUTE_ACTION,
265: CATEGORY_ATTRIBUTE_ACTION_FLAG = X_CATEGORY_ATTRIBUTE_ACTION,

Line 339: FROM ICX_CAT_CONTENT_ZONES_B B

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:
342: INSERT INTO ICX_CAT_CONTENT_ZONES_TL
343: (LAST_UPDATE_LOGIN,