2857: ruleType := ruleTypeIn;
2858: end if;
2859: select count(*)
2860: into lineItemClassCount
2861: from ame_item_classes, ame_item_class_usages
2862: where
2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and
2859: select count(*)
2860: into lineItemClassCount
2861: from ame_item_classes, ame_item_class_usages
2862: where
2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and
2866: sysdate between
2867: ame_item_classes.start_date and
2860: into lineItemClassCount
2861: from ame_item_classes, ame_item_class_usages
2862: where
2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and
2866: sysdate between
2867: ame_item_classes.start_date and
2868: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2866: sysdate between
2867: ame_item_classes.start_date and
2868: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2869: sysdate
2870: between ame_item_class_usages.start_date and
2871: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
2872: allowProductions := ame_util.getConfigVar(variableNameIn => ame_util.productionConfigVar,
2873: applicationIdIn => applicationIdIn);
2874: /*
2867: ame_item_classes.start_date and
2868: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2869: sysdate
2870: between ame_item_class_usages.start_date and
2871: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
2872: allowProductions := ame_util.getConfigVar(variableNameIn => ame_util.productionConfigVar,
2873: applicationIdIn => applicationIdIn);
2874: /*
2875: Transform the configuration-variable value into one of the pseudo-boolean values used by
2978: lineItemClassCount integer;
2979: begin
2980: select count(*)
2981: into lineItemClassCount
2982: from ame_item_classes, ame_item_class_usages
2983: where
2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and
2980: select count(*)
2981: into lineItemClassCount
2982: from ame_item_classes, ame_item_class_usages
2983: where
2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and
2987: sysdate between
2988: ame_item_classes.start_date and
2981: into lineItemClassCount
2982: from ame_item_classes, ame_item_class_usages
2983: where
2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and
2987: sysdate between
2988: ame_item_classes.start_date and
2989: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2987: sysdate between
2988: ame_item_classes.start_date and
2989: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2990: sysdate
2991: between ame_item_class_usages.start_date and
2992: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
2993: allowProductions := ame_util.getConfigVar(variableNameIn => ame_util.productionConfigVar,
2994: applicationIdIn => applicationIdIn);
2995: /*
2988: ame_item_classes.start_date and
2989: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2990: sysdate
2991: between ame_item_class_usages.start_date and
2992: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
2993: allowProductions := ame_util.getConfigVar(variableNameIn => ame_util.productionConfigVar,
2994: applicationIdIn => applicationIdIn);
2995: /*
2996: Transform the configuration-variable value into one of the pseudo-boolean values used by