APPS.AMS_LIST_SRC_TYPES_NEW_PKG dependencies on AMS_LIST_SRC_TYPES_TL

Line 85: insert into AMS_LIST_SRC_TYPES_TL (

81: X_LAST_UPDATE_LOGIN,
82: X_BASED_ON_TCA_FLAG
83: );
84:
85: insert into AMS_LIST_SRC_TYPES_TL (
86: LIST_SOURCE_TYPE_ID,
87: LAST_UPDATE_DATE,
88: LAST_UPDATE_BY,
89: CREATION_DATE,

Line 113: from AMS_LIST_SRC_TYPES_TL T

109: from FND_LANGUAGES L
110: where L.INSTALLED_FLAG in ('I', 'B')
111: and not exists
112: (select NULL
113: from AMS_LIST_SRC_TYPES_TL T
114: where T.LIST_SOURCE_TYPE_ID = X_LIST_SOURCE_TYPE_ID
115: and T.LANGUAGE = L.LANGUAGE_CODE);
116:
117: open c;

Line 176: from AMS_LIST_SRC_TYPES_TL

172: cursor c1 is select
173: LIST_SOURCE_NAME,
174: DESCRIPTION,
175: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
176: from AMS_LIST_SRC_TYPES_TL
177: where LIST_SOURCE_TYPE_ID = X_LIST_SOURCE_TYPE_ID
178: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
179: for update of LIST_SOURCE_TYPE_ID nowait;
180: begin

Line 296: update AMS_LIST_SRC_TYPES_TL set

292: if (sql%notfound) then
293: raise no_data_found;
294: end if;
295:
296: update AMS_LIST_SRC_TYPES_TL set
297: LIST_SOURCE_NAME = X_LIST_SOURCE_NAME,
298: DESCRIPTION = X_DESCRIPTION,
299: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
300: LAST_UPDATE_BY = X_LAST_UPDATED_BY,

Line 315: delete from AMS_LIST_SRC_TYPES_TL

311: procedure DELETE_ROW (
312: X_LIST_SOURCE_TYPE_ID in NUMBER
313: ) is
314: begin
315: delete from AMS_LIST_SRC_TYPES_TL
316: where LIST_SOURCE_TYPE_ID = X_LIST_SOURCE_TYPE_ID;
317:
318: if (sql%notfound) then
319: raise no_data_found;

Line 333: delete from AMS_LIST_SRC_TYPES_TL T

329:
330: procedure ADD_LANGUAGE
331: is
332: begin
333: delete from AMS_LIST_SRC_TYPES_TL T
334: where not exists
335: (select NULL
336: from AMS_LIST_SRC_TYPES B
337: where B.LIST_SOURCE_TYPE_ID = T.LIST_SOURCE_TYPE_ID

Line 340: update AMS_LIST_SRC_TYPES_TL T set (

336: from AMS_LIST_SRC_TYPES B
337: where B.LIST_SOURCE_TYPE_ID = T.LIST_SOURCE_TYPE_ID
338: );
339:
340: update AMS_LIST_SRC_TYPES_TL T set (
341: LIST_SOURCE_NAME,
342: DESCRIPTION
343: ) = (select
344: B.LIST_SOURCE_NAME,

Line 346: from AMS_LIST_SRC_TYPES_TL B

342: DESCRIPTION
343: ) = (select
344: B.LIST_SOURCE_NAME,
345: B.DESCRIPTION
346: from AMS_LIST_SRC_TYPES_TL B
347: where B.LIST_SOURCE_TYPE_ID = T.LIST_SOURCE_TYPE_ID
348: and B.LANGUAGE = T.SOURCE_LANG)
349: where (
350: T.LIST_SOURCE_TYPE_ID,

Line 355: from AMS_LIST_SRC_TYPES_TL SUBB, AMS_LIST_SRC_TYPES_TL SUBT

351: T.LANGUAGE
352: ) in (select
353: SUBT.LIST_SOURCE_TYPE_ID,
354: SUBT.LANGUAGE
355: from AMS_LIST_SRC_TYPES_TL SUBB, AMS_LIST_SRC_TYPES_TL SUBT
356: where SUBB.LIST_SOURCE_TYPE_ID = SUBT.LIST_SOURCE_TYPE_ID
357: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
358: and (SUBB.LIST_SOURCE_NAME <> SUBT.LIST_SOURCE_NAME
359: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 364: insert into AMS_LIST_SRC_TYPES_TL (

360: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
361: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
362: ));
363:
364: insert into AMS_LIST_SRC_TYPES_TL (
365: LIST_SOURCE_TYPE_ID,
366: LAST_UPDATE_DATE,
367: LAST_UPDATE_BY,
368: CREATION_DATE,

Line 388: from AMS_LIST_SRC_TYPES_TL B, FND_LANGUAGES L

384: B.DESCRIPTION,
385: B.SECURITY_GROUP_ID,
386: L.LANGUAGE_CODE,
387: B.SOURCE_LANG
388: from AMS_LIST_SRC_TYPES_TL B, FND_LANGUAGES L
389: where L.INSTALLED_FLAG in ('I', 'B')
390: and B.LANGUAGE = userenv('LANG')
391: and not exists
392: (select NULL

Line 393: from AMS_LIST_SRC_TYPES_TL T

389: where L.INSTALLED_FLAG in ('I', 'B')
390: and B.LANGUAGE = userenv('LANG')
391: and not exists
392: (select NULL
393: from AMS_LIST_SRC_TYPES_TL T
394: where T.LIST_SOURCE_TYPE_ID = B.LIST_SOURCE_TYPE_ID
395: and T.LANGUAGE = L.LANGUAGE_CODE);
396: end ADD_LANGUAGE;
397: