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_PRODUCTION_ACTIONS_API dependencies on AME_ACTIONS

Line 45: select AME_ACTIONS_S.NEXTVAL

41: ,X_OBJECT_VERSION_NUMBER in number
42: ) as
43: X_ACTION_ID number;
44: begin
45: select AME_ACTIONS_S.NEXTVAL
46: into X_ACTION_ID
47: from dual;
48:
49: insert into AME_ACTIONS

Line 49: insert into AME_ACTIONS

45: select AME_ACTIONS_S.NEXTVAL
46: into X_ACTION_ID
47: from dual;
48:
49: insert into AME_ACTIONS
50: (ACTION_ID
51: ,ACTION_TYPE_ID
52: ,PARAMETER
53: ,PARAMETER_TWO

Line 78: from AME_ACTIONS

74: X_LAST_UPDATE_LOGIN,
75: X_OBJECT_VERSION_NUMBER
76: from dual
77: where not exists (select null
78: from AME_ACTIONS
79: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
80: and PARAMETER = X_PARAMETER
81: and PARAMETER_TWO = X_PARAMETER_TWO
82: and sysdate between START_DATE and nvl(END_DATE - (1/86400), sysdate));

Line 88: insert into AME_ACTIONS_TL

84: if not AME_SEED_UTILITY.MLS_ENABLED then
85: return;
86: end if;
87:
88: insert into AME_ACTIONS_TL
89: (ACTION_ID
90: ,DESCRIPTION
91: ,CREATED_BY
92: ,CREATION_DATE

Line 110: from AME_ACTIONS_TL T

106: userenv('LANG')
107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists (select null
110: from AME_ACTIONS_TL T
111: where T.ACTION_ID = X_ACTION_ID
112: and T.LANGUAGE = L.LANGUAGE_CODE);
113:
114: end INSERT_ROW;

Line 136: (LOCKNAME =>'AME_ACTIONS.'||X_ACTION_ID

132: X_RETURN_VALUE number;
133: begin
134:
135: DBMS_LOCK.ALLOCATE_UNIQUE
136: (LOCKNAME =>'AME_ACTIONS.'||X_ACTION_ID
137: ,LOCKHANDLE => X_LOCK_HANDLE
138: );
139: X_RETURN_VALUE := DBMS_LOCK.REQUEST
140: (LOCKHANDLE => X_LOCK_HANDLE

Line 145: update AME_ACTIONS ACT

141: ,TIMEOUT => 0
142: ,RELEASE_ON_COMMIT => true);
143:
144: if X_RETURN_VALUE = 0 then
145: update AME_ACTIONS ACT
146: set ACT.END_DATE = X_START_DATE
147: where ACT.ACTION_ID = X_ACTION_ID
148: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate);
149:

Line 150: insert into AME_ACTIONS

146: set ACT.END_DATE = X_START_DATE
147: where ACT.ACTION_ID = X_ACTION_ID
148: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate);
149:
150: insert into AME_ACTIONS
151: (ACTION_ID
152: ,ACTION_TYPE_ID
153: ,PARAMETER
154: ,PARAMETER_TWO

Line 184: update AME_ACTIONS_TL

180: if not AME_SEED_UTILITY.MLS_ENABLED then
181: return;
182: end if;
183:
184: update AME_ACTIONS_TL
185: set DESCRIPTION = X_DESCRIPTION,
186: SOURCE_LANG = userenv('LANG'),
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
188: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 208: update AME_ACTIONS

204: X_END_DATE in DATE,
205: X_OBJECT_VERSION_NUMBER in NUMBER
206: ) is
207: begin
208: update AME_ACTIONS
209: set DESCRIPTION = X_DESCRIPTION,
210: CREATED_BY = X_CREATED_BY,
211: CREATION_DATE = X_CREATION_DATE,
212: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 233: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;

229: ) as
230: L_ACTION_TYPE_ID number;
231: L_ACTION_ID number;
232: L_END_DATE date;
233: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
234: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
235: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
236: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
237: L_OWNER varchar2(100);

Line 234: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;

230: L_ACTION_TYPE_ID number;
231: L_ACTION_ID number;
232: L_END_DATE date;
233: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
234: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
235: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
236: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
237: L_OWNER varchar2(100);
238: L_LAST_UPDATE_DATE varchar2(19);

Line 235: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;

231: L_ACTION_ID number;
232: L_END_DATE date;
233: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
234: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
235: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
236: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
237: L_OWNER varchar2(100);
238: L_LAST_UPDATE_DATE varchar2(19);
239: L_OBJECT_VERSION_NUMBER number;

Line 265: from AME_ACTIONS ACT

