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

Line 295: ame_actions act

291: cursor getActionTypeDynamicDesc(actionIdIn in number
292: ,p_effective_date in date) is
293: select dynamic_description
294: from ame_action_types aty,
295: ame_actions act
296: where act.action_id = actionIdIn
297: and act.action_type_id = aty.action_type_id
298: and p_effective_date between act.start_date and nvl(act.end_date - (1/86400), p_effective_date)
299: and p_effective_date between aty.start_date and nvl(aty.end_date - (1/86400), p_effective_date);

Line 304: from ame_actions_vl

300:
301: cursor getActionDesc(actionIdIn in number
302: ,p_effective_date in date) is
303: select description
304: from ame_actions_vl
305: where action_id = actionIdIn
306: and p_effective_date between start_date and nvl(end_date - (1/86400), p_effective_date);
307:
308: cursor getActionDescQueryAndParam(actionIdIn in number

Line 314: ame_actions act

310: select description_query,
311: parameter,
312: parameter_two
313: from ame_action_types aty,
314: ame_actions act
315: where act.action_id = actionIdIn
316: and act.action_type_id = aty.action_type_id
317: and p_effective_date between act.start_date and nvl(act.end_date - (1/86400), p_effective_date)
318: and p_effective_date between aty.start_date and nvl(aty.end_date - (1/86400), p_effective_date);

Line 321: l_parameter_one ame_actions.parameter%type;

317: and p_effective_date between act.start_date and nvl(act.end_date - (1/86400), p_effective_date)
318: and p_effective_date between aty.start_date and nvl(aty.end_date - (1/86400), p_effective_date);
319:
320: l_query_string ame_action_types.description_query%type;
321: l_parameter_one ame_actions.parameter%type;
322: l_parameter_two ame_actions.parameter_two%type;
323: query_cursor integer;
324: dynamic_description varchar2(1);
325: action_description varchar2(500);

Line 322: l_parameter_two ame_actions.parameter_two%type;

318: and p_effective_date between aty.start_date and nvl(aty.end_date - (1/86400), p_effective_date);
319:
320: l_query_string ame_action_types.description_query%type;
321: l_parameter_one ame_actions.parameter%type;
322: l_parameter_two ame_actions.parameter_two%type;
323: query_cursor integer;
324: dynamic_description varchar2(1);
325: action_description varchar2(500);
326: l_result integer;

Line 398: ,ame_actions act

394:
395: if l_name = ame_util.substitutionTypeName or l_name = ame_util.positionTypeName then
396: select 'Y' into l_return_value
397: from wf_roles wfroles
398: ,ame_actions act
399: where wfroles.name = act.parameter
400: and wfroles.status = 'ACTIVE'
401: and (wfroles.expiration_date is null or
402: sysdate < wfroles.expiration_date)