APPS.AME_ATR_BUS dependencies on AME_MANDATORY_ATTRIBUTES

Line 333: from ame_mandatory_attributes

329: p_effective_date between start_date and
330: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
331: cursor c_sel2 is
332: select null
333: from ame_mandatory_attributes
334: where
335: attribute_id = p_attribute_id and
336: p_effective_date between start_date and
337: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 384: from ame_mandatory_attributes

380: nvl(end_date - ame_util.oneSecond, p_start_date) ;
381: --
382: Cursor C_Sel2 is
383: select count(*)
384: from ame_mandatory_attributes
385: where attribute_id = p_attribute_id
386: and p_start_date between start_date and
387: nvl(end_date - ame_util.oneSecond, p_start_date) ;
388: --

Line 412: -- ame_mandatory_attributes

408: fnd_message.set_name('AME','AME_400523_ATT_ATTR_USG_EXIST');
409: fnd_message.set_token('TABLE_NAME','ame_attribute_usages');
410: hr_multi_message.add;
411: End If;
412: -- ame_mandatory_attributes
413: Open C_Sel2;
414: Fetch C_Sel2 into l_child_count;
415: Close C_Sel2;
416: If l_child_count >0 then

Line 418: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');

414: Fetch C_Sel2 into l_child_count;
415: Close C_Sel2;
416: If l_child_count >0 then
417: fnd_message.set_name('AME','AME_400170_ATT_MAND_CANT_DEL');
418: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');
419: hr_multi_message.add;
420: End If;
421: -- ame_conditions
422: Open C_Sel3;