APPS.AME_ATY_BUS dependencies on AME_ACTION_TYPES

Line 48: createdBy ame_action_types.created_by%type;

44: (p_effective_date in date
45: ,p_rec in ame_aty_shd.g_rec_type
46: ) IS
47: --
48: createdBy ame_action_types.created_by%type;
49: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
50: l_error EXCEPTION;
51: l_argument varchar2(30);
52: --

Line 72: from ame_action_types

68: -- EDIT_HERE: Add checks to ensure non-updateable args have
69: -- not been updated.
70: select ame_utility_pkg.is_seed_user(created_by)
71: into createdBy
72: from ame_action_types
73: where
74: action_type_id = p_rec.action_type_id and
75: p_effective_date between start_date and
76: nvl(end_date - ame_util.oneSecond, p_effective_date);

Line 151: p_name in ame_action_types.name%type) is

147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: procedure chk_name
150: (p_effective_date in date,
151: p_name in ame_action_types.name%type) is
152: l_proc varchar2(72) := g_package||'chk_name';
153: cursor c_sel1 is
154: select null
155: from ame_action_types

Line 155: from ame_action_types

151: p_name in ame_action_types.name%type) is
152: l_proc varchar2(72) := g_package||'chk_name';
153: cursor c_sel1 is
154: select null
155: from ame_action_types
156: where
157: name = p_name and
158: p_effective_date between start_date and
159: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 268: p_procedure_name in ame_action_types.procedure_name%type) is

264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: procedure chk_procedure_name
267: (p_effective_date in date,
268: p_procedure_name in ame_action_types.procedure_name%type) is
269: l_proc varchar2(72) := g_package||'chk_procedure_name';
270: cursor c_sel1 is
271: select null
272: from ame_action_types

Line 272: from ame_action_types

268: p_procedure_name in ame_action_types.procedure_name%type) is
269: l_proc varchar2(72) := g_package||'chk_procedure_name';
270: cursor c_sel1 is
271: select null
272: from ame_action_types
273: where
274: procedure_name = p_procedure_name and
275: p_effective_date between start_date and
276: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 517: from ame_action_types

513: p_effective_date between start_date and
514: nvl(end_date - ame_util.oneSecond, p_effective_date);
515: cursor c_sel5 Is
516: select null
517: from ame_action_types
518: where
519: action_type_id = p_action_type_id and
520: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
521: ame_utility_pkg.check_seeddb = 'N';

Line 583: fnd_message.set_token('TABLE_NAME','ame_action_types');

579: close c_sel5;
580: -- AT MESSAGE
581: -- Seeded action types cannot be deleted
582: fnd_message.set_name('PER','AME_400601_SD_ACT_TYP_CN_DEL');
583: fnd_message.set_token('TABLE_NAME','ame_action_types');
584: fnd_message.raise_error;
585: end if;
586: close c_sel5;
587: -- Action types with existing actions cannot be deleted.

Line 595: fnd_message.set_token('TABLE_NAME','ame_action_types');

591: close c_sel6;
592: -- AT MESSAGE
593: -- Action types with existing actions cannot be deleted
594: fnd_message.set_name('PER','AME_400602_ACT_EXT_ATYP_CN_DEL');
595: fnd_message.set_token('TABLE_NAME','ame_action_types');
596: fnd_message.raise_error;
597: end if;
598: close c_sel6;
599: exception