DBA Data[Home] [Help]

APPS.AME_ACTION_PKG dependencies on AME_ITEM_CLASS_USAGES

Line 2861: from ame_item_classes, ame_item_class_usages

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

Line 2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id 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

Line 2864: ame_item_class_usages.application_id = applicationIdIn 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

Line 2870: between ame_item_class_usages.start_date 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: /*

Line 2871: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

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

Line 2982: from ame_item_classes, ame_item_class_usages

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

Line 2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id 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

Line 2985: ame_item_class_usages.application_id = applicationIdIn 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

Line 2991: between ame_item_class_usages.start_date 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: /*

Line 2992: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

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