APPS.AME_TEST_UTILITY_PKG dependencies on AME_ITEM_CLASSES

Line 275: itemName ame_item_classes.name%type;

271: return null;
272: end getConditionsList;
273: --+
274: function getItemClassNameById(itemClassIdIn in integer) return varchar2 as
275: itemName ame_item_classes.name%type;
276: begin
277: select user_item_class_name
278: into itemName
279: from ame_item_classes_vl

Line 279: from ame_item_classes_vl

275: itemName ame_item_classes.name%type;
276: begin
277: select user_item_class_name
278: into itemName
279: from ame_item_classes_vl
280: where item_class_id = itemClassIdIn and
281: sysdate between start_date and
282: nvl(end_date - ame_util.oneSecond, sysdate) ;
283: return(itemName);

Line 296: itemName ame_item_classes.name%type;

292: return null;
293: end getItemClassNameById;
294: --+
295: function getItemClassName(itemClassNameIn in varchar2) return varchar2 as
296: itemName ame_item_classes.name%type;
297: begin
298: select user_item_class_name
299: into itemName
300: from ame_item_classes_vl

Line 300: from ame_item_classes_vl

296: itemName ame_item_classes.name%type;
297: begin
298: select user_item_class_name
299: into itemName
300: from ame_item_classes_vl
301: where trim(name) = trim(itemClassNameIn) and
302: sysdate between start_date and
303: nvl(end_date - ame_util.oneSecond, sysdate) ;
304: return(itemName);

Line 587: ame_item_classes

583: ame_attributes.approver_type_id
584: from
585: ame_attributes,
586: ame_attribute_usages,
587: ame_item_classes
588: where
589: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
590: ame_attributes.item_class_id = ame_item_classes.item_class_id and
591: ame_item_classes.item_class_id = headerItemClassIdIn and

Line 590: ame_attributes.item_class_id = ame_item_classes.item_class_id and

586: ame_attribute_usages,
587: ame_item_classes
588: where
589: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
590: ame_attributes.item_class_id = ame_item_classes.item_class_id and
591: ame_item_classes.item_class_id = headerItemClassIdIn and
592: ame_attribute_usages.application_id = applicationIdIn and
593: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
594: ame_attributes.attribute_id not in

Line 591: ame_item_classes.item_class_id = headerItemClassIdIn and

587: ame_item_classes
588: where
589: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
590: ame_attributes.item_class_id = ame_item_classes.item_class_id and
591: ame_item_classes.item_class_id = headerItemClassIdIn and
592: ame_attribute_usages.application_id = applicationIdIn and
593: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
594: ame_attributes.attribute_id not in
595: (select attribute_id from ame_mandatory_attributes

Line 603: sysdate between ame_item_classes.start_date and

599: sysdate between ame_attributes.start_date and
600: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
601: sysdate between ame_attribute_usages.start_date and
602: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
603: sysdate between ame_item_classes.start_date and
604: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
605: order by ame_attributes.name;
606: tempIndex integer;
607: begin

Line 604: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)

600: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
601: sysdate between ame_attribute_usages.start_date and
602: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
603: sysdate between ame_item_classes.start_date and
604: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
605: order by ame_attributes.name;
606: tempIndex integer;
607: begin
608: tempIndex := 1;