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_CONDITIONS

Line 14: l_condition_type ame_conditions.condition_type%type;

10: -- This is a private function which returns the condition type
11: --+
12: function getConditionType(p_condition_id in integer
13: ,p_effective_date in date) return varchar2 as
14: l_condition_type ame_conditions.condition_type%type;
15: begin
16: select condition_type
17: into l_condition_type
18: from ame_conditions

Line 18: from ame_conditions

14: l_condition_type ame_conditions.condition_type%type;
15: begin
16: select condition_type
17: into l_condition_type
18: from ame_conditions
19: where ame_conditions.condition_id = p_condition_id
20: and p_effective_date between start_date
21: and nvl(end_date - ame_util.oneSecond, p_effective_date);
22: return(l_condition_type);

Line 19: where ame_conditions.condition_id = p_condition_id

15: begin
16: select condition_type
17: into l_condition_type
18: from ame_conditions
19: where ame_conditions.condition_id = p_condition_id
20: and p_effective_date between start_date
21: and nvl(end_date - ame_util.oneSecond, p_effective_date);
22: return(l_condition_type);
23: exception

Line 303: select ame_conditions.condition_id condition_id

299: --+
300: procedure getConditionIds(ruleIdIn in integer,
301: conditionIdListOut out nocopy ame_util.idList) as
302: cursor conditionCursor(ruleIdIn in integer) is
303: select ame_conditions.condition_id condition_id
304: ,ame_conditions.condition_type condition_type
305: from ame_conditions
306: ,ame_condition_usages
307: where ame_conditions.condition_id = ame_condition_usages.condition_id

Line 304: ,ame_conditions.condition_type condition_type

300: procedure getConditionIds(ruleIdIn in integer,
301: conditionIdListOut out nocopy ame_util.idList) as
302: cursor conditionCursor(ruleIdIn in integer) is
303: select ame_conditions.condition_id condition_id
304: ,ame_conditions.condition_type condition_type
305: from ame_conditions
306: ,ame_condition_usages
307: where ame_conditions.condition_id = ame_condition_usages.condition_id
308: and ame_condition_usages.rule_id = ruleIdIn

Line 305: from ame_conditions

