26: cursor getMandatoryAttributesCur is
27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
37: cursor getHeaderItemId is
38: select item_class_id
39: from ame_item_classes
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
37: cursor getHeaderItemId is
38: select item_class_id
39: from ame_item_classes
40: where name = ame_util.headerItemClassName