APPS.AME_ACT_BUS dependencies on AME_ACTION_TYPES

Line 50: from ame_action_types

46: approvalGroup boolean;
47: --
48: Cursor c_sel1 is
49: select action_type_id
50: from ame_action_types
51: where
52: name in (ame_util.preApprovalTypeName,
53: ame_util.postApprovalTypeName,
54: ame_util.groupChainApprovalTypeName) and

Line 138: -- Validates that the action_type_id is a foreign key to ame_action_types.action_type_id.

134: --
135: -- {Start Of Comments}
136: --
137: -- Description:
138: -- Validates that the action_type_id is a foreign key to ame_action_types.action_type_id.
139: --
140: -- Prerequisites:
141: -- None.
142: --

Line 168: from ame_action_types

164: l_proc varchar2(72) := g_package||'chk_action_type_id';
165: tempCount integer;
166: cursor c_sel1 is
167: select null
168: from ame_action_types
169: where
170: action_type_id = p_action_type_id and
171: p_effective_date between start_date and
172: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 269: l_action_type_name ame_action_types.name%TYPE;

265: and rownum < 2;
266: l_proc varchar2(72) := g_package||'chk_parameter';
267: l_exists varchar2(1);
268: l_par_count number;
269: l_action_type_name ame_action_types.name%TYPE;
270: l_temp number;
271: begin
272: --The following call is a fix for bug 4380512
273: hr_api.mandatory_arg_error

Line 299: from ame_action_types

295: fnd_message.raise_error;
296: end if;
297: select name
298: into l_action_type_name
299: from ame_action_types
300: where action_type_id = p_action_type_id
301: and p_effective_date between start_date and
302: nvl(end_date - ame_util.oneSecond, p_effective_date);
303: if(l_action_type_name = 'substitution'

Line 406: -- ame_action_types.dynamic_descripton is set to ame_util.booleanFalse.

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.
410: --

Line 436: dynamicDescription ame_action_types.dynamic_description%type;

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
439: into dynamicDescription
440: from ame_action_types

Line 440: from ame_action_types

436: dynamicDescription ame_action_types.dynamic_description%type;
437: begin
438: select dynamic_description
439: into dynamicDescription
440: from ame_action_types
441: where
442: action_type_id = p_action_type_id and
443: p_effective_date between start_date and
444: nvl(end_date - ame_util.oneSecond, p_effective_date);