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_CALLING_APPS_API dependencies on AME_SEED_UTILITY

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

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

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

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

Line 131: return AME_SEED_UTILITY.MERGE_ROW_TEST

127: X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
128: X_CUSTOM_MODE in VARCHAR2 default null)
129: return boolean as
130: begin
131: return AME_SEED_UTILITY.MERGE_ROW_TEST
132: (X_OWNER => X_OWNER
133: ,X_CURRENT_OWNER => X_CURRENT_OWNER
134: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
135: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 150: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then

146: begin
147: if X_CUSTOM_MODE = 'FORCE' then
148: return true;
149: end if;
150: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
151: return true;
152: else
153: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
154: (X_OWNER => X_OWNER

Line 153: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

149: end if;
150: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
151: return true;
152: else
153: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
154: (X_OWNER => X_OWNER
155: ,X_CURRENT_OWNER => X_CURRENT_OWNER
156: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
157: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 206: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

202: X_LAST_UPDATED_BY,
203: X_LAST_UPDATE_DATE,
204: X_LAST_UPDATE_LOGIN,
205: X_START_DATE,
206: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
207: X_LINE_ITEM_ID_QUERY,
208: X_OBJECT_VERSION_NUMBER
209: from sys.dual;
210: end INSERT_ROW;

Line 292: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

288: X_LAST_UPDATED_BY,
289: X_LAST_UPDATE_DATE,
290: X_LAST_UPDATE_LOGIN,
291: X_START_DATE,
292: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
293: X_OBJECT_VERSION_NUMBER);
294: end INSERT_USAGE_ROW;
295:
296: procedure FORCE_UPDATE_USAGE_ROW (

Line 337: if not AME_SEED_UTILITY.MLS_ENABLED then

333: X_LAST_UPDATED_BY in NUMBER,
334: X_LAST_UPDATE_DATE in DATE,
335: X_LAST_UPDATE_LOGIN in NUMBER) is
336: begin
337: if not AME_SEED_UTILITY.MLS_ENABLED then
338: return;
339: end if;
340:
341: insert into AME_CALLING_APPS_TL

Line 380: if not AME_SEED_UTILITY.MLS_ENABLED then

376: X_CUSTOM_MODE in VARCHAR2) is
377: X_CURRENT_OWNER NUMBER;
378: X_CURRENT_LAST_UPDATE_DATE DATE;
379: begin
380: if not AME_SEED_UTILITY.MLS_ENABLED then
381: return;
382: end if;
383:
384: select LAST_UPDATED_BY,

Line 395: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)

391:
392: if DO_UPDATE_INSERT
393: (X_LAST_UPDATED_BY
394: ,X_CURRENT_OWNER
395: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
396: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
397: ,X_CUSTOM_MODE) then
398: update AME_CALLING_APPS_TL
399: set APPLICATION_NAME = nvl(X_APPLICATION_NAME,APPLICATION_NAME),

Line 396: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)

392: if DO_UPDATE_INSERT
393: (X_LAST_UPDATED_BY
394: ,X_CURRENT_OWNER
395: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
396: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
397: ,X_CUSTOM_MODE) then
398: update AME_CALLING_APPS_TL
399: set APPLICATION_NAME = nvl(X_APPLICATION_NAME,APPLICATION_NAME),
400: SOURCE_LANG = userenv('LANG'),

Line 441: if AME_SEED_UTILITY.MLS_ENABLED then

437: X_TRANSACTION_TYPE_ID in VARCHAR2,
438: X_APPLICATION_ID in NUMBER
439: ) is
440: begin
441: if AME_SEED_UTILITY.MLS_ENABLED then
442: delete from AME_CALLING_APPS_TL
443: where APPLICATION_ID in (select APPLICATION_ID
444: from AME_CALLING_APPS
445: where FND_APPLICATION_ID = X_FND_APPLICATION_ID

Line 673: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

669: x_created_by,
670: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
671: 0,
672: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
673: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
674: ame_util.booleanTrue,
675: null,
676: 1
677: from sys.dual

Line 720: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

716: x_created_by,
717: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
718: 0,
719: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
720: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
721: ame_util.booleanTrue,
722: null,
723: 1
724: from sys.dual

Line 769: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

765: x_created_by,
766: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
767: 0,
768: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
769: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
770: ame_util.booleanTrue,
771: null,
772: 1
773: from sys.dual

Line 939: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

935: X_LAST_UPDATED_BY,
936: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
937: X_LAST_UPDATE_LOGIN,
938: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
939: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
940: X_CURRENT_APP_OVN + 1
941: );
942: UPDATE_TL_ROW
943: (

Line 967: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

963: X_LAST_UPDATED_BY,
964: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
965: X_LAST_UPDATE_LOGIN,
966: to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
967: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
968: X_CURRENT_USAGE_OVN + 1
969: );
970: end if;
971: else

