APPS.AME_ATU_BUS dependencies on AME_ATTRIBUTES

Line 144: ( select item_class_id from ame_attributes

140: cursor c_sel1 is
141: select null
142: from ame_item_class_usages
143: where application_id = p_application_id and item_class_id =
144: ( select item_class_id from ame_attributes
145: where attribute_id = p_attribute_id and sysdate between start_date
146: and nvl(end_date - ame_util.oneSecond,sysdate))
147: and sysdate between start_date and nvl(end_date - ame_util.oneSecond,sysdate);
148: begin

Line 187: from ame_attributes

183: begin
184:
185: select approver_type_id
186: into l_approver_type_id
187: from ame_attributes
188: where attribute_id = p_attribute_id and
189: sysdate between start_date and
190: nvl(end_date - ame_util.oneSecond, sysdate) ;
191:

Line 285: l_attribute_type ame_attributes.attribute_type%type;

281: procedure chk_attr_type_val_set_id_comb
282: (p_attribute_id in number,
283: p_value_set_id in number
284: ) is
285: l_attribute_type ame_attributes.attribute_type%type;
286: l_format_type varchar2(1);
287: l_proc varchar2(72) := g_package||'chk_attr_type_value_set_id_comb';
288: begin
289: select attribute_type

Line 291: from ame_attributes

287: l_proc varchar2(72) := g_package||'chk_attr_type_value_set_id_comb';
288: begin
289: select attribute_type
290: into l_attribute_type
291: from ame_attributes
292: where attribute_id = p_attribute_id
293: and sysdate between start_date and
294: nvl(end_date - ame_util.oneSecond, sysdate) ;
295: if (l_attribute_type = ame_util.booleanAttributeType)

Line 340: -- Validates that the attribute_id is a foreign key to ame_attributes.attribute_id.

336: --
337: -- {Start Of Comments}
338: --
339: -- Description:
340: -- Validates that the attribute_id is a foreign key to ame_attributes.attribute_id.
341: --
342: -- Prerequisites:
343: -- None.
344: --

Line 370: from ame_attributes

366: l_proc varchar2(72) := g_package||'chk_attribute_id';
367: tempCount integer;
368: cursor c_sel1 is
369: select null
370: from ame_attributes
371: where
372: attribute_id = p_attribute_id and
373: p_effective_date between start_date and
374: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 721: l_attribute_type ame_attributes.attribute_type%type;

717: l_amount ame_attribute_usages.query_string%type;
718: l_currencyCode ame_attribute_usages.query_string%type;
719: l_conversionType ame_attribute_usages.query_string%type;
720: l_tmpAmount ame_attribute_usages.query_string%type;
721: l_attribute_type ame_attributes.attribute_type%type;
722: l_attribute_name ame_attributes.name%type;
723: numMonths ame_util.stringList;
724: substitutionString ame_util.stringType;
725: transIdPlaceholderPosition integer;

Line 722: l_attribute_name ame_attributes.name%type;

718: l_currencyCode ame_attribute_usages.query_string%type;
719: l_conversionType ame_attribute_usages.query_string%type;
720: l_tmpAmount ame_attribute_usages.query_string%type;
721: l_attribute_type ame_attributes.attribute_type%type;
722: l_attribute_name ame_attributes.name%type;
723: numMonths ame_util.stringList;
724: substitutionString ame_util.stringType;
725: transIdPlaceholderPosition integer;
726: transIdPlaceholderPosition2 integer;

Line 739: from ame_attributes

735: begin
736: -- get attribute type
737: select name,attribute_type
738: into l_attribute_name,l_attribute_type
739: from ame_attributes
740: where attribute_id = p_attribute_id
741: and p_effective_date between start_date and
742: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
743: if (p_is_static = ame_util.booleanTrue ) then /* static usage */

Line 805: from ame_attributes

801: end if;
802: begin
803: select name
804: into l_attr_name
805: from ame_attributes
806: where attribute_id = p_attribute_id
807: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
808: if l_attr_name = 'REJECTION_RESPONSE' and p_query_string is not null then
809: if p_query_string not in ('STOP_ALL_ITEMS'

Line 864: from ame_attributes

860: end if;
861: begin
862: select ame_util2.specialObject
863: into l_object
864: from ame_attributes
865: where attribute_id = p_attribute_id
866: and name in (ame_util.jobLevelStartingPointAttribute
867: ,ame_util.nonDefStartingPointPosAttr
868: ,ame_util.nonDefPosStructureAttr