APPS.AMS_LIST_SRC_FIELDS_NEW_PKG dependencies on AMS_LIST_SRC_FIELDS_TL

Line 120: insert into AMS_LIST_SRC_FIELDS_TL (

116: X_LAST_UPDATE_LOGIN,
117: X_COLUMN_TYPE
118: );
119:
120: insert into AMS_LIST_SRC_FIELDS_TL (
121: LIST_SOURCE_FIELD_ID,
122: LAST_UPDATE_DATE,
123: LAST_UPDATE_BY,
124: CREATION_DATE,

Line 146: from AMS_LIST_SRC_FIELDS_TL T

142: from FND_LANGUAGES L
143: where L.INSTALLED_FLAG in ('I', 'B')
144: and not exists
145: (select NULL
146: from AMS_LIST_SRC_FIELDS_TL T
147: where T.LIST_SOURCE_FIELD_ID = X_LIST_SOURCE_FIELD_ID
148: and T.LANGUAGE = L.LANGUAGE_CODE);
149:
150: open c;

Line 231: from AMS_LIST_SRC_FIELDS_TL

227:
228: cursor c1 is select
229: SOURCE_COLUMN_MEANING,
230: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
231: from AMS_LIST_SRC_FIELDS_TL
232: where LIST_SOURCE_FIELD_ID = X_LIST_SOURCE_FIELD_ID
233: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
234: for update of LIST_SOURCE_FIELD_ID nowait;
235: begin

Line 398: update AMS_LIST_SRC_FIELDS_TL set

394: if (sql%notfound) then
395: raise no_data_found;
396: end if;
397:
398: update AMS_LIST_SRC_FIELDS_TL set
399: SOURCE_COLUMN_MEANING = X_SOURCE_COLUMN_MEANING,
400: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
401: LAST_UPDATE_BY = X_LAST_UPDATED_BY,
402: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 416: delete from AMS_LIST_SRC_FIELDS_TL

412: procedure DELETE_ROW (
413: X_LIST_SOURCE_FIELD_ID in NUMBER
414: ) is
415: begin
416: delete from AMS_LIST_SRC_FIELDS_TL
417: where LIST_SOURCE_FIELD_ID = X_LIST_SOURCE_FIELD_ID;
418:
419: if (sql%notfound) then
420: raise no_data_found;

Line 434: delete from AMS_LIST_SRC_FIELDS_TL T

430:
431: procedure ADD_LANGUAGE
432: is
433: begin
434: delete from AMS_LIST_SRC_FIELDS_TL T
435: where not exists
436: (select NULL
437: from AMS_LIST_SRC_FIELDS B
438: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID

Line 441: update AMS_LIST_SRC_FIELDS_TL T set (

437: from AMS_LIST_SRC_FIELDS B
438: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID
439: );
440:
441: update AMS_LIST_SRC_FIELDS_TL T set (
442: SOURCE_COLUMN_MEANING
443: ) = (select
444: B.SOURCE_COLUMN_MEANING
445: from AMS_LIST_SRC_FIELDS_TL B

Line 445: from AMS_LIST_SRC_FIELDS_TL B

441: update AMS_LIST_SRC_FIELDS_TL T set (
442: SOURCE_COLUMN_MEANING
443: ) = (select
444: B.SOURCE_COLUMN_MEANING
445: from AMS_LIST_SRC_FIELDS_TL B
446: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID
447: and B.LANGUAGE = T.SOURCE_LANG)
448: where (
449: T.LIST_SOURCE_FIELD_ID,

Line 454: from AMS_LIST_SRC_FIELDS_TL SUBB, AMS_LIST_SRC_FIELDS_TL SUBT

450: T.LANGUAGE
451: ) in (select
452: SUBT.LIST_SOURCE_FIELD_ID,
453: SUBT.LANGUAGE
454: from AMS_LIST_SRC_FIELDS_TL SUBB, AMS_LIST_SRC_FIELDS_TL SUBT
455: where SUBB.LIST_SOURCE_FIELD_ID = SUBT.LIST_SOURCE_FIELD_ID
456: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
457: and (SUBB.SOURCE_COLUMN_MEANING <> SUBT.SOURCE_COLUMN_MEANING
458: or (SUBB.SOURCE_COLUMN_MEANING is null and SUBT.SOURCE_COLUMN_MEANING is not null)

Line 462: insert into AMS_LIST_SRC_FIELDS_TL (

458: or (SUBB.SOURCE_COLUMN_MEANING is null and SUBT.SOURCE_COLUMN_MEANING is not null)
459: or (SUBB.SOURCE_COLUMN_MEANING is not null and SUBT.SOURCE_COLUMN_MEANING is null)
460: ));
461:
462: insert into AMS_LIST_SRC_FIELDS_TL (
463: LIST_SOURCE_FIELD_ID,
464: LAST_UPDATE_DATE,
465: LAST_UPDATE_BY,
466: CREATION_DATE,

Line 484: from AMS_LIST_SRC_FIELDS_TL B, FND_LANGUAGES L

480: B.SOURCE_COLUMN_MEANING,
481: B.SECURITY_GROUP_ID,
482: L.LANGUAGE_CODE,
483: B.SOURCE_LANG
484: from AMS_LIST_SRC_FIELDS_TL B, FND_LANGUAGES L
485: where L.INSTALLED_FLAG in ('I', 'B')
486: and B.LANGUAGE = userenv('LANG')
487: and not exists
488: (select NULL

Line 489: from AMS_LIST_SRC_FIELDS_TL T

485: where L.INSTALLED_FLAG in ('I', 'B')
486: and B.LANGUAGE = userenv('LANG')
487: and not exists
488: (select NULL
489: from AMS_LIST_SRC_FIELDS_TL T
490: where T.LIST_SOURCE_FIELD_ID = B.LIST_SOURCE_FIELD_ID
491: and T.LANGUAGE = L.LANGUAGE_CODE);
492: end ADD_LANGUAGE;
493: