APPS.AME_ATR_BUS dependencies on AME_ATTRIBUTES

Line 52: p_approver_type_id in ame_attributes.approver_type_id%type,

48: procedure chk_approver_type_id
49: (p_attribute_id in number,
50: p_object_version_number in number,
51: p_effective_date in date,
52: p_approver_type_id in ame_attributes.approver_type_id%type,
53: p_attribute_type in ame_attributes.attribute_type%type) is
54: l_proc varchar2(72) := g_package||'chk_approver_type_id';
55: tempCount integer;
56: cursor c_sel1 is

Line 53: p_attribute_type in ame_attributes.attribute_type%type) is

49: (p_attribute_id in number,
50: p_object_version_number in number,
51: p_effective_date in date,
52: p_approver_type_id in ame_attributes.approver_type_id%type,
53: p_attribute_type in ame_attributes.attribute_type%type) is
54: l_proc varchar2(72) := g_package||'chk_approver_type_id';
55: tempCount integer;
56: cursor c_sel1 is
57: select null

Line 129: p_attribute_type in ame_attributes.attribute_type%type) is

125: -- ----------------------------------------------------------------------------
126: procedure chk_attribute_type
127: (p_attribute_id in number,
128: p_object_version_number in number,
129: p_attribute_type in ame_attributes.attribute_type%type) is
130: l_proc varchar2(72) := g_package||'chk_attribute_type';
131: begin
132: if not (p_attribute_type = ame_util.booleanAttributeType or
133: p_attribute_type = ame_util.currencyAttributeType or

Line 186: p_item_class_id in ame_attributes.item_class_id%type) is

182: procedure chk_item_class_id
183: (p_attribute_id in number,
184: p_object_version_number in number,
185: p_effective_date in date,
186: p_item_class_id in ame_attributes.item_class_id%type) is
187: l_proc varchar2(72) := g_package||'chk_item_class_id';
188: tempCount integer;
189: cursor c_sel1 is
190: select null

Line 251: p_name in ame_attributes.name%type) is

247: procedure chk_name
248: (p_attribute_id in number,
249: p_object_version_number in number,
250: p_effective_date in date,
251: p_name in ame_attributes.name%type) is
252: l_proc varchar2(72) := g_package||'chk_name';
253: tempCount integer;
254: cursor c_sel1 is
255: select count(*)

Line 256: from ame_attributes

252: l_proc varchar2(72) := g_package||'chk_name';
253: tempCount integer;
254: cursor c_sel1 is
255: select count(*)
256: from ame_attributes
257: where
258: trim(upper(name)) = trim(upper(p_name)) and
259: p_effective_date between start_date and
260: nvl(end_date - ame_util.oneSecond, p_effective_date) ;