301: conditionIdListOut out nocopy ame_util.idList) as
302: cursor conditionCursor(ruleIdIn in integer) is
303: select ame_conditions.condition_id condition_id
304: ,ame_conditions.condition_type condition_type
305: from ame_conditions
306: ,ame_condition_usages
307: where ame_conditions.condition_id = ame_condition_usages.condition_id
308: and ame_condition_usages.rule_id = ruleIdIn
309: and (ame_conditions.start_date <= sysdate

Line 307: where ame_conditions.condition_id = ame_condition_usages.condition_id

303: select ame_conditions.condition_id condition_id
304: ,ame_conditions.condition_type condition_type
305: from ame_conditions
306: ,ame_condition_usages
307: where ame_conditions.condition_id = ame_condition_usages.condition_id
308: and ame_condition_usages.rule_id = ruleIdIn
309: and (ame_conditions.start_date <= sysdate
310: and (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))
311: and ((sysdate between ame_condition_usages.start_date

Line 309: and (ame_conditions.start_date <= sysdate

305: from ame_conditions
306: ,ame_condition_usages
307: where ame_conditions.condition_id = ame_condition_usages.condition_id
308: and ame_condition_usages.rule_id = ruleIdIn
309: and (ame_conditions.start_date <= sysdate
310: and (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))
311: and ((sysdate between ame_condition_usages.start_date
312: and nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate))
313: or

Line 310: and (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))

306: ,ame_condition_usages
307: where ame_conditions.condition_id = ame_condition_usages.condition_id
308: and ame_condition_usages.rule_id = ruleIdIn
309: and (ame_conditions.start_date <= sysdate
310: and (ame_conditions.end_date is null or sysdate < ame_conditions.end_date))
311: and ((sysdate between ame_condition_usages.start_date
312: and nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate))
313: or
314: (sysdate < ame_condition_usages.start_date

Line 510: from ame_conditions

506: --+
507: cursor getConditionDetails is
508: select condition_type
509: ,attribute_id
510: from ame_conditions
511: where condition_id = p_condition_id
512: and l_effective_date between start_date
513: and nvl(end_date - ame_util.oneSecond,l_effective_date);
514:

Line 906: select ame_conditions.attribute_id

902: ,end_date
903: ,object_version_number
904: from ame_attribute_usages
905: where attribute_id in (
906: select ame_conditions.attribute_id
907: from ame_conditions
908: ,ame_condition_usages
909: where ame_condition_usages.rule_id = p_rule_id
910: and (l_effective_date between ame_condition_usages.start_date

Line 907: from ame_conditions

903: ,object_version_number
904: from ame_attribute_usages
905: where attribute_id in (
906: select ame_conditions.attribute_id
907: from ame_conditions
908: ,ame_condition_usages
909: where ame_condition_usages.rule_id = p_rule_id
910: and (l_effective_date between ame_condition_usages.start_date
911: and nvl(ame_condition_usages.end_date - ame_util.oneSecond, l_effective_date )

Line 916: and ame_condition_usages.condition_id = ame_conditions.condition_id

912: or
913: (l_effective_date < ame_condition_usages.start_date
914: and ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
915: ame_condition_usages.start_date + ame_util.oneSecond)))
916: and ame_condition_usages.condition_id = ame_conditions.condition_id
917: and l_effective_date between ame_conditions.start_date
918: and nvl(ame_conditions.end_date - ame_util.oneSecond, l_effective_date)
919: )
920: and application_id = p_application_id

Line 917: and l_effective_date between ame_conditions.start_date

913: (l_effective_date < ame_condition_usages.start_date
914: and ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
915: ame_condition_usages.start_date + ame_util.oneSecond)))
916: and ame_condition_usages.condition_id = ame_conditions.condition_id
917: and l_effective_date between ame_conditions.start_date
918: and nvl(ame_conditions.end_date - ame_util.oneSecond, l_effective_date)
919: )
920: and application_id = p_application_id
921: and l_effective_date between ame_attribute_usages.start_date

Line 918: and nvl(ame_conditions.end_date - ame_util.oneSecond, l_effective_date)

914: and ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
915: ame_condition_usages.start_date + ame_util.oneSecond)))
916: and ame_condition_usages.condition_id = ame_conditions.condition_id
917: and l_effective_date between ame_conditions.start_date
918: and nvl(ame_conditions.end_date - ame_util.oneSecond, l_effective_date)
919: )
920: and application_id = p_application_id
921: and l_effective_date between ame_attribute_usages.start_date
922: and nvl(ame_attribute_usages.end_date - ame_util.oneSecond, l_effective_date);

Line 1432: l_condition_type ame_conditions.condition_type%type;

1428: l_proc varchar2(72) := g_package||'create_ame_rule_usage';
1429: l_dummy varchar2(10);
1430: l_swi_package_name varchar2(30) := 'AME_RULE_SWI';
1431: l_effective_date date;
1432: l_condition_type ame_conditions.condition_type%type;
1433: l_attribute_id number;
1434: l_swi_call boolean;
1435: cursor getConditionDetails is
1436: select condition_type

Line 1438: from ame_conditions

1434: l_swi_call boolean;
1435: cursor getConditionDetails is
1436: select condition_type
1437: ,attribute_id
1438: from ame_conditions
1439: where condition_id = p_condition_id
1440: and l_effective_date between start_date
1441: and nvl(end_date - ame_util.oneSecond,l_effective_date);
1442: cursor getRuleDetails is

Line 1630: ,ame_conditions cnd

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
1633: and cnd.condition_id = cnu.condition_id
1634: and cnd.condition_type = 'post'

Line 2752: select ame_conditions.attribute_id attribute_id

