APPS.ICX_CAT_SHOP_STORES_PVT dependencies on ICX_CAT_SHOP_STORES_TL

Line 41: INSERT INTO ICX_CAT_SHOP_STORES_TL

37: X_LAST_UPDATE_DATE,
38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN);
40:
41: INSERT INTO ICX_CAT_SHOP_STORES_TL
42: (STORE_ID,
43: NAME,
44: DESCRIPTION,
45: LONG_DESCRIPTION,

Line 70: FROM ICX_CAT_SHOP_STORES_TL T

66: FROM FND_LANGUAGES L
67: WHERE L.INSTALLED_FLAG IN ('I', 'B')
68: AND NOT EXISTS
69: (SELECT NULL
70: FROM ICX_CAT_SHOP_STORES_TL T
71: WHERE T.STORE_ID = X_STORE_ID
72: AND T.LANGUAGE = L.LANGUAGE_CODE);
73:
74: OPEN c;

Line 110: FROM ICX_CAT_SHOP_STORES_TL

106: decode(LANGUAGE,
107: userenv('LANG'),
108: 'Y',
109: 'N') BASELANG
110: FROM ICX_CAT_SHOP_STORES_TL
111: WHERE STORE_ID = X_STORE_ID
112: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
113: FOR UPDATE OF STORE_ID NOWAIT;
114: BEGIN

Line 188: UPDATE ICX_CAT_SHOP_STORES_TL

184: THEN
185: RAISE no_data_found;
186: END IF;
187:
188: UPDATE ICX_CAT_SHOP_STORES_TL
189: SET NAME = X_NAME,
190: DESCRIPTION = X_DESCRIPTION,
191: LONG_DESCRIPTION = X_LONG_DESCRIPTION,
192: IMAGE = X_IMAGE,

Line 231: FROM ICX_CAT_SHOP_STORES_TL

227: SELECT LAST_UPDATED_BY,
228: LAST_UPDATE_DATE
229: INTO db_luby,
230: db_ludate
231: FROM ICX_CAT_SHOP_STORES_TL
232: WHERE LANGUAGE = userenv('LANG')
233: AND STORE_ID = to_number(X_STORE_ID);
234:
235:

Line 255: UPDATE ICX_CAT_SHOP_STORES_TL

251: p_db_id => db_luby,
252: p_db_lud => db_ludate,
253: p_custom_mode => X_CUSTOM_MODE))
254: THEN
255: UPDATE ICX_CAT_SHOP_STORES_TL
256: SET NAME = nvl(X_NAME,
257: NAME),
258: DESCRIPTION = nvl(X_DESCRIPTION,
259: DESCRIPTION),

Line 306: FROM ICX_CAT_SHOP_STORES_TL

302: SELECT LAST_UPDATED_BY,
303: LAST_UPDATE_DATE
304: INTO db_luby,
305: db_ludate
306: FROM ICX_CAT_SHOP_STORES_TL
307: WHERE LANGUAGE = userenv('LANG')
308: AND STORE_ID = to_number(X_STORE_ID);
309:
310: -- Bug : 6120281 - Start

Line 360: DELETE FROM ICX_CAT_SHOP_STORES_TL

356: END LOAD_ROW;
357:
358: PROCEDURE DELETE_ROW(X_STORE_ID IN NUMBER) IS
359: BEGIN
360: DELETE FROM ICX_CAT_SHOP_STORES_TL
361: WHERE STORE_ID = X_STORE_ID;
362:
363: IF (SQL%NOTFOUND)
364: THEN

Line 379: DELETE FROM ICX_CAT_SHOP_STORES_TL T

375: END DELETE_ROW;
376:
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:

Line 384: UPDATE 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,
386: B.DESCRIPTION,
387: B.LONG_DESCRIPTION,
388: B.IMAGE

Line 389: FROM ICX_CAT_SHOP_STORES_TL B

385: SET (NAME, DESCRIPTION, LONG_DESCRIPTION, IMAGE) = (SELECT B.NAME,
386: B.DESCRIPTION,
387: B.LONG_DESCRIPTION,
388: B.IMAGE
389: FROM ICX_CAT_SHOP_STORES_TL B
390: WHERE B.STORE_ID =
391: T.STORE_ID
392: AND
393: B.LANGUAGE =

Line 398: FROM ICX_CAT_SHOP_STORES_TL SUBB,

394: T.SOURCE_LANG)
395: WHERE (T.STORE_ID, T.LANGUAGE) IN
396: (SELECT SUBT.STORE_ID,
397: SUBT.LANGUAGE
398: FROM ICX_CAT_SHOP_STORES_TL SUBB,
399: ICX_CAT_SHOP_STORES_TL SUBT
400: WHERE SUBB.STORE_ID = SUBT.STORE_ID
401: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
402: AND (SUBB.NAME <> SUBT.NAME OR

Line 399: ICX_CAT_SHOP_STORES_TL SUBT

395: WHERE (T.STORE_ID, T.LANGUAGE) IN
396: (SELECT SUBT.STORE_ID,
397: SUBT.LANGUAGE
398: FROM ICX_CAT_SHOP_STORES_TL SUBB,
399: ICX_CAT_SHOP_STORES_TL SUBT
400: WHERE SUBB.STORE_ID = SUBT.STORE_ID
401: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
402: AND (SUBB.NAME <> SUBT.NAME OR
403: (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL) OR

Line 419: INSERT INTO ICX_CAT_SHOP_STORES_TL

415: SUBB.IMAGE <> SUBT.IMAGE OR
416: (SUBB.IMAGE IS NULL AND SUBT.IMAGE IS NOT NULL) OR
417: (SUBB.IMAGE IS NOT NULL AND SUBT.IMAGE IS NULL)));
418:
419: INSERT INTO ICX_CAT_SHOP_STORES_TL
420: (STORE_ID,
421: NAME,
422: DESCRIPTION,
423: LONG_DESCRIPTION,

Line 445: FROM ICX_CAT_SHOP_STORES_TL B,

441: B.LAST_UPDATE_DATE,
442: B.LAST_UPDATE_LOGIN,
443: L.LANGUAGE_CODE,
444: B.SOURCE_LANG
445: FROM ICX_CAT_SHOP_STORES_TL B,
446: FND_LANGUAGES L
447: WHERE L.INSTALLED_FLAG IN ('I', 'B')
448: AND B.LANGUAGE = userenv('LANG')
449: AND NOT EXISTS

Line 451: FROM ICX_CAT_SHOP_STORES_TL T

447: WHERE L.INSTALLED_FLAG IN ('I', 'B')
448: AND B.LANGUAGE = userenv('LANG')
449: AND NOT EXISTS
450: (SELECT NULL
451: FROM ICX_CAT_SHOP_STORES_TL T
452: WHERE T.STORE_ID = B.STORE_ID
453: AND T.LANGUAGE = L.LANGUAGE_CODE);
454: END ADD_LANGUAGE;
455: