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_APPROVAL_GROUPS

Line 1: PACKAGE BODY AME_APPROVAL_GROUPS_LOAD_API AS

1: PACKAGE BODY AME_APPROVAL_GROUPS_LOAD_API AS
2: /* $Header: ameagapi.pkb 120.4 2005/10/14 04:10:38 ubhat noship $ */
3:
4: procedure OWNER_TO_WHO (X_OWNER in VARCHAR2
5: ,X_CREATED_BY out nocopy NUMBER

Line 31: select ame_approval_groups_s.nextval

27: )
28: is
29: begin
30: if (X_APPROVAL_GROUP_ID is null) then
31: select ame_approval_groups_s.nextval
32: into X_APPROVAL_GROUP_ID
33: from sys.dual;
34: end if;
35: insert into AME_APPROVAL_GROUPS

Line 35: insert into AME_APPROVAL_GROUPS

31: select ame_approval_groups_s.nextval
32: into X_APPROVAL_GROUP_ID
33: from sys.dual;
34: end if;
35: insert into AME_APPROVAL_GROUPS
36: (APPROVAL_GROUP_ID
37: ,NAME
38: ,QUERY_STRING
39: ,IS_STATIC

Line 65: from AME_APPROVAL_GROUPS

61: ,X_DESCRIPTION
62: ,X_OBJECT_VERSION_NUMBER
63: from sys.dual
64: where not exists (select NULL
65: from AME_APPROVAL_GROUPS
66: where NAME = X_NAME
67: and sysdate between START_DATE
68: and nvl(END_DATE - (1/86400), sysdate));
69: end INSERT_ROW;

Line 85: insert into AME_APPROVAL_GROUPS_TL

81: if not AME_SEED_UTILITY.MLS_ENABLED then
82: return;
83: end if;
84:
85: insert into AME_APPROVAL_GROUPS_TL
86: (APPROVAL_GROUP_ID
87: ,USER_APPROVAL_GROUP_NAME
88: ,DESCRIPTION
89: ,CREATED_BY

Line 109: from AME_APPROVAL_GROUPS_TL T

105: userenv('LANG')
106: from FND_LANGUAGES L
107: where L.INSTALLED_FLAG in ('I', 'B')
108: and not exists (select null
109: from AME_APPROVAL_GROUPS_TL T
110: where T.APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
111: and T.LANGUAGE = L.LANGUAGE_CODE);
112: END INSERT_TL_ROW;
113:

Line 127: from AME_APPROVAL_GROUPS

123: (
124: X_APPROVAL_GROUP_NAME in VARCHAR2
125: ) is
126: select max(START_DATE)
127: from AME_APPROVAL_GROUPS
128: where NAME = X_APPROVAL_GROUP_NAME;
129:
130: cursor CSR_GET_CURRENT_APPROVAL_GROUP
131: (

Line 138: from AME_APPROVAL_GROUPS

134: select ROWID, APPROVAL_GROUP_ID,
135: LAST_UPDATED_BY,
136: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
137: nvl(OBJECT_VERSION_NUMBER,1)
138: from AME_APPROVAL_GROUPS
139: where NAME = X_APPROVAL_GROUP_NAME
140: and sysdate between START_DATE
141: and nvl(END_DATE - (1/86400), sysdate)
142: for update of END_DATE;

Line 221: update AME_APPROVAL_GROUPS

217: is
218: L_APPROVAL_GROUP_ID number;
219: begin
220: L_APPROVAL_GROUP_ID := X_APPROVAL_GROUP_ID;
221: update AME_APPROVAL_GROUPS
222: set END_DATE = X_END_DATE
223: where ROWID = X_APPROVAL_GROUP_ROWID;
224: INSERT_ROW (X_NAME => X_NAME
225: ,X_QUERY_STRING => X_QUERY_STRING

Line 255: update AME_APPROVAL_GROUPS

251: X_END_DATE in DATE,
252: X_OBJECT_VERSION_NUMBER in NUMBER
253: ) is
254: begin
255: update AME_APPROVAL_GROUPS
256: set NAME = X_NAME,
257: QUERY_STRING = X_QUERY_STRING,
258: IS_STATIC = X_IS_STATIC,
259: DESCRIPTION = X_DESCRIPTION,

Line 390: FROM AME_APPROVAL_GROUPS_TL

386: select LAST_UPDATED_BY,
387: LAST_UPDATE_DATE
388: into X_CURRENT_OWNER,
389: X_CURRENT_LAST_UPDATE_DATE
390: FROM AME_APPROVAL_GROUPS_TL
391: WHERE APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
392: AND LANGUAGE = USERENV('LANG');
393:
394: if DO_UPDATE_INSERT

Line 400: update AME_APPROVAL_GROUPS_TL

396: ,X_CURRENT_OWNER
397: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
398: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
399: ,X_CUSTOM_MODE) then
400: update AME_APPROVAL_GROUPS_TL
401: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
402: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
403: SOURCE_LANG = userenv('LANG'),
404: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 438: (lockname =>'AME_APPROVAL_GROUPS.'||X_APPROVAL_GROUP_NAME

434: lockHandle varchar2(500);
435: returnValue integer;
436: begin
437: DBMS_LOCK.ALLOCATE_UNIQUE
438: (lockname =>'AME_APPROVAL_GROUPS.'||X_APPROVAL_GROUP_NAME
439: ,lockhandle => lockHandle
440: );
441: returnValue := DBMS_LOCK.REQUEST
442: (lockhandle => lockHandle

Line 578: ame_util.runtimeException('ame_approval_groups_api'

574: );
575: end if;
576: exception
577: when others then
578: ame_util.runtimeException('ame_approval_groups_api'
579: ,'load_row'
580: ,sqlcode
581: ,sqlerrm);
582: raise;

Line 589: delete from AME_APPROVAL_GROUPS_TL

585: procedure DELETE_ROW (X_APPROVAL_GROUP_ID in NUMBER
586: ) is
587: begin
588: if AME_SEED_UTILITY.MLS_ENABLED then
589: delete from AME_APPROVAL_GROUPS_TL
590: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
591: end if;
592: delete from AME_APPROVAL_GROUPS
593: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;

Line 592: delete from AME_APPROVAL_GROUPS

588: if AME_SEED_UTILITY.MLS_ENABLED then
589: delete from AME_APPROVAL_GROUPS_TL
590: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
591: end if;
592: delete from AME_APPROVAL_GROUPS
593: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
594: if (sql%notfound) then
595: raise no_data_found;
596: end if;

Line 624: from AME_APPROVAL_GROUPS_TL AAGTL,

620: into X_CURRENT_OWNER,
621: X_CURRENT_LAST_UPDATE_DATE,
622: X_CREATED_BY,
623: X_APPROVAL_GROUP_ID
624: from AME_APPROVAL_GROUPS_TL AAGTL,
625: AME_APPROVAL_GROUPS AAG
626: where AAG.NAME = X_APPROVAL_GROUP_NAME
627: and sysdate between AAG.START_DATE and nvl(AAG.END_DATE - (1/86400),sysdate)
628: and AAGTL.APPROVAL_GROUP_ID = AAG.APPROVAL_GROUP_ID

Line 625: AME_APPROVAL_GROUPS AAG

621: X_CURRENT_LAST_UPDATE_DATE,
622: X_CREATED_BY,
623: X_APPROVAL_GROUP_ID
624: from AME_APPROVAL_GROUPS_TL AAGTL,
625: AME_APPROVAL_GROUPS AAG
626: where AAG.NAME = X_APPROVAL_GROUP_NAME
627: and sysdate between AAG.START_DATE and nvl(AAG.END_DATE - (1/86400),sysdate)
628: and AAGTL.APPROVAL_GROUP_ID = AAG.APPROVAL_GROUP_ID
629: and AAGTL.LANGUAGE = userenv('LANG');

Line 637: update AME_APPROVAL_GROUPS_TL AAGTL

633: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
634: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
635: X_CREATED_BY => X_CREATED_BY,
636: X_CUSTOM_MODE => X_CUSTOM_MODE) then
637: update AME_APPROVAL_GROUPS_TL AAGTL
638: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
639: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
640: SOURCE_LANG = userenv('LANG'),
641: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),

Line 653: END AME_APPROVAL_GROUPS_LOAD_API;

649: null;
650: end;
651: end TRANSLATE_ROW;
652:
653: END AME_APPROVAL_GROUPS_LOAD_API;