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.AME_ITEM_CLASSES_API dependencies on AME_SEED_UTILITY

Line 10: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

6: X_LAST_UPDATED_BY out nocopy NUMBER,
7: X_LAST_UPDATE_LOGIN out nocopy NUMBER
8: ) is
9: begin
10: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
11: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
12: X_LAST_UPDATE_LOGIN := 0;
13: end OWNER_TO_WHO;
14:

Line 11: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);

7: X_LAST_UPDATE_LOGIN out nocopy NUMBER
8: ) is
9: begin
10: X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
11: X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
12: X_LAST_UPDATE_LOGIN := 0;
13: end OWNER_TO_WHO;
14:
15: procedure KEY_TO_IDS (

Line 73: return AME_SEED_UTILITY.MERGE_ROW_TEST

69: X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
70: X_CUSTOM_MODE in VARCHAR2 default null)
71: return boolean as
72: begin
73: return AME_SEED_UTILITY.MERGE_ROW_TEST
74: (X_OWNER => X_OWNER
75: ,X_CURRENT_OWNER => X_CURRENT_OWNER
76: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
77: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 92: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then

88: begin
89: if X_CUSTOM_MODE = 'FORCE' then
90: return true;
91: end if;
92: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
93: return true;
94: else
95: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
96: (X_OWNER => X_OWNER

Line 95: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

91: end if;
92: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
93: return true;
94: else
95: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
96: (X_OWNER => X_OWNER
97: ,X_CURRENT_OWNER => X_CURRENT_OWNER
98: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
99: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 138: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

134: X_LAST_UPDATED_BY,
135: X_LAST_UPDATE_DATE,
136: X_LAST_UPDATE_LOGIN,
137: X_START_DATE,
138: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
139: X_OBJECT_VERSION_NUMBER);
140: end INSERT_ROW;
141:
142: procedure INSERT_TL_ROW

Line 152: if not AME_SEED_UTILITY.MLS_ENABLED then

148: ,X_LAST_UPDATE_DATE IN DATE
149: ,X_LAST_UPDATE_LOGIN IN NUMBER
150: ) AS
151: BEGIN
152: if not AME_SEED_UTILITY.MLS_ENABLED then
153: return;
154: end if;
155:
156: insert into AME_ITEM_CLASSES_TL

Line 195: if not AME_SEED_UTILITY.MLS_ENABLED then

191: X_CUSTOM_MODE in VARCHAR2) is
192: X_CURRENT_OWNER NUMBER;
193: X_CURRENT_LAST_UPDATE_DATE DATE;
194: begin
195: if not AME_SEED_UTILITY.MLS_ENABLED then
196: return;
197: end if;
198:
199: select LAST_UPDATED_BY,

Line 210: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)

206:
207: if DO_UPDATE_INSERT
208: (X_LAST_UPDATED_BY
209: ,X_CURRENT_OWNER
210: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
211: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
212: ,X_CUSTOM_MODE) then
213: update AME_ITEM_CLASSES_TL
214: set USER_ITEM_CLASS_NAME = nvl(X_USER_ITEM_CLASS_NAME,USER_ITEM_CLASS_NAME),

Line 211: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)

207: if DO_UPDATE_INSERT
208: (X_LAST_UPDATED_BY
209: ,X_CURRENT_OWNER
210: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
211: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
212: ,X_CUSTOM_MODE) then
213: update AME_ITEM_CLASSES_TL
214: set USER_ITEM_CLASS_NAME = nvl(X_USER_ITEM_CLASS_NAME,USER_ITEM_CLASS_NAME),
215: SOURCE_LANG = userenv('LANG'),

Line 266: if AME_SEED_UTILITY.MLS_ENABLED then

262: procedure DELETE_ROW (
263: X_ITEM_CLASS_ID in NUMBER
264: ) is
265: begin
266: if AME_SEED_UTILITY.MLS_ENABLED then
267: delete from AME_ITEM_CLASSES_TL
268: where ITEM_CLASS_ID = X_ITEM_CLASS_ID;
269: end if;
270: delete from AME_ITEM_CLASSES

