APPS.ICX_CAT_SHOP_STORES_PVT dependencies on ICX_CAT_SHOP_STORES_B

Line 19: FROM ICX_CAT_SHOP_STORES_B

15: X_LAST_UPDATED_BY IN NUMBER,
16: X_LAST_UPDATE_LOGIN IN NUMBER) IS
17: CURSOR C IS
18: SELECT ROWID
19: FROM ICX_CAT_SHOP_STORES_B
20: WHERE STORE_ID = X_STORE_ID;
21: BEGIN
22: INSERT INTO ICX_CAT_SHOP_STORES_B
23: (STORE_ID,

Line 22: INSERT INTO ICX_CAT_SHOP_STORES_B

18: SELECT ROWID
19: FROM ICX_CAT_SHOP_STORES_B
20: WHERE STORE_ID = X_STORE_ID;
21: BEGIN
22: INSERT INTO ICX_CAT_SHOP_STORES_B
23: (STORE_ID,
24: SEQUENCE,
25: LOCAL_CONTENT_FIRST_FLAG,
26: CREATION_DATE,

Line 96: FROM ICX_CAT_SHOP_STORES_B

92: X_IMAGE IN VARCHAR2) IS
93: CURSOR c IS
94: SELECT SEQUENCE,
95: LOCAL_CONTENT_FIRST_FLAG
96: FROM ICX_CAT_SHOP_STORES_B
97: WHERE STORE_ID = X_STORE_ID
98: FOR UPDATE OF STORE_ID NOWAIT;
99: recinfo c%ROWTYPE;
100:

Line 175: UPDATE ICX_CAT_SHOP_STORES_B

171: X_LAST_UPDATE_DATE IN DATE,
172: X_LAST_UPDATED_BY IN NUMBER,
173: X_LAST_UPDATE_LOGIN IN NUMBER) IS
174: BEGIN
175: UPDATE ICX_CAT_SHOP_STORES_B
176: SET SEQUENCE = X_SEQUENCE,
177: LOCAL_CONTENT_FIRST_FLAG = X_LOCAL_CONTENT_FIRST_FLAG,
178: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
179: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 368: DELETE FROM ICX_CAT_SHOP_STORES_B

364: THEN
365: RAISE no_data_found;
366: END IF;
367:
368: DELETE FROM ICX_CAT_SHOP_STORES_B
369: WHERE STORE_ID = X_STORE_ID;
370:
371: IF (SQL%NOTFOUND)
372: THEN

Line 381: FROM ICX_CAT_SHOP_STORES_B B

377: PROCEDURE ADD_LANGUAGE IS
378: BEGIN
379: DELETE FROM ICX_CAT_SHOP_STORES_TL T
380: WHERE NOT EXISTS (SELECT NULL
381: FROM ICX_CAT_SHOP_STORES_B B
382: WHERE B.STORE_ID = T.STORE_ID);
383:
384: UPDATE ICX_CAT_SHOP_STORES_TL T
385: SET (NAME, DESCRIPTION, LONG_DESCRIPTION, IMAGE) = (SELECT B.NAME,