APPS.AME_ACT_BUS dependencies on AME_ACTIONS

Line 41: createdBy ame_actions.created_by%type;

37: (p_effective_date in date
38: ,p_rec in ame_act_shd.g_rec_type
39: ) IS
40: --
41: createdBy ame_actions.created_by%type;
42: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
43: l_error EXCEPTION;
44: l_argument varchar2(30);
45: actionTypeIds ame_util.idList;

Line 79: from ame_actions

75: -- not been updated.
76: /* Seeded actions cannot be deleted. */
77: select ame_utility_pkg.is_seed_user(created_by)
78: into createdBy
79: from ame_actions
80: where
81: action_id = p_rec.action_id and
82: p_effective_date between start_date and
83: nvl(end_date - ame_util.oneSecond, p_effective_date);

Line 253: p_parameter in ame_actions.parameter%type,

249: -- {End Of Comments}
250: -- ----------------------------------------------------------------------------
251: procedure chk_parameter
252: (p_effective_date in date,
253: p_parameter in ame_actions.parameter%type,
254: p_parameter_two in ame_actions.parameter_two%type,
255: p_action_type_id in number,
256: p_action_id in number default null) is
257: cursor c_sel1(p_name in varchar2) is

Line 254: p_parameter_two in ame_actions.parameter_two%type,

250: -- ----------------------------------------------------------------------------
251: procedure chk_parameter
252: (p_effective_date in date,
253: p_parameter in ame_actions.parameter%type,
254: p_parameter_two in ame_actions.parameter_two%type,
255: p_action_type_id in number,
256: p_action_id in number default null) is
257: cursor c_sel1(p_name in varchar2) is
258: select null

Line 285: from ame_actions

281: fnd_message.raise_error;
282: end if;
283: select count(action_id)
284: into l_par_count
285: from ame_actions
286: where action_type_id = p_action_type_id and
287: parameter = p_parameter and
288: ((parameter_two is null and p_parameter_two is null) or parameter_two = p_parameter_two) and
289: p_effective_date between start_date and

Line 405: -- Validates that the ame_actions.description is not null if the

401: --
402: -- {Start Of Comments}
403: --
404: -- Description:
405: -- Validates that the ame_actions.description is not null if the
406: -- ame_action_types.dynamic_descripton is set to ame_util.booleanFalse.
407: --
408: -- Prerequisites:
409: -- None.

Line 434: p_description in ame_actions.description%type) is

430: -- ----------------------------------------------------------------------------
431: procedure chk_at_dyn_desc_act_desc_comb
432: (p_effective_date in date,
433: p_action_type_id in number,
434: p_description in ame_actions.description%type) is
435: l_proc varchar2(72) := g_package||'chk_at_dyn_desc_act_desc_comb';
436: dynamicDescription ame_action_types.dynamic_description%type;
437: begin
438: select dynamic_description

Line 506: from ame_actions

502: l_proc varchar2(72) := g_package||'chk_delete';
503: tempCount integer;
504: Cursor c_sel1 Is
505: select null
506: from ame_actions
507: where
508: action_id = p_action_id and
509: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
510: ame_utility_pkg.check_seeddb = 'N';

Line 521: fnd_message.set_token('OBJECT','AME_ACTIONS.DELETE');

517: close c_sel1;
518: --
519: fnd_message.set_name('PER','AME_400477_CANNOT_DEL_SEEDED');
520: -- Message needed
521: fnd_message.set_token('OBJECT','AME_ACTIONS.DELETE');
522: fnd_message.raise_error;
523: end if;
524: close c_sel1;
525: exception