Line 973: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

969: );
970: end if;
971: else
972: if DO_UPDATE_INSERT
973: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
974: X_CURRENT_OWNER,
975: X_LAST_UPDATE_DATE,
976: X_CURRENT_LAST_UPDATE_DATE) then
977: UPDATE_ROW (

Line 1008: DO_UPDATE_INSERT(AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

1004: );
1005: --+
1006: if X_LINE_ITEM_ID_QUERY is not null and
1007: X_LINE_ITEM_ID_QUERY <> X_CURRENT_ITEM_ID_QUERY and
1008: DO_UPDATE_INSERT(AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
1009: X_CURRENT_USAGE_OWNER,
1010: X_LAST_UPDATE_DATE,
1011: X_CURRENT_USAGE_LUD) then
1012: UPDATE_USAGE_ROW (

Line 1058: if not AME_SEED_UTILITY.MLS_ENABLED then

1054: X_CURRENT_LAST_UPDATE_DATE varchar2(20);
1055: X_CREATED_BY varchar2(100);
1056: X_APPLICATION_ID number;
1057: begin
1058: if not AME_SEED_UTILITY.MLS_ENABLED then
1059: return;
1060: end if;
1061:
1062: begin

Line 1064: AME_SEED_UTILITY.DATE_AS_STRING(ACATL.LAST_UPDATE_DATE),

1060: end if;
1061:
1062: begin
1063: select ACATL.LAST_UPDATED_BY,
1064: AME_SEED_UTILITY.DATE_AS_STRING(ACATL.LAST_UPDATE_DATE),
1065: AME_SEED_UTILITY.OWNER_AS_STRING(ACATL.CREATED_BY),
1066: ACA.APPLICATION_ID
1067: into X_CURRENT_OWNER,
1068: X_CURRENT_LAST_UPDATE_DATE,

Line 1065: AME_SEED_UTILITY.OWNER_AS_STRING(ACATL.CREATED_BY),

1061:
1062: begin
1063: select ACATL.LAST_UPDATED_BY,
1064: AME_SEED_UTILITY.DATE_AS_STRING(ACATL.LAST_UPDATE_DATE),
1065: AME_SEED_UTILITY.OWNER_AS_STRING(ACATL.CREATED_BY),
1066: ACA.APPLICATION_ID
1067: into X_CURRENT_OWNER,
1068: X_CURRENT_LAST_UPDATE_DATE,
1069: X_CREATED_BY,

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

1078: and sysdate between ACA.START_DATE and nvl(ACA.END_DATE - (1/86400),sysdate)
1079: and ACATL.APPLICATION_ID = ACA.APPLICATION_ID
1080: and ACATL.LANGUAGE = userenv('LANG');
1081: if DO_TL_UPDATE_INSERT
1082: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
1083: X_CURRENT_OWNER => X_CURRENT_OWNER,
1084: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1085: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
1086: X_CREATED_BY => X_CREATED_BY,

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

1087: X_CUSTOM_MODE => X_CUSTOM_MODE) then
1088: update AME_CALLING_APPS_TL ACATL
1089: set APPLICATION_NAME = nvl(X_APPLICATION_NAME,APPLICATION_NAME),
1090: SOURCE_LANG = userenv('LANG'),
1091: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
1092: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
1093: LAST_UPDATE_LOGIN = 0
1094: where ACATL.APPLICATION_ID = X_APPLICATION_ID
1095: and userenv('LANG') in (ACATL.LANGUAGE,ACATL.SOURCE_LANG);

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

1088: update AME_CALLING_APPS_TL ACATL
1089: set APPLICATION_NAME = nvl(X_APPLICATION_NAME,APPLICATION_NAME),
1090: SOURCE_LANG = userenv('LANG'),
1091: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
1092: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
1093: LAST_UPDATE_LOGIN = 0
1094: where ACATL.APPLICATION_ID = X_APPLICATION_ID
1095: and userenv('LANG') in (ACATL.LANGUAGE,ACATL.SOURCE_LANG);
1096: end if;