APPS.AME_ATR_BUS dependencies on AME_ATTRIBUTE_USAGES

Line 326: from ame_attribute_usages

322: l_proc varchar2(72) := g_package||'chk_delete';
323: tempCount integer;
324: cursor c_sel1 is
325: select null
326: from ame_attribute_usages
327: where
328: attribute_id = p_attribute_id and
329: p_effective_date between start_date and
330: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 377: from ame_attribute_usages

373: ) is
374: --
375: Cursor C_Sel1 is
376: select count(*)
377: from ame_attribute_usages
378: where attribute_id = p_attribute_id and
379: p_start_date between start_date and
380: nvl(end_date - ame_util.oneSecond, p_start_date) ;
381: --

Line 403: -- ame_attribute_usages

399: --
400: Begin
401: --
402: --
403: -- ame_attribute_usages
404: Open C_Sel1;
405: Fetch C_Sel1 into l_child_count;
406: Close C_Sel1;
407: If l_child_count >0 then

Line 409: fnd_message.set_token('TABLE_NAME','ame_attribute_usages');

405: Fetch C_Sel1 into l_child_count;
406: Close C_Sel1;
407: If l_child_count >0 then
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;