Line 358: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

354: X_LAST_UPDATED_BY,
355: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
356: X_LAST_UPDATE_LOGIN,
357: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
358: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
359: X_CURRENT_OVN + 1
360: );
361: UPDATE_TL_ROW
362: (L_ITEM_CLASS_ID,

Line 373: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

369: X_CUSTOM_MODE
370: );
371: else
372: if DO_UPDATE_INSERT
373: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
374: X_CURRENT_OWNER,
375: X_LAST_UPDATE_DATE,
376: X_CURRENT_LAST_UPDATE_DATE) then
377: UPDATE_ROW (

Line 426: if not AME_SEED_UTILITY.MLS_ENABLED then

422: X_CURRENT_OWNER NUMBER;
423: X_CURRENT_LAST_UPDATE_DATE varchar2(20);
424: X_CREATED_BY varchar2(100);
425: begin
426: if not AME_SEED_UTILITY.MLS_ENABLED then
427: return;
428: end if;
429:
430: begin

Line 432: AME_SEED_UTILITY.DATE_AS_STRING(AICTL.LAST_UPDATE_DATE),

428: end if;
429:
430: begin
431: select AICTL.LAST_UPDATED_BY,
432: AME_SEED_UTILITY.DATE_AS_STRING(AICTL.LAST_UPDATE_DATE),
433: AME_SEED_UTILITY.OWNER_AS_STRING(AICTL.CREATED_BY),
434: AICTL.ITEM_CLASS_ID
435: into X_CURRENT_OWNER,
436: X_CURRENT_LAST_UPDATE_DATE,

Line 433: AME_SEED_UTILITY.OWNER_AS_STRING(AICTL.CREATED_BY),

429:
430: begin
431: select AICTL.LAST_UPDATED_BY,
432: AME_SEED_UTILITY.DATE_AS_STRING(AICTL.LAST_UPDATE_DATE),
433: AME_SEED_UTILITY.OWNER_AS_STRING(AICTL.CREATED_BY),
434: AICTL.ITEM_CLASS_ID
435: into X_CURRENT_OWNER,
436: X_CURRENT_LAST_UPDATE_DATE,
437: X_CREATED_BY,

Line 447: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

443: and sysdate between AIC.START_DATE and nvl(AIC.END_DATE - (1/86400),sysdate)
444: and AICTL.LANGUAGE = userenv('LANG');
445:
446: if DO_TL_UPDATE_INSERT
447: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
448: X_CURRENT_OWNER => X_CURRENT_OWNER,
449: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
450: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
451: X_CREATED_BY => X_CREATED_BY,

Line 456: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),

452: X_CUSTOM_MODE => X_CUSTOM_MODE) then
453: update AME_ITEM_CLASSES_TL AICTL
454: set USER_ITEM_CLASS_NAME = nvl(X_USER_ITEM_CLASS_NAME,AICTL.USER_ITEM_CLASS_NAME),
455: SOURCE_LANG = userenv('LANG'),
456: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
457: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
458: LAST_UPDATE_LOGIN = 0
459: where AICTL.ITEM_CLASS_ID = L_ITEM_CLASS_ID
460: and userenv('LANG') in (AICTL.LANGUAGE,AICTL.SOURCE_LANG);

Line 457: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

453: update AME_ITEM_CLASSES_TL AICTL
454: set USER_ITEM_CLASS_NAME = nvl(X_USER_ITEM_CLASS_NAME,AICTL.USER_ITEM_CLASS_NAME),
455: SOURCE_LANG = userenv('LANG'),
456: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
457: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
458: LAST_UPDATE_LOGIN = 0
459: where AICTL.ITEM_CLASS_ID = L_ITEM_CLASS_ID
460: and userenv('LANG') in (AICTL.LANGUAGE,AICTL.SOURCE_LANG);
461: END IF;