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_APPROVAL_GROUPS_LOAD_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 INSERT_ROW (X_NAME in VARCHAR2

Line 60: ,AME_SEED_UTILITY.GET_DEFAULT_END_DATE

56: ,X_LAST_UPDATED_BY
57: ,X_LAST_UPDATE_DATE
58: ,X_LAST_UPDATE_LOGIN
59: ,X_START_DATE
60: ,AME_SEED_UTILITY.GET_DEFAULT_END_DATE
61: ,X_DESCRIPTION
62: ,X_OBJECT_VERSION_NUMBER
63: from sys.dual
64: where not exists (select NULL

Line 81: if not AME_SEED_UTILITY.MLS_ENABLED then

77: X_LAST_UPDATED_BY in NUMBER,
78: X_LAST_UPDATE_DATE in DATE,
79: X_LAST_UPDATE_LOGIN in NUMBER) is
80: begin
81: if not AME_SEED_UTILITY.MLS_ENABLED then
82: return;
83: end if;
84:
85: insert into AME_APPROVAL_GROUPS_TL

Line 168: return AME_SEED_UTILITY.MERGE_ROW_TEST

164: X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
165: X_CUSTOM_MODE in VARCHAR2 default null)
166: return boolean as
167: begin
168: return AME_SEED_UTILITY.MERGE_ROW_TEST
169: (X_OWNER => X_OWNER
170: ,X_CURRENT_OWNER => X_CURRENT_OWNER
171: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
172: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 188: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then

184: begin
185: if X_CUSTOM_MODE = 'FORCE' then
186: return true;
187: end if;
188: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
189: return true;
190: else
191: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
192: (X_OWNER => X_OWNER

Line 191: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

187: end if;
188: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
189: return true;
190: else
191: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
192: (X_OWNER => X_OWNER
193: ,X_CURRENT_OWNER => X_CURRENT_OWNER
194: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
195: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 318: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;

314: TYPE APPLICATION_ID_TAB is table of NUMBER index by BINARY_INTEGER;
315: APPLICATION_ID_LIST APPLICATION_ID_TAB;
316: L_ORDER_NUMBER NUMBER;
317: begin
318: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
319: if (AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null) and to_number(AME_SEED_UTILITY.AME_INSTALLATION_LEVEL) < 2 then
320: open get_active_application;
321: fetch get_active_application bulk collect into application_id_list;
322: close get_active_application;

Line 319: if (AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null) and to_number(AME_SEED_UTILITY.AME_INSTALLATION_LEVEL) < 2 then

315: APPLICATION_ID_LIST APPLICATION_ID_TAB;
316: L_ORDER_NUMBER NUMBER;
317: begin
318: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
319: if (AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null) and to_number(AME_SEED_UTILITY.AME_INSTALLATION_LEVEL) < 2 then
320: open get_active_application;
321: fetch get_active_application bulk collect into application_id_list;
322: close get_active_application;
323: --

Line 384: if not AME_SEED_UTILITY.MLS_ENABLED then

380: X_CUSTOM_MODE in VARCHAR2) is
381: X_CURRENT_OWNER NUMBER;
382: X_CURRENT_LAST_UPDATE_DATE DATE;
383: begin
384: if not AME_SEED_UTILITY.MLS_ENABLED then
385: return;
386: end if;
387:
388: select LAST_UPDATED_BY,

Line 399: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)

395:
396: if DO_UPDATE_INSERT
397: (X_LAST_UPDATED_BY
398: ,X_CURRENT_OWNER
399: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
400: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
401: ,X_CUSTOM_MODE) then
402: update AME_APPROVAL_GROUPS_TL
403: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),

Line 400: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)

396: if DO_UPDATE_INSERT
397: (X_LAST_UPDATED_BY
398: ,X_CURRENT_OWNER
399: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
400: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
401: ,X_CUSTOM_MODE) then
402: update AME_APPROVAL_GROUPS_TL
403: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
404: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),

Line 522: ,AME_SEED_UTILITY.GET_DEFAULT_END_DATE

518: ,X_LAST_UPDATED_BY
519: ,to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')
520: ,X_LAST_UPDATE_LOGIN
521: ,to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')
522: ,AME_SEED_UTILITY.GET_DEFAULT_END_DATE
523: ,X_CURRENT_OVN + 1
524: );
525: UPDATE_TL_ROW
526: (X_APPROVAL_GROUP_ID

Line 541: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)

537: ,X_QUERY_STRING => X_QUERY_STRING
538: );
539: else
540: if DO_UPDATE_INSERT
541: (AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
542: ,X_CURRENT_OWNER
543: ,X_LAST_UPDATE_DATE
544: ,X_CURRENT_LAST_UPDATE_DATE
545: )

Line 596: if AME_SEED_UTILITY.MLS_ENABLED then

592:
593: procedure DELETE_ROW (X_APPROVAL_GROUP_ID in NUMBER
594: ) is
595: begin
596: if AME_SEED_UTILITY.MLS_ENABLED then
597: delete from AME_APPROVAL_GROUPS_TL
598: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
599: end if;
600: delete from AME_APPROVAL_GROUPS

Line 620: if not AME_SEED_UTILITY.MLS_ENABLED then

616: X_CURRENT_LAST_UPDATE_DATE varchar2(20);
617: X_CREATED_BY varchar2(100);
618: X_APPROVAL_GROUP_ID number;
619: begin
620: if not AME_SEED_UTILITY.MLS_ENABLED then
621: return;
622: end if;
623: begin
624: select AAGTL.LAST_UPDATED_BY,

Line 625: AME_SEED_UTILITY.DATE_AS_STRING(AAGTL.LAST_UPDATE_DATE),

621: return;
622: end if;
623: begin
624: select AAGTL.LAST_UPDATED_BY,
625: AME_SEED_UTILITY.DATE_AS_STRING(AAGTL.LAST_UPDATE_DATE),
626: AME_SEED_UTILITY.OWNER_AS_STRING(AAGTL.CREATED_BY),
627: AAG.APPROVAL_GROUP_ID
628: into X_CURRENT_OWNER,
629: X_CURRENT_LAST_UPDATE_DATE,

Line 626: AME_SEED_UTILITY.OWNER_AS_STRING(AAGTL.CREATED_BY),

622: end if;
623: begin
624: select AAGTL.LAST_UPDATED_BY,
625: AME_SEED_UTILITY.DATE_AS_STRING(AAGTL.LAST_UPDATE_DATE),
626: AME_SEED_UTILITY.OWNER_AS_STRING(AAGTL.CREATED_BY),
627: AAG.APPROVAL_GROUP_ID
628: into X_CURRENT_OWNER,
629: X_CURRENT_LAST_UPDATE_DATE,
630: X_CREATED_BY,

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

635: and sysdate between AAG.START_DATE and nvl(AAG.END_DATE - (1/86400),sysdate)
636: and AAGTL.APPROVAL_GROUP_ID = AAG.APPROVAL_GROUP_ID
637: and AAGTL.LANGUAGE = userenv('LANG');
638: if DO_TL_UPDATE_INSERT
639: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
640: X_CURRENT_OWNER => X_CURRENT_OWNER,
641: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
642: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
643: X_CREATED_BY => X_CREATED_BY,

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

645: update AME_APPROVAL_GROUPS_TL AAGTL
646: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
647: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
648: SOURCE_LANG = userenv('LANG'),
649: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
650: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
651: LAST_UPDATE_LOGIN = 0
652: where AAGTL.APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
653: and userenv('LANG') in (AAGTL.LANGUAGE,AAGTL.SOURCE_LANG);

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

646: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
647: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
648: SOURCE_LANG = userenv('LANG'),
649: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
650: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
651: LAST_UPDATE_LOGIN = 0
652: where AAGTL.APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
653: and userenv('LANG') in (AAGTL.LANGUAGE,AAGTL.SOURCE_LANG);
654: end if;