eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_SRC_FIELDS_NEW_PKG dependencies on AMS_LIST_SRC_FIELDS

Line 1: package body AMS_LIST_SRC_FIELDS_NEW_PKG as

1: package body AMS_LIST_SRC_FIELDS_NEW_PKG as
2: /* $Header: amstdsab.pls 120.2 2005/08/31 13:37:18 vbhandar ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_LIST_SOURCE_FIELD_ID in NUMBER,

Line 42: cursor C is select ROWID from AMS_LIST_SRC_FIELDS

38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER,
40: X_COLUMN_TYPE IN VARCHAR2
41: ) is
42: cursor C is select ROWID from AMS_LIST_SRC_FIELDS
43: where LIST_SOURCE_FIELD_ID = X_LIST_SOURCE_FIELD_ID
44: ;
45: begin
46: insert into AMS_LIST_SRC_FIELDS (

Line 46: insert into AMS_LIST_SRC_FIELDS (

42: cursor C is select ROWID from AMS_LIST_SRC_FIELDS
43: where LIST_SOURCE_FIELD_ID = X_LIST_SOURCE_FIELD_ID
44: ;
45: begin
46: insert into AMS_LIST_SRC_FIELDS (
47: FIELD_LOOKUP_TYPE,
48: FIELD_LOOKUP_TYPE_VIEW_NAME,
49: ALLOW_LABEL_OVERRIDE,
50: FIELD_USAGE_TYPE,

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 223: from AMS_LIST_SRC_FIELDS

219: SECURITY_GROUP_ID,
220: FIELD_DATA_TYPE,
221: FIELD_DATA_SIZE,
222: COLUMN_TYPE
223: from AMS_LIST_SRC_FIELDS
224: where LIST_SOURCE_FIELD_ID = X_LIST_SOURCE_FIELD_ID
225: for update of LIST_SOURCE_FIELD_ID nowait;
226: recinfo c%rowtype;
227:

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 359: update AMS_LIST_SRC_FIELDS set

355: X_LAST_UPDATE_LOGIN in NUMBER,
356: X_COLUMN_TYPE IN VARCHAR2
357: ) is
358: begin
359: update AMS_LIST_SRC_FIELDS set
360: FIELD_LOOKUP_TYPE = X_FIELD_LOOKUP_TYPE,
361: FIELD_LOOKUP_TYPE_VIEW_NAME = X_FIELD_LOOKUP_TYPE_VIEW_NAME,
362: ALLOW_LABEL_OVERRIDE = X_ALLOW_LABEL_OVERRIDE,
363: FIELD_USAGE_TYPE = X_FIELD_USAGE_TYPE,

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 423: delete from AMS_LIST_SRC_FIELDS

419: if (sql%notfound) then
420: raise no_data_found;
421: end if;
422:
423: delete from AMS_LIST_SRC_FIELDS
424: where LIST_SOURCE_FIELD_ID = X_LIST_SOURCE_FIELD_ID;
425:
426: if (sql%notfound) then
427: 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 437: from AMS_LIST_SRC_FIELDS B

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
439: );
440:
441: update AMS_LIST_SRC_FIELDS_TL T set (

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:

Line 494: end AMS_LIST_SRC_FIELDS_NEW_PKG;

490: where T.LIST_SOURCE_FIELD_ID = B.LIST_SOURCE_FIELD_ID
491: and T.LANGUAGE = L.LANGUAGE_CODE);
492: end ADD_LANGUAGE;
493:
494: end AMS_LIST_SRC_FIELDS_NEW_PKG;