APPS.CS_KB_CTXT_REPO_MAPS_PKG dependencies on CS_KB_CTXT_REPO_MAPS_TL

Line 112: insert into CS_KB_CTXT_REPO_MAPS_TL (

108: X_LAST_UPDATED_BY,
109: X_LAST_UPDATE_LOGIN
110: );
111:
112: insert into CS_KB_CTXT_REPO_MAPS_TL (
113: MAP_ID,
114: LABEL,
115: CREATION_DATE,
116: CREATED_BY,

Line 136: from CS_KB_CTXT_REPO_MAPS_TL T

132: from FND_LANGUAGES L
133: where L.INSTALLED_FLAG in ('I', 'B')
134: and not exists
135: (select NULL
136: from CS_KB_CTXT_REPO_MAPS_TL T
137: where T.MAP_ID = X_MAP_ID
138: and T.LANGUAGE = L.LANGUAGE_CODE);
139:
140: open c;

Line 207: from CS_KB_CTXT_REPO_MAPS_TL

203:
204: cursor c1 is select
205: LABEL,
206: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
207: from CS_KB_CTXT_REPO_MAPS_TL
208: where MAP_ID = X_MAP_ID
209: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
210: for update of MAP_ID nowait;
211: begin

Line 344: update CS_KB_CTXT_REPO_MAPS_TL set

340: if (sql%notfound) then
341: raise no_data_found;
342: end if;
343:
344: update CS_KB_CTXT_REPO_MAPS_TL set
345: LABEL = X_LABEL,
346: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
347: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
348: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 362: delete from CS_KB_CTXT_REPO_MAPS_TL

358: procedure DELETE_ROW (
359: X_MAP_ID in NUMBER
360: ) is
361: begin
362: delete from CS_KB_CTXT_REPO_MAPS_TL
363: where MAP_ID = X_MAP_ID;
364:
365: if (sql%notfound) then
366: raise no_data_found;

Line 380: delete from CS_KB_CTXT_REPO_MAPS_TL T

376:
377: procedure ADD_LANGUAGE
378: is
379: begin
380: delete from CS_KB_CTXT_REPO_MAPS_TL T
381: where not exists
382: (select NULL
383: from CS_KB_CTXT_REPO_MAPS_B B
384: where B.MAP_ID = T.MAP_ID

Line 387: update CS_KB_CTXT_REPO_MAPS_TL T set (

383: from CS_KB_CTXT_REPO_MAPS_B B
384: where B.MAP_ID = T.MAP_ID
385: );
386:
387: update CS_KB_CTXT_REPO_MAPS_TL T set (
388: LABEL
389: ) = (select
390: B.LABEL
391: from CS_KB_CTXT_REPO_MAPS_TL B

Line 391: from CS_KB_CTXT_REPO_MAPS_TL B

387: update CS_KB_CTXT_REPO_MAPS_TL T set (
388: LABEL
389: ) = (select
390: B.LABEL
391: from CS_KB_CTXT_REPO_MAPS_TL B
392: where B.MAP_ID = T.MAP_ID
393: and B.LANGUAGE = T.SOURCE_LANG)
394: where (
395: T.MAP_ID,

Line 400: from CS_KB_CTXT_REPO_MAPS_TL SUBB, CS_KB_CTXT_REPO_MAPS_TL SUBT

396: T.LANGUAGE
397: ) in (select
398: SUBT.MAP_ID,
399: SUBT.LANGUAGE
400: from CS_KB_CTXT_REPO_MAPS_TL SUBB, CS_KB_CTXT_REPO_MAPS_TL SUBT
401: where SUBB.MAP_ID = SUBT.MAP_ID
402: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
403: and (SUBB.LABEL <> SUBT.LABEL
404: ));

Line 406: insert into CS_KB_CTXT_REPO_MAPS_TL (

402: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
403: and (SUBB.LABEL <> SUBT.LABEL
404: ));
405:
406: insert into CS_KB_CTXT_REPO_MAPS_TL (
407: MAP_ID,
408: LABEL,
409: CREATION_DATE,
410: CREATED_BY,

Line 426: from CS_KB_CTXT_REPO_MAPS_TL B, FND_LANGUAGES L

422: B.LAST_UPDATED_BY,
423: B.LAST_UPDATE_LOGIN,
424: L.LANGUAGE_CODE,
425: B.SOURCE_LANG
426: from CS_KB_CTXT_REPO_MAPS_TL B, FND_LANGUAGES L
427: where L.INSTALLED_FLAG in ('I', 'B')
428: and B.LANGUAGE = userenv('LANG')
429: and not exists
430: (select NULL

Line 431: from CS_KB_CTXT_REPO_MAPS_TL T

427: where L.INSTALLED_FLAG in ('I', 'B')
428: and B.LANGUAGE = userenv('LANG')
429: and not exists
430: (select NULL
431: from CS_KB_CTXT_REPO_MAPS_TL T
432: where T.MAP_ID = B.MAP_ID
433: and T.LANGUAGE = L.LANGUAGE_CODE);
434: end ADD_LANGUAGE;
435:

Line 572: FROM CS_KB_CTXT_REPO_MAPS_TL

568: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
569: BEGIN
570: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
571: INTO db_luby, db_ludate
572: FROM CS_KB_CTXT_REPO_MAPS_TL
573: WHERE MAP_ID = X_MAP_ID
574: AND LANGUAGE = userenv('LANG');
575:
576: -- Test for customization and version

Line 580: UPDATE CS_KB_CTXT_REPO_MAPS_TL SET

576: -- Test for customization and version
577: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
578: db_ludate, X_CUSTOM_MODE)) then
579: -- Update translations for this language
580: UPDATE CS_KB_CTXT_REPO_MAPS_TL SET
581: LABEL = decode(x_label,
582: fnd_load_util.null_value, null, -- Real null
583: null, LABEL, -- No change
584: x_label),