APPS.AME_ATY_SHD dependencies on AME_ACTIONS

Line 261: ,p_child_table_name1 => 'ame_actions'

257: ,p_datetrack_mode => p_datetrack_mode
258: ,p_base_table_name => 'ame_action_types'
259: ,p_base_key_column => 'action_type_id'
260: ,p_base_key_value => p_action_type_id
261: ,p_child_table_name1 => 'ame_actions'
262: ,p_child_key_column1 => 'action_type_id'
263: ,p_child_alt_base_key_column1 => 'EDIT HERE: Add base key column for
264: child table'
265: ,p_enforce_foreign_locking => true

Line 385: from ame_actions

381: ) is
382: --
383: Cursor C_Sel1 is
384: select count(*)
385: from ame_actions
386: where action_type_id = p_action_type_id and
387: p_start_date between start_date and
388: nvl(end_date - ame_util.oneSecond, p_start_date);
389: --

Line 422: -- ame_actions

418: --
419: Begin
420: --
421: --
422: -- ame_actions
423: Open C_Sel1;
424: Fetch C_Sel1 into l_child_count;
425: Close C_Sel1;
426: If l_child_count > 0 then

Line 428: fnd_message.set_token('TABLE_NAME','ame_actions');

424: Fetch C_Sel1 into l_child_count;
425: Close C_Sel1;
426: If l_child_count > 0 then
427: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
428: fnd_message.set_token('TABLE_NAME','ame_actions');
429: hr_multi_message.add;
430: End If;
431: -- ame_action_type_usages
432: Open C_Sel2;