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_ACTION_TYPES

Line 294: from ame_action_types aty,

290: ,p_effective_date in date default sysdate) return varchar2 is
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)

Line 313: from ame_action_types aty,

309: ,p_effective_date in date) is
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)

Line 320: l_query_string ame_action_types.description_query%type;

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);
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);

Line 385: l_name ame_action_types.name%type;

381:
382: function is_approver_valid_in_action(p_action_type_id in number
383: ,p_action_id in number) return varchar2 is
384: l_return_value varchar2(1);
385: l_name ame_action_types.name%type;
386: begin
387: select name into l_name
388: from ame_action_types
389: where action_type_id = p_action_type_id

Line 388: from ame_action_types

384: l_return_value varchar2(1);
385: l_name ame_action_types.name%type;
386: begin
387: select name into l_name
388: from ame_action_types
389: where action_type_id = p_action_type_id
390: and sysdate between start_date and nvl(end_date-(1/86400),sysdate)
391: and rownum < 2;
392:

Line 767: from ame_action_types act,

763: list varchar2(4000);
764:
765: cursor action_types_cursor(l_attribute_id number)is
766: select act.name
767: from ame_action_types act,
768: ame_mandatory_attributes man
769: where Man.action_type_id = Act.action_type_id
770: and sysdate between act.start_date and nvl(act.end_date,sysdate)
771: and sysdate between man.start_date and nvl(man.end_date,sysdate)