APPS.JTF_STORE_GRP dependencies on JTF_STORES_TL

Line 88: insert into JTF_STORES_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into JTF_STORES_TL (
89: SECURITY_GROUP_ID,
90: OBJECT_VERSION_NUMBER,
91: STORE_ID,
92: CREATED_BY,

Line 118: from JTF_STORES_TL T

114: from FND_LANGUAGES L
115: where L.INSTALLED_FLAG in ('I', 'B')
116: and not exists
117: (select NULL
118: from JTF_STORES_TL T
119: where T.STORE_ID = X_STORE_ID
120: and T.LANGUAGE = L.LANGUAGE_CODE);
121:
122: open c;

Line 183: from JTF_STORES_TL

179: cursor c1 is select
180: STORE_NAME,
181: STORE_DESCRIPTION,
182: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
183: from JTF_STORES_TL
184: where STORE_ID = X_STORE_ID
185: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
186: for update of STORE_ID nowait;
187: begin

Line 310: update JTF_STORES_TL set

306: if (sql%notfound) then
307: raise no_data_found;
308: end if;
309:
310: update JTF_STORES_TL set
311: STORE_NAME = X_STORE_NAME,
312: STORE_DESCRIPTION = X_STORE_DESCRIPTION,
313: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
314: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 329: delete from JTF_STORES_TL

325: procedure DELETE_ROW (
326: X_STORE_ID in NUMBER
327: ) is
328: begin
329: delete from JTF_STORES_TL
330: where STORE_ID = X_STORE_ID;
331:
332: if (sql%notfound) then
333: raise no_data_found;

Line 352: update jtf_stores_tl

348: X_STORE_DESCRIPTION in VARCHAR2 ) is
349:
350: begin
351:
352: update jtf_stores_tl
353: set language = USERENV('LANG'),
354: source_lang = USERENV('LANG'),
355: store_name = X_STORE_NAME,
356: store_description = X_STORE_DESCRIPTION,

Line 460: delete from JTF_STORES_TL T

456:
457: procedure ADD_LANGUAGE
458: is
459: begin
460: delete from JTF_STORES_TL T
461: where not exists
462: (select NULL
463: from JTF_STORES_B B
464: where B.STORE_ID = T.STORE_ID

Line 467: update JTF_STORES_TL T set (

463: from JTF_STORES_B B
464: where B.STORE_ID = T.STORE_ID
465: );
466:
467: update JTF_STORES_TL T set (
468: STORE_NAME,
469: STORE_DESCRIPTION
470: ) = (select
471: B.STORE_NAME,

Line 473: from JTF_STORES_TL B

469: STORE_DESCRIPTION
470: ) = (select
471: B.STORE_NAME,
472: B.STORE_DESCRIPTION
473: from JTF_STORES_TL B
474: where B.STORE_ID = T.STORE_ID
475: and B.LANGUAGE = T.SOURCE_LANG)
476: where (
477: T.STORE_ID,

Line 482: from JTF_STORES_TL SUBB, JTF_STORES_TL SUBT

478: T.LANGUAGE
479: ) in (select
480: SUBT.STORE_ID,
481: SUBT.LANGUAGE
482: from JTF_STORES_TL SUBB, JTF_STORES_TL SUBT
483: where SUBB.STORE_ID = SUBT.STORE_ID
484: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
485: and (SUBB.STORE_NAME <> SUBT.STORE_NAME
486: or (SUBB.STORE_NAME is null and SUBT.STORE_NAME is not null)

Line 493: insert into JTF_STORES_TL (

489: or (SUBB.STORE_DESCRIPTION is null and SUBT.STORE_DESCRIPTION is not null)
490: or (SUBB.STORE_DESCRIPTION is not null and SUBT.STORE_DESCRIPTION is null)
491: ));
492:
493: insert into JTF_STORES_TL (
494: SECURITY_GROUP_ID,
495: OBJECT_VERSION_NUMBER,
496: STORE_ID,
497: CREATED_BY,

Line 519: from JTF_STORES_TL B, FND_LANGUAGES L

515: B.STORE_NAME,
516: B.STORE_DESCRIPTION,
517: L.LANGUAGE_CODE,
518: B.SOURCE_LANG
519: from JTF_STORES_TL B, FND_LANGUAGES L
520: where L.INSTALLED_FLAG in ('I', 'B')
521: and B.LANGUAGE = userenv('LANG')
522: and not exists
523: (select NULL

Line 524: from JTF_STORES_TL T

520: where L.INSTALLED_FLAG in ('I', 'B')
521: and B.LANGUAGE = userenv('LANG')
522: and not exists
523: (select NULL
524: from JTF_STORES_TL T
525: where T.STORE_ID = B.STORE_ID
526: and T.LANGUAGE = L.LANGUAGE_CODE);
527: end ADD_LANGUAGE;
528: