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_ACTION_PKG dependencies on AME_ACTIONS_S

Line 218: sysdate between ame_actions.start_date and

214: ame_action_types
215: where
216: ame_actions.action_type_id = ame_action_types.action_type_id and
217: action_id = actionIdIn and
218: sysdate between ame_actions.start_date and
219: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
220: sysdate between ame_action_types.start_date and
221: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate);
222: return(name);

Line 563: sysdate between ame_actions.start_date and

559: ame_actions.action_type_id = ame_action_types.action_type_id and
560: action_id = actionIdIn and
561: sysdate between ame_action_types.start_date and
562: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
563: sysdate between ame_actions.start_date and
564: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
565: if(instrb(descriptionQuery, ame_util.actionParameterOne) > 0) then
566: if(instrb(descriptionQuery, ame_util.actionParameterTwo) > 0) then /* both parameters */
567: execute immediate descriptionQuery

Line 1267: select ame_actions_s.nextval into actionId from dual;

1263: */
1264: currentUserId := ame_util.getCurrentUserId;
1265: if(actionIdIn is null) then
1266: createdBy := currentUserId;
1267: select ame_actions_s.nextval into actionId from dual;
1268: else
1269: actionId := actionIdIn;
1270: select count(*)
1271: into tempCount

Line 2413: sysdate between ame_actions.start_date and

2409: ame_action_types.action_type_id = ame_actions.action_type_id and
2410: ame_action_types.action_type_id = actionTypeIdIn and
2411: sysdate between ame_action_types.start_date and
2412: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2413: sysdate between ame_actions.start_date and
2414: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate)
2415: order by ame_actions.created_by, ame_actions.description;
2416: parameterOne ame_actions.parameter%type;
2417: parameterTwo ame_actions.parameter_two%type;

Line 2489: sysdate between ame_actions.start_date and

2485: ame_action_types
2486: where
2487: ame_actions.action_type_id = ame_action_types.action_type_id and
2488: ame_actions.action_type_id = actionTypeIdIn and
2489: sysdate between ame_actions.start_date and
2490: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
2491: sysdate between ame_action_types.start_date and
2492: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate)
2493: order by ame_actions.created_by, ame_actions.description;