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

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

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

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

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

Line 86: return AME_SEED_UTILITY.MERGE_ROW_TEST

82: X_CURRENT_LAST_UPDATE_DATE in VARCHAR2,
83: X_CUSTOM_MODE in VARCHAR2)
84: return boolean as
85: begin
86: return AME_SEED_UTILITY.MERGE_ROW_TEST
87: (X_OWNER => X_OWNER
88: ,X_CURRENT_OWNER => X_CURRENT_OWNER
89: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
90: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 103: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

99: X_CREATED_BY in VARCHAR2,
100: X_CUSTOM_MODE in VARCHAR2)
101: return boolean as
102: begin
103: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
104: (X_OWNER => X_OWNER
105: ,X_CURRENT_OWNER => X_CURRENT_OWNER
106: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
107: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE

Line 321: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

317: X_LAST_UPDATED_BY,
318: X_LAST_UPDATE_DATE,
319: X_LAST_UPDATE_LOGIN,
320: X_START_DATE,
321: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
322: X_DESCRIPTION,
323: X_ITEM_CLASS_ID,
324: X_OBJECT_VERSION_NUMBER
325: from sys.dual

Line 332: if not AME_SEED_UTILITY.MLS_ENABLED then

328: where RULE_KEY = X_RULE_KEY
329: and sysdate between START_DATE
330: and nvl(END_DATE - (1/86400), sysdate));
331: if sql%found then
332: if not AME_SEED_UTILITY.MLS_ENABLED then
333: return;
334: end if;
335: insert into AME_RULES_TL
336: (RULE_ID

Line 412: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,

408: X_LAST_UPDATED_BY,
409: X_LAST_UPDATE_DATE,
410: X_LAST_UPDATE_LOGIN,
411: X_START_DATE,
412: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
413: X_DESCRIPTION,
414: X_ITEM_CLASS_ID,
415: X_OBJECT_VERSION_NUMBER
416: from sys.dual

Line 425: if not AME_SEED_UTILITY.MLS_ENABLED then

421: and (((END_DATE - (1/86400)) >= sysdate)
422: or (END_DATE is null)));
423:
424: if sql%found then
425: if not AME_SEED_UTILITY.MLS_ENABLED then
426: return;
427: end if;
428: insert into AME_RULES_TL
429: (RULE_ID

Line 461: if AME_SEED_UTILITY.MLS_ENABLED then

457: procedure DELETE_ROW (
458: X_RULE_KEY in VARCHAR2
459: ) is
460: begin
461: if AME_SEED_UTILITY.MLS_ENABLED then
462: delete from AME_RULES_TL
463: where RULE_ID in (select RULE_ID
464: from AME_RULES
465: where RULE_KEY = X_RULE_KEY);

Line 540: if AME_SEED_UTILITY.IS_SEED_USER(X_OWNER) and

536: -- the rule row was found matching the RULE_KEY
537: -- however it is custom created and will have an '@' sign prepended
538: -- insert a new row
539: --the following insert does not occur for prior versions of AME 11510
540: if AME_SEED_UTILITY.IS_SEED_USER(X_OWNER) and
541: (X_RULE_ID_LOAD is not null) and
542: X_CUSTOM_DETECT then
543: update AME_RULES
544: set RULE_KEY = '@' || X_RULE_KEY

Line 646: if not AME_SEED_UTILITY.MLS_ENABLED then

642: X_CURRENT_LAST_UPDATE_DATE varchar2(19);
643: X_CREATED_BY varchar2(100);
644: X_RULE_ID number;
645: begin
646: if not AME_SEED_UTILITY.MLS_ENABLED then
647: return;
648: end if;
649: begin
650: select ARUTL.LAST_UPDATED_BY,

Line 651: AME_SEED_UTILITY.DATE_AS_STRING(ARUTL.LAST_UPDATE_DATE),

647: return;
648: end if;
649: begin
650: select ARUTL.LAST_UPDATED_BY,
651: AME_SEED_UTILITY.DATE_AS_STRING(ARUTL.LAST_UPDATE_DATE),
652: AME_SEED_UTILITY.OWNER_AS_STRING(ARUTL.CREATED_BY),
653: ARU.RULE_ID
654: into X_CURRENT_OWNER,
655: X_CURRENT_LAST_UPDATE_DATE,

Line 652: AME_SEED_UTILITY.OWNER_AS_STRING(ARUTL.CREATED_BY),

648: end if;
649: begin
650: select ARUTL.LAST_UPDATED_BY,
651: AME_SEED_UTILITY.DATE_AS_STRING(ARUTL.LAST_UPDATE_DATE),
652: AME_SEED_UTILITY.OWNER_AS_STRING(ARUTL.CREATED_BY),
653: ARU.RULE_ID
654: into X_CURRENT_OWNER,
655: X_CURRENT_LAST_UPDATE_DATE,
656: X_CREATED_BY,

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

661: and sysdate between ARU.START_DATE and nvl(ARU.END_DATE - (1/86400),sysdate)
662: and ARUTL.RULE_ID = ARU.RULE_ID
663: and ARUTL.LANGUAGE = userenv('LANG');
664: if DO_TL_UPDATE_INSERT
665: (X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
666: X_CURRENT_OWNER => X_CURRENT_OWNER,
667: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
668: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
669: X_CREATED_BY => X_CREATED_BY,

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

670: X_CUSTOM_MODE => X_CUSTOM_MODE) then
671: update AME_RULES_TL ARUTL
672: set DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
673: SOURCE_LANG = userenv('LANG'),
674: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
675: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
676: LAST_UPDATE_LOGIN = 0
677: where ARUTL.RULE_ID = X_RULE_ID
678: and userenv('LANG') in (ARUTL.LANGUAGE,ARUTL.SOURCE_LANG);

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

671: update AME_RULES_TL ARUTL
672: set DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
673: SOURCE_LANG = userenv('LANG'),
674: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
675: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
676: LAST_UPDATE_LOGIN = 0
677: where ARUTL.RULE_ID = X_RULE_ID
678: and userenv('LANG') in (ARUTL.LANGUAGE,ARUTL.SOURCE_LANG);
679: end if;