eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_RULE_API dependencies on AME_RULES

Line 117: l_rule_type ame_rules.rule_type%type;

113: l_allowProduction varchar2(30);
114: l_swi_package_name varchar2(30) := 'AME_RULE_SWI';
115: l_count number;
116: actionTypeIds ame_util.idList;
117: l_rule_type ame_rules.rule_type%type;
118: applicationName ame_calling_apps.application_name%type;
119: --+
120: cursor getApplicationName(applicationIdIn in integer)is
121: select application_name

Line 152: from ame_rules

148: ,applicationIdIn => p_application_id);
149: -- get that rule type
150: select rule_type
151: into l_rule_type
152: from ame_rules
153: where rule_id =p_rule_id
154: and (p_effective_date between start_date
155: and nvl(end_date - ame_util.oneSecond, p_effective_date )
156: or

Line 379: from ame_rules

375: ) return boolean as
376: cursor ruleIdCursor(typeIn in varchar2
377: ,itemClassIdIn in integer default null) is
378: select rule_id
379: from ame_rules
380: where rule_type = typeIn
381: and (item_class_id is null or item_class_id = itemClassIdIn)
382: and ((sysdate between start_date
383: and nvl(end_date - ame_util.oneSecond, sysdate))

Line 495: l_action_rule_type ame_rules.rule_type%type;

491: l_effective_date date;
492: l_use_count number := 0;
493: l_condition_type varchar2(10);
494: l_attribute_id number;
495: l_action_rule_type ame_rules.rule_type%type;
496: l_item_class_id ame_item_classes.item_class_id%type;
497: --+
498: cursor getActionRuleType is
499: select atyu.rule_type

Line 634: -- insert the row in ame_rules.

630: end if;
631:
632: l_effective_date := l_rul_start_date;
633: --
634: -- insert the row in ame_rules.
635: --
636: ame_rul_ins.ins(p_effective_date => l_effective_date
637: ,p_rule_type => p_rule_type
638: ,p_description => p_description

Line 982: l_rule_type ame_rules.rule_type%type;

978: and l_effective_date between start_date
979: and nvl(end_date - ame_util.oneSecond, l_effective_date);
980: l_rul_object_version_number number;
981: l_rule_id number;
982: l_rule_type ame_rules.rule_type%type;
983: l_item_class_id number;
984: l_item_class_name ame_item_classes.name%type;
985: l_date_changed varchar2(10);
986: l_variable_value varchar2(200);

Line 1099: from ame_rules

1095: ,l_rule_type
1096: ,l_rul_start_date
1097: ,l_rul_end_date
1098: ,l_rul_object_version_number
1099: from ame_rules
1100: where rule_id = p_rule_id
1101: and ((l_effective_date between start_date
1102: and nvl(end_date - ame_util.oneSecond, l_effective_date))
1103: or

Line 1447: from ame_rules

1443: select rule_type
1444: ,start_date
1445: ,end_date
1446: ,item_class_id
1447: from ame_rules
1448: where rule_id = p_rule_id
1449: and (l_effective_date between start_date
1450: and nvl(end_date - ame_util.oneSecond,l_effective_date) or
1451: (l_effective_date < start_date

Line 1486: l_rule_type ame_rules.rule_type%type;

1482: (sysdate < start_date and start_date < nvl(end_date, start_date + (1/86400)))
1483: );
1484: --+
1485: l_condition_count number;
1486: l_rule_type ame_rules.rule_type%type;
1487: l_item_class_id number;
1488: l_application_id number;
1489: l_overlapping_usage number;
1490: l_rlu_object_version_number number;

Line 1628: from ame_rules rul

1624: --+ Check if the rule is LM/SUB/LM COMB and error out if these rules already have an LM Condition.
1625: --+
1626: select count(*)
1627: into lm_count
1628: from ame_rules rul
1629: ,ame_condition_usages cnu
1630: ,ame_conditions cnd
1631: where rul.rule_id = p_rule_id
1632: and cnu.rule_id = rul.rule_id

Line 1840: from ame_rules

1836: and nvl(aatu.end_date - ame_util.oneSecond, l_effective_date);
1837: --+
1838: cursor getRuleDetails is
1839: select rule_type, start_date, end_date, item_class_id
1840: from ame_rules
1841: where rule_id = p_rule_id
1842: and ( l_effective_date between start_date and
1843: nvl(end_date - ame_util.oneSecond,l_effective_date ) or
1844: (l_effective_date < start_date and

Line 1921: l_rule_type ame_rules.rule_type%type;

1917: l_overlapping_usage number;
1918: l_rul_object_version_number number;
1919: l_rul_start_date date;
1920: l_rul_end_date date;
1921: l_rule_type ame_rules.rule_type%type;
1922: l_acu_object_version_number number;
1923: l_acu_start_date date;
1924: l_acu_end_date date;
1925: l_swi_package_name varchar2(30) := 'AME_RULE_SWI';

Line 2413: from ame_rules

2409: cursor getRuleDetails is
2410: select start_date
2411: ,end_date
2412: ,object_version_number
2413: from ame_rules
2414: where rule_id = p_rule_id
2415: and ((l_effective_date between start_date and nvl(end_date - ame_util.oneSecond, l_effective_date))
2416: or
2417: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)));

Line 2732: from ame_rules

2728: cursor getRuleDetails is
2729: select start_date
2730: ,end_date
2731: ,object_version_number
2732: from ame_rules
2733: where rule_id = p_rule_id
2734: and ((l_effective_date between start_date and nvl(end_date - ame_util.oneSecond, l_effective_date))
2735: or
2736: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)));

Line 3034: from ame_rules

3030: nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date );
3031: --+
3032: cursor getRuleDetails is
3033: select rule_type, start_date, end_date, item_class_id
3034: from ame_rules
3035: where rule_id = p_rule_id
3036: and ( l_effective_date between start_date and
3037: nvl(end_date - ame_util.oneSecond,l_effective_date ) or
3038: (l_effective_date < start_date and

Line 3083: l_rule_type ame_rules.rule_type%type;

3079: l_atu_start_date date;
3080: l_atu_end_date date;
3081: l_condition_count number;
3082: l_count number;
3083: l_rule_type ame_rules.rule_type%type;
3084: l_item_class_id number;
3085: l_application_id number;
3086: l_rul_object_version_number number;
3087: l_rul_start_date date;

Line 3375: from ame_rules

3371: select rule_type
3372: ,start_date
3373: ,end_date
3374: ,item_class_id
3375: from ame_rules
3376: where rule_id = p_rule_id
3377: and ((l_effective_date between start_date and nvl(end_date - ame_util.oneSecond, l_effective_date))
3378: or
3379: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)));

Line 3418: l_rule_type ame_rules.rule_type%type;

3414: l_allowAllApproverTypes varchar2(30);
3415: l_allowProduction varchar2(30);
3416: l_action_type_id number;
3417: l_atu_object_version_number integer;
3418: l_rule_type ame_rules.rule_type%type;
3419: l_item_class_id number;
3420: l_date_changed varchar2(10);
3421: l_application_id number;
3422: l_acu_object_version_number number;

Line 3652: from ame_rules

3648: select rule_type
3649: ,start_date
3650: ,end_date
3651: ,item_class_id
3652: from ame_rules
3653: where rule_id = p_rule_id
3654: and (l_effective_date between start_date
3655: and nvl(end_date - ame_util.oneSecond,l_effective_date) or
3656: (l_effective_date < start_date

Line 3668: l_rule_type ame_rules.rule_type%type;

3664: or
3665: (sysdate < start_date and start_date < nvl(end_date, start_date + (1/86400)))
3666: );
3667: --+
3668: l_rule_type ame_rules.rule_type%type;
3669: l_item_class_id number;
3670: l_rul_start_date date;
3671: l_rul_end_date date;
3672: l_count number;