2748: (l_effective_date < start_date
2749: and start_date < nvl(end_date,start_date + ame_util.oneSecond)));
2750: --+
2751: cursor getRuleConditions is
2752: select ame_conditions.attribute_id attribute_id
2753: from ame_conditions
2754: ,ame_condition_usages
2755: where ame_condition_usages.rule_id = p_rule_id
2756: and (l_effective_date between ame_condition_usages.start_date

Line 2753: from ame_conditions

2749: and start_date < nvl(end_date,start_date + ame_util.oneSecond)));
2750: --+
2751: cursor getRuleConditions is
2752: select ame_conditions.attribute_id attribute_id
2753: from ame_conditions
2754: ,ame_condition_usages
2755: where ame_condition_usages.rule_id = p_rule_id
2756: and (l_effective_date between ame_condition_usages.start_date
2757: and nvl(ame_condition_usages.end_date - ame_util.oneSecond, l_effective_date)

Line 2762: and ame_condition_usages.condition_id = ame_conditions.condition_id

2758: or
2759: (l_effective_date < ame_condition_usages.start_date
2760: and ame_condition_usages.start_date <
2761: nvl(ame_condition_usages.end_date, ame_condition_usages.start_date + ame_util.oneSecond)))
2762: and ame_condition_usages.condition_id = ame_conditions.condition_id
2763: and ame_conditions.condition_type <> ame_util.listModConditionType
2764: and l_effective_date between ame_conditions.start_date
2765: and nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date);
2766: --+

Line 2763: and ame_conditions.condition_type <> ame_util.listModConditionType

2759: (l_effective_date < ame_condition_usages.start_date
2760: and ame_condition_usages.start_date <
2761: nvl(ame_condition_usages.end_date, ame_condition_usages.start_date + ame_util.oneSecond)))
2762: and ame_condition_usages.condition_id = ame_conditions.condition_id
2763: and ame_conditions.condition_type <> ame_util.listModConditionType
2764: and l_effective_date between ame_conditions.start_date
2765: and nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date);
2766: --+
2767: cursor getReqAttributes is

Line 2764: and l_effective_date between ame_conditions.start_date

2760: and ame_condition_usages.start_date <
2761: nvl(ame_condition_usages.end_date, ame_condition_usages.start_date + ame_util.oneSecond)))
2762: and ame_condition_usages.condition_id = ame_conditions.condition_id
2763: and ame_conditions.condition_type <> ame_util.listModConditionType
2764: and l_effective_date between ame_conditions.start_date
2765: and nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date);
2766: --+
2767: cursor getReqAttributes is
2768: select man.attribute_id

Line 2765: and nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date);

2761: nvl(ame_condition_usages.end_date, ame_condition_usages.start_date + ame_util.oneSecond)))
2762: and ame_condition_usages.condition_id = ame_conditions.condition_id
2763: and ame_conditions.condition_type <> ame_util.listModConditionType
2764: and l_effective_date between ame_conditions.start_date
2765: and nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date);
2766: --+
2767: cursor getReqAttributes is
2768: select man.attribute_id
2769: from ame_mandatory_attributes man

Line 3019: from ame_conditions, ame_condition_usages

3015: --+
3016: cursor getConditionCount(p_condition_type in varchar2
3017: ,p_condition_id in integer) is
3018: select count(*)
3019: from ame_conditions, ame_condition_usages
3020: where ame_condition_usages.condition_id <> p_condition_id
3021: and ame_condition_usages.rule_id = p_rule_id
3022: and ( l_effective_date between ame_condition_usages.start_date and
3023: nvl(ame_condition_usages.end_date - ame_util.oneSecond,l_effective_date ) or

Line 3027: and ame_condition_usages.condition_id = ame_conditions.condition_id

3023: nvl(ame_condition_usages.end_date - ame_util.oneSecond,l_effective_date ) or
3024: (l_effective_date < ame_condition_usages.start_date and
3025: ame_condition_usages.start_date <
3026: nvl(ame_condition_usages.end_date,ame_condition_usages.start_date + ame_util.oneSecond)))
3027: and ame_condition_usages.condition_id = ame_conditions.condition_id
3028: and ame_conditions.condition_type = p_condition_type
3029: and l_effective_date between ame_conditions.start_date and
3030: nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date );
3031: --+

