APPS.AME_RULE_PKG dependencies on AME_RULES_S

Line 1199: startDate ame_rules.start_date%type;

1195: raise;
1196: return(ame_util.disabledRulePriority); /* safe */
1197: end getRulePriorityMode;
1198: function getStartDate(ruleIdIn in integer) return date as
1199: startDate ame_rules.start_date%type;
1200: begin
1201: select start_date
1202: into startDate
1203: from ame_rules

Line 1831: select ame_rules_s.nextval into ruleId from dual;

1827: ruleId := -1;
1828: end if;
1829: end if;
1830: else
1831: select ame_rules_s.nextval into ruleId from dual;
1832: end if;
1833: else
1834: ruleId := ruleIdIn;
1835: select count(*)

Line 2103: newRuleStartDate ame_rules.start_date%type;

2099: createdBy integer;
2100: createUsage boolean;
2101: currentUserId integer;
2102: newRuleEndDate ame_rules.end_date%type;
2103: newRuleStartDate ame_rules.start_date%type;
2104: errorCode integer;
2105: errorMessage ame_util.longestStringType;
2106: invalidDateException exception;
2107: itemClassId integer;

Line 2592: ((sysdate between ame_rules.start_date and

2588: rule_type = typeIn and
2589: (item_class_id is null or
2590: item_class_id = itemClassIdIn) and
2591: ame_rules.rule_id = ame_rule_usages.rule_id and
2592: ((sysdate between ame_rules.start_date and
2593: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
2594: (sysdate < ame_rules.start_date and
2595: ame_rules.start_date < nvl(ame_rules.end_date,
2596: ame_rules.start_date + ame_util.oneSecond))) and

Line 2594: (sysdate < ame_rules.start_date and

2590: item_class_id = itemClassIdIn) and
2591: ame_rules.rule_id = ame_rule_usages.rule_id and
2592: ((sysdate between ame_rules.start_date and
2593: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
2594: (sysdate < ame_rules.start_date and
2595: ame_rules.start_date < nvl(ame_rules.end_date,
2596: ame_rules.start_date + ame_util.oneSecond))) and
2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 2595: ame_rules.start_date < nvl(ame_rules.end_date,

2591: ame_rules.rule_id = ame_rule_usages.rule_id and
2592: ((sysdate between ame_rules.start_date and
2593: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
2594: (sysdate < ame_rules.start_date and
2595: ame_rules.start_date < nvl(ame_rules.end_date,
2596: ame_rules.start_date + ame_util.oneSecond))) and
2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
2599: (sysdate < ame_rule_usages.start_date and

Line 2596: ame_rules.start_date + ame_util.oneSecond))) and

2592: ((sysdate between ame_rules.start_date and
2593: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
2594: (sysdate < ame_rules.start_date and
2595: ame_rules.start_date < nvl(ame_rules.end_date,
2596: ame_rules.start_date + ame_util.oneSecond))) and
2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
2599: (sysdate < ame_rule_usages.start_date and
2600: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

Line 2903: ruleStartDate ame_rules.start_date%type;

2899: objectVersionNoDataException exception;
2900: ruleId integer;
2901: ruleKey ame_rules.rule_key%type;
2902: ruleType integer;
2903: ruleStartDate ame_rules.start_date%type;
2904: ruleEndDate ame_rules.end_date%type;
2905: tempCount integer;
2906: tempIndex2 integer;
2907: processingDate date;