DBA Data[Home] [Help]

APPS.AME_ACTION_PKG dependencies on AME_ACTION_TYPES_S

Line 168: sysdate between ame_action_types.start_date and

164: sysdate between ame_action_type_config.start_date and
165: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
166: sysdate between ame_action_type_usages.start_date and
167: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
168: sysdate between ame_action_types.start_date and
169: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate);
170: return(orderNumber);
171: exception
172: when others then

Line 220: sysdate between ame_action_types.start_date and

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);
223: exception
224: when others then

Line 561: sysdate between ame_action_types.start_date and

557: ame_action_types
558: where
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

Line 983: select ame_action_types_s.nextval into actionTypeId from dual;

979: */
980: currentUserId := ame_util.getCurrentUserId;
981: if(actionTypeIdIn is null) then
982: createdBy := currentUserId;
983: select ame_action_types_s.nextval into actionTypeId from dual;
984: else
985: actionTypeId := actionTypeIdIn;
986: select count(*)
987: into tempCount

Line 2411: sysdate between ame_action_types.start_date and

2407: ame_actions
2408: where
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;

Line 2491: sysdate between ame_action_types.start_date and

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;
2494: actionId integer;
2495: tempIndex integer;

Line 2619: sysdate between ame_action_types.start_date and

2615: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2616: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
2617: ame_action_type_config.application_id = applicationIdIn and
2618: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
2619: sysdate between ame_action_types.start_date and
2620: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2621: sysdate between ame_action_type_usages.start_date and
2622: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
2623: sysdate between ame_action_type_config.start_date and

Line 2837: ame_action_types.start_date and

2833: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
2834: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and
2835: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and
2836: sysdate between
2837: ame_action_types.start_date and
2838: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2839: sysdate
2840: between ame_action_type_usages.start_date and
2841: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

Line 2965: ame_action_types.start_date and

2961: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
2962: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and
2963: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and
2964: sysdate between
2965: ame_action_types.start_date and
2966: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2967: sysdate
2968: between ame_action_type_usages.start_date and
2969: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)