261: ACT.ROWID
262: into L_ACTION_ID,
263: L_OBJECT_VERSION_NUMBER,
264: L_ROWID
265: from AME_ACTIONS ACT
266: where ACT.ACTION_TYPE_ID = L_ACTION_TYPE_ID
267: and ACT.PARAMETER = L_PARAMETER
268: and ACT.PARAMETER_TWO = L_PARAMETER_TWO
269: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate);

Line 330: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;

326: ,X_LAST_UPDATE_DATE in varchar2
327: ) as
328: L_ACTION_TYPE_ID number;
329: L_ACTION_ID number;
330: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
331: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
332: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
333: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
334: L_OWNER varchar2(100);

Line 331: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;

327: ) as
328: L_ACTION_TYPE_ID number;
329: L_ACTION_ID number;
330: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
331: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
332: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
333: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
334: L_OWNER varchar2(100);
335: L_LAST_UPDATE_DATE varchar2(19);

Line 332: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;

328: L_ACTION_TYPE_ID number;
329: L_ACTION_ID number;
330: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
331: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
332: L_DESCRIPTION AME_ACTIONS_TL.DESCRIPTION%TYPE;
333: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
334: L_OWNER varchar2(100);
335: L_LAST_UPDATE_DATE varchar2(19);
336: begin

Line 359: from AME_ACTIONS_TL ACTTL,

355:
356: begin
357: select ACT.ACTION_ID
358: into L_ACTION_ID
359: from AME_ACTIONS_TL ACTTL,
360: AME_ACTIONS ACT
361: where ACT.ACTION_TYPE_ID = L_ACTION_TYPE_ID
362: and ACT.ACTION_ID = ACTTL.ACTION_ID
363: and ACT.PARAMETER = L_PARAMETER

Line 360: AME_ACTIONS ACT

356: begin
357: select ACT.ACTION_ID
358: into L_ACTION_ID
359: from AME_ACTIONS_TL ACTTL,
360: AME_ACTIONS ACT
361: where ACT.ACTION_TYPE_ID = L_ACTION_TYPE_ID
362: and ACT.ACTION_ID = ACTTL.ACTION_ID
363: and ACT.PARAMETER = L_PARAMETER
364: and ACT.PARAMETER_TWO = L_PARAMETER_TWO

Line 368: update AME_ACTIONS_TL ACTTL

364: and ACT.PARAMETER_TWO = L_PARAMETER_TWO
365: and ACTTL.LANGUAGE = userenv('LANG')
366: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate);
367:
368: update AME_ACTIONS_TL ACTTL
369: set DESCRIPTION = nvl(L_DESCRIPTION,DESCRIPTION),
370: SOURCE_LANG = userenv('LANG'),
371: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE),
372: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER),

Line 403: from AME_ACTIONS_TL ACTTL,

399: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY)
400: into X_CURRENT_OWNER,
401: X_CURRENT_LAST_UPDATE_DATE,
402: X_CREATED_BY
403: from AME_ACTIONS_TL ACTTL,
404: AME_ACTIONS ACT,
405: AME_ACTION_TYPES AAT
406: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
407: and ACTTL.ACTION_ID = ACT.ACTION_ID

Line 404: AME_ACTIONS ACT,

400: into X_CURRENT_OWNER,
401: X_CURRENT_LAST_UPDATE_DATE,
402: X_CREATED_BY
403: from AME_ACTIONS_TL ACTTL,
404: AME_ACTIONS ACT,
405: AME_ACTION_TYPES AAT
406: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
407: and ACTTL.ACTION_ID = ACT.ACTION_ID
408: and AAT.NAME = X_ACTION_TYPE_NAME

Line 435: from AME_ACTIONS ACT,

431: select ACT.LAST_UPDATED_BY,
432: AME_SEED_UTILITY.DATE_AS_STRING(ACT.LAST_UPDATE_DATE)
433: into X_CURRENT_OWNER,
434: X_CURRENT_LAST_UPDATE_DATE
435: from AME_ACTIONS ACT,
436: AME_ACTION_TYPES AAT
437: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
438: and AAT.NAME = X_ACTION_TYPE_NAME
439: and ACT.PARAMETER = X_PARAMETER

Line 511: delete from AME_ACTIONS_TL

507: (X_ACTION_ID in number
508: ) as
509: begin
510: if AME_SEED_UTILITY.MLS_ENABLED then
511: delete from AME_ACTIONS_TL
512: where ACTION_ID = X_ACTION_ID;
513: end if;
514: delete from AME_ACTIONS
515: where ACTION_ID = X_ACTION_ID;

Line 514: delete from AME_ACTIONS

510: if AME_SEED_UTILITY.MLS_ENABLED then
511: delete from AME_ACTIONS_TL
512: where ACTION_ID = X_ACTION_ID;
513: end if;
514: delete from AME_ACTIONS
515: where ACTION_ID = X_ACTION_ID;
516: if sql%notfound then
517: raise no_data_found;
518: end if;