APPS.AME_ACF_BUS dependencies on AME_ACTION_TYPE_CONFIG

Line 236: FROM ame_action_type_config

232: l_count number;
233: begin
234: SELECT count(action_type_id)
235: INTO l_count
236: FROM ame_action_type_config
237: WHERE application_id = p_application_id
238: AND action_type_id = p_action_type_id
239: AND SYSDATE BETWEEN start_date
240: AND nvl(end_date - (1/86400), sysdate);

Line 243: fnd_message.set_token('TABLE_NAME','ame_action_type_config');

239: AND SYSDATE BETWEEN start_date
240: AND nvl(end_date - (1/86400), sysdate);
241: IF l_count <> 0 then
242: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
243: fnd_message.set_token('TABLE_NAME','ame_action_type_config');
244: fnd_message.raise_error;
245: END if;
246: exception
247: when app_exception.application_exception then

Line 435: from ame_action_type_config

431: ,p_argument_value => p_order_number
432: );
433: /*select max(order_number + 1)
434: into max_order_number
435: from ame_action_type_config
436: where
437: application_id = p_application_id and
438: p_effective_date between start_date and
439: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 518: from ame_action_type_config acf

514: nvl(aty.end_date - (1/86400), sysdate);
515:
516: cursor c_sel2 is
517: select null
518: from ame_action_type_config acf
519: where ame_utility_pkg.is_seed_user(acf.created_by) = ame_util.seededDataCreatedById
520: and ame_utility_pkg.check_seeddb = 'N'
521: and acf.action_type_id = p_action_type_id
522: and acf.application_id = p_application_id