Line 3028: and ame_conditions.condition_type = p_condition_type

3024: (l_effective_date < ame_condition_usages.start_date and
3025: ame_condition_usages.start_date <
3026: nvl(ame_condition_usages.end_date,ame_condition_usages.start_date + ame_util.oneSecond)))
3027: and ame_condition_usages.condition_id = ame_conditions.condition_id
3028: and ame_conditions.condition_type = p_condition_type
3029: and l_effective_date between ame_conditions.start_date and
3030: nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date );
3031: --+
3032: cursor getRuleDetails is

Line 3029: and l_effective_date between ame_conditions.start_date and

3025: ame_condition_usages.start_date <
3026: nvl(ame_condition_usages.end_date,ame_condition_usages.start_date + ame_util.oneSecond)))
3027: and ame_condition_usages.condition_id = ame_conditions.condition_id
3028: and ame_conditions.condition_type = p_condition_type
3029: and l_effective_date between ame_conditions.start_date and
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

Line 3030: nvl(ame_conditions.end_date - ame_util.oneSecond,l_effective_date );

3026: nvl(ame_condition_usages.end_date,ame_condition_usages.start_date + ame_util.oneSecond)))
3027: and ame_condition_usages.condition_id = ame_conditions.condition_id
3028: and ame_conditions.condition_type = p_condition_type
3029: and l_effective_date between ame_conditions.start_date and
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

Line 3052: from ame_conditions

3048: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
3049: --+
3050: cursor getConditionType(conditionIdIn in integer) is
3051: select condition_type
3052: from ame_conditions
3053: where condition_id = conditionIdIn
3054: and l_effective_date between start_date
3055: and nvl(end_date - ame_util.oneSecond,l_effective_date);
3056: --+

Line 3067: from ame_conditions

3063: and application_id = p_application_id;
3064: --+
3065: cursor getAttributeId is
3066: select attribute_id
3067: from ame_conditions
3068: where condition_id = p_condition_id
3069: and l_effective_date between start_date and
3070: nvl(end_date - ame_util.oneSecond,l_effective_date ) ;
3071: --+

Line 3077: l_condition_type ame_conditions.condition_type%type;

3073: --+
3074: l_proc varchar2(72) := g_package||'delete_ame_rule_condition ';
3075: l_dummy varchar2(10);
3076: l_swi_package_name varchar2(30) := 'AME_RULE_SWI';
3077: l_condition_type ame_conditions.condition_type%type;
3078: l_atu_object_version_number number;
3079: l_atu_start_date date;
3080: l_atu_end_date date;
3081: l_condition_count number;

Line 3636: l_condition_type ame_conditions.condition_type%type;

3632: l_proc varchar2(72) := g_package||'replace_lm_condition';
3633: l_dummy varchar2(10);
3634: l_swi_package_name varchar2(30) := 'AME_RULE_SWI';
3635: l_effective_date date;
3636: l_condition_type ame_conditions.condition_type%type;
3637: l_attribute_id number;
3638: --+
3639: cursor getConditionDetails is
3640: select condition_type

Line 3642: from ame_conditions

3638: --+
3639: cursor getConditionDetails is
3640: select condition_type
3641: ,attribute_id
3642: from ame_conditions
3643: where condition_id = p_condition_id
3644: and l_effective_date between start_date
3645: and nvl(end_date - ame_util.oneSecond,l_effective_date);
3646: --+

Line 3764: ,ame_conditions cnd

3760: --+
3761: select cnu.condition_id
3762: into l_old_condition_id
3763: from ame_condition_usages cnu
3764: ,ame_conditions cnd
3765: where cnu.rule_id = p_rule_id
3766: and cnu.condition_id = cnd.condition_id
3767: and cnd.condition_type = ame_util.listModConditionType
3768: and sysdate between cnd.start_date and nvl(cnd.end_date - (1/86400),sysdate)