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.7 2011/09/21 14:52:35 prasashe ship $ */
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 392: FROM AME_APPROVAL_GROUPS_TL

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

Line 402: update AME_APPROVAL_GROUPS_TL

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),
405: SOURCE_LANG = userenv('LANG'),
406: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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

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

Line 586: ame_util.runtimeException('ame_approval_groups_api'

582: end;
583: end if;
584: exception
585: when others then
586: ame_util.runtimeException('ame_approval_groups_api'
587: ,'load_row'
588: ,sqlcode
589: ,sqlerrm);
590: raise;

Line 597: delete from AME_APPROVAL_GROUPS_TL

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
601: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;

Line 600: delete from AME_APPROVAL_GROUPS

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
601: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
602: if (sql%notfound) then
603: raise no_data_found;
604: end if;

Line 632: from AME_APPROVAL_GROUPS_TL AAGTL,

628: into X_CURRENT_OWNER,
629: X_CURRENT_LAST_UPDATE_DATE,
630: X_CREATED_BY,
631: X_APPROVAL_GROUP_ID
632: from AME_APPROVAL_GROUPS_TL AAGTL,
633: AME_APPROVAL_GROUPS AAG
634: where AAG.NAME = X_APPROVAL_GROUP_NAME
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

Line 633: AME_APPROVAL_GROUPS AAG

629: X_CURRENT_LAST_UPDATE_DATE,
630: X_CREATED_BY,
631: X_APPROVAL_GROUP_ID
632: from AME_APPROVAL_GROUPS_TL AAGTL,
633: AME_APPROVAL_GROUPS AAG
634: where AAG.NAME = X_APPROVAL_GROUP_NAME
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');

Line 645: update AME_APPROVAL_GROUPS_TL AAGTL

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,
644: X_CUSTOM_MODE => X_CUSTOM_MODE) then
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),

Line 661: END AME_APPROVAL_GROUPS_LOAD_API;

657: null;
658: end;
659: end TRANSLATE_ROW;
660:
661: END AME_APPROVAL_GROUPS_LOAD_API;