APPS.XDO_DS_DEFINITIONS_PKG dependencies on XDO_DS_DEFINITIONS_TL

Line 98: insert into XDO_DS_DEFINITIONS_TL (

94: X_LAST_UPDATED_BY,
95: X_LAST_UPDATE_LOGIN
96: );
97:
98: insert into XDO_DS_DEFINITIONS_TL (
99: APPLICATION_SHORT_NAME,
100: DATA_SOURCE_CODE,
101: DATA_SOURCE_NAME,
102: DESCRIPTION,

Line 126: from XDO_DS_DEFINITIONS_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from XDO_DS_DEFINITIONS_TL T
127: where T.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
128: and T.DATA_SOURCE_CODE = X_DATA_SOURCE_CODE
129: and T.LANGUAGE = L.LANGUAGE_CODE);
130:

Line 199: from XDO_DS_DEFINITIONS_TL

195: cursor c1 is select
196: DATA_SOURCE_NAME,
197: DESCRIPTION,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from XDO_DS_DEFINITIONS_TL
200: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
201: and DATA_SOURCE_CODE = X_DATA_SOURCE_CODE
202: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
203: for update of APPLICATION_SHORT_NAME nowait;

Line 334: update XDO_DS_DEFINITIONS_TL set

330: if (sql%notfound) then
331: raise no_data_found;
332: end if;
333:
334: update XDO_DS_DEFINITIONS_TL set
335: DATA_SOURCE_NAME = X_DATA_SOURCE_NAME,
336: DESCRIPTION = X_DESCRIPTION,
337: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
338: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 355: delete from XDO_DS_DEFINITIONS_TL

351: X_APPLICATION_SHORT_NAME in VARCHAR2,
352: X_DATA_SOURCE_CODE in VARCHAR2
353: ) is
354: begin
355: delete from XDO_DS_DEFINITIONS_TL
356: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
357: and DATA_SOURCE_CODE = X_DATA_SOURCE_CODE;
358:
359: if (sql%notfound) then

Line 375: delete from XDO_DS_DEFINITIONS_TL T

371:
372: procedure ADD_LANGUAGE
373: is
374: begin
375: delete from XDO_DS_DEFINITIONS_TL T
376: where not exists
377: (select NULL
378: from XDO_DS_DEFINITIONS_B B
379: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME

Line 383: update XDO_DS_DEFINITIONS_TL T set (

379: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
380: and B.DATA_SOURCE_CODE = T.DATA_SOURCE_CODE
381: );
382:
383: update XDO_DS_DEFINITIONS_TL T set (
384: DATA_SOURCE_NAME,
385: DESCRIPTION
386: ) = (select
387: B.DATA_SOURCE_NAME,

Line 389: from XDO_DS_DEFINITIONS_TL B

385: DESCRIPTION
386: ) = (select
387: B.DATA_SOURCE_NAME,
388: B.DESCRIPTION
389: from XDO_DS_DEFINITIONS_TL B
390: where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
391: and B.DATA_SOURCE_CODE = T.DATA_SOURCE_CODE
392: and B.LANGUAGE = T.SOURCE_LANG)
393: where (

Line 401: from XDO_DS_DEFINITIONS_TL SUBB, XDO_DS_DEFINITIONS_TL SUBT

397: ) in (select
398: SUBT.APPLICATION_SHORT_NAME,
399: SUBT.DATA_SOURCE_CODE,
400: SUBT.LANGUAGE
401: from XDO_DS_DEFINITIONS_TL SUBB, XDO_DS_DEFINITIONS_TL SUBT
402: where SUBB.APPLICATION_SHORT_NAME = SUBT.APPLICATION_SHORT_NAME
403: and SUBB.DATA_SOURCE_CODE = SUBT.DATA_SOURCE_CODE
404: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
405: and (SUBB.DATA_SOURCE_NAME <> SUBT.DATA_SOURCE_NAME

Line 410: insert into XDO_DS_DEFINITIONS_TL (

406: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
407: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
408: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
409: ));
410: insert into XDO_DS_DEFINITIONS_TL (
411: APPLICATION_SHORT_NAME,
412: DATA_SOURCE_CODE,
413: DATA_SOURCE_NAME,
414: DESCRIPTION,

Line 434: from XDO_DS_DEFINITIONS_TL B, FND_LANGUAGES L

430: B.LAST_UPDATE_DATE,
431: B.LAST_UPDATE_LOGIN,
432: L.LANGUAGE_CODE,
433: B.SOURCE_LANG
434: from XDO_DS_DEFINITIONS_TL B, FND_LANGUAGES L
435: where L.INSTALLED_FLAG in ('I', 'B')
436: and B.LANGUAGE = userenv('LANG')
437: and not exists
438: (select NULL

Line 439: from XDO_DS_DEFINITIONS_TL T

435: where L.INSTALLED_FLAG in ('I', 'B')
436: and B.LANGUAGE = userenv('LANG')
437: and not exists
438: (select NULL
439: from XDO_DS_DEFINITIONS_TL T
440: where T.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME
441: and T.DATA_SOURCE_CODE = B.DATA_SOURCE_CODE
442: and T.LANGUAGE = L.LANGUAGE_CODE);
443: end ADD_LANGUAGE;

Line 470: from XDO_DS_DEFINITIONS_TL

466:
467: begin
468: select LAST_UPDATED_BY, LAST_UPDATE_DATE
469: into db_luby, db_ludate
470: from XDO_DS_DEFINITIONS_TL
471: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
472: and DATA_SOURCE_CODE = X_DATA_SOURCE_CODE
473: and LANGUAGE = userenv('LANG');
474:

Line 487: update XDO_DS_DEFINITIONS_TL set

483: p_db_id => db_luby,
484: p_db_lud => db_ludate,
485: p_custom_mode => x_custom_mode))
486: then
487: update XDO_DS_DEFINITIONS_TL set
488: DATA_SOURCE_NAME =
489: nvl(x_data_source_name, data_source_name),
490: DESCRIPTION = nvl(x_description, DESCRIPTION),
491: SOURCE_LANG = userenv('LANG'),