APPS.AME_RULE_API dependencies on AME_ACTION_USAGES

Line 128: from ame_actions, ame_action_usages

124: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
125: --+
126: cursor getActionTypeCursor is
127: select ame_actions.action_type_id
128: from ame_actions, ame_action_usages
129: where ame_action_usages.rule_id = p_rule_id
130: and ame_action_usages.action_id = ame_actions.action_id
131: and (p_effective_date between ame_action_usages.start_date
132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)

Line 129: where ame_action_usages.rule_id = p_rule_id

125: --+
126: cursor getActionTypeCursor is
127: select ame_actions.action_type_id
128: from ame_actions, ame_action_usages
129: where ame_action_usages.rule_id = p_rule_id
130: and ame_action_usages.action_id = ame_actions.action_id
131: and (p_effective_date between ame_action_usages.start_date
132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)
133: or

Line 130: and ame_action_usages.action_id = ame_actions.action_id

126: cursor getActionTypeCursor is
127: select ame_actions.action_type_id
128: from ame_actions, ame_action_usages
129: where ame_action_usages.rule_id = p_rule_id
130: and ame_action_usages.action_id = ame_actions.action_id
131: and (p_effective_date between ame_action_usages.start_date
132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)
133: or
134: (p_effective_date < ame_action_usages.start_date

Line 131: and (p_effective_date between ame_action_usages.start_date

127: select ame_actions.action_type_id
128: from ame_actions, ame_action_usages
129: where ame_action_usages.rule_id = p_rule_id
130: and ame_action_usages.action_id = ame_actions.action_id
131: and (p_effective_date between ame_action_usages.start_date
132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)
133: or
134: (p_effective_date < ame_action_usages.start_date
135: and ame_action_usages.start_date < nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)))

Line 132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)

128: from ame_actions, ame_action_usages
129: where ame_action_usages.rule_id = p_rule_id
130: and ame_action_usages.action_id = ame_actions.action_id
131: and (p_effective_date between ame_action_usages.start_date
132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)
133: or
134: (p_effective_date < ame_action_usages.start_date
135: and ame_action_usages.start_date < nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)))
136: and p_effective_date between ame_actions.start_date

Line 134: (p_effective_date < ame_action_usages.start_date

130: and ame_action_usages.action_id = ame_actions.action_id
131: and (p_effective_date between ame_action_usages.start_date
132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)
133: or
134: (p_effective_date < ame_action_usages.start_date
135: and ame_action_usages.start_date < nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)))
136: and p_effective_date between ame_actions.start_date
137: and nvl(ame_actions.end_date - ame_util.oneSecond, p_effective_date) ;
138: begin

Line 135: and ame_action_usages.start_date < nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)))

131: and (p_effective_date between ame_action_usages.start_date
132: and nvl(ame_action_usages.end_date - ame_util.oneSecond, p_effective_date)
133: or
134: (p_effective_date < ame_action_usages.start_date
135: and ame_action_usages.start_date < nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)))
136: and p_effective_date between ame_actions.start_date
137: and nvl(ame_actions.end_date - ame_util.oneSecond, p_effective_date) ;
138: begin
139: -- Check the value of the config variable 'allowAllApproverTypes' and 'productionFunctionality'

Line 344: select ame_action_usages.action_id

340: --+
341: procedure getActionIds(ruleIdIn in integer,
342: actionIdListOut out nocopy ame_util.idList) as
343: cursor actionCursor(ruleIdIn in integer) is
344: select ame_action_usages.action_id
345: from ame_action_usages
346: where rule_id = ruleIdIn
347: and ((sysdate between ame_action_usages.start_date
348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))

Line 345: from ame_action_usages

341: procedure getActionIds(ruleIdIn in integer,
342: actionIdListOut out nocopy ame_util.idList) as
343: cursor actionCursor(ruleIdIn in integer) is
344: select ame_action_usages.action_id
345: from ame_action_usages
346: where rule_id = ruleIdIn
347: and ((sysdate between ame_action_usages.start_date
348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))
349: or

Line 347: and ((sysdate between ame_action_usages.start_date

343: cursor actionCursor(ruleIdIn in integer) is
344: select ame_action_usages.action_id
345: from ame_action_usages
346: where rule_id = ruleIdIn
347: and ((sysdate between ame_action_usages.start_date
348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))
349: or
350: (sysdate < ame_action_usages.start_date
351: and ame_action_usages.start_date <

Line 348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))

344: select ame_action_usages.action_id
345: from ame_action_usages
346: where rule_id = ruleIdIn
347: and ((sysdate between ame_action_usages.start_date
348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))
349: or
350: (sysdate < ame_action_usages.start_date
351: and ame_action_usages.start_date <
352: nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)));

Line 350: (sysdate < ame_action_usages.start_date

346: where rule_id = ruleIdIn
347: and ((sysdate between ame_action_usages.start_date
348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))
349: or
350: (sysdate < ame_action_usages.start_date
351: and ame_action_usages.start_date <
352: nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)));
353: actionId integer;
354: tempIndex integer;

Line 351: and ame_action_usages.start_date <

347: and ((sysdate between ame_action_usages.start_date
348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))
349: or
350: (sysdate < ame_action_usages.start_date
351: and ame_action_usages.start_date <
352: nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)));
353: actionId integer;
354: tempIndex integer;
355: begin

Line 352: nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)));

348: and nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate))
349: or
350: (sysdate < ame_action_usages.start_date
351: and ame_action_usages.start_date <
352: nvl(ame_action_usages.end_date, ame_action_usages.start_date + ame_util.oneSecond)));
353: actionId integer;
354: tempIndex integer;
355: begin
356: tempIndex := 1;

Line 935: ,ame_action_usages acu

931: --+
932: cursor getReqAttributes is
933: select man.attribute_id
934: from ame_mandatory_attributes man
935: ,ame_action_usages acu
936: ,ame_actions act
937: where man.action_type_id = act.action_type_id
938: and acu.action_id = act.action_id
939: and acu.rule_id = p_rule_id

Line 952: from ame_action_usages

948: select action_id
949: ,start_date
950: ,end_date
951: ,object_version_number
952: from ame_action_usages
953: where rule_id = p_rule_id
954: and (l_effective_date between start_date
955: and nvl(end_date - ame_util.oneSecond,l_effective_date)
956: or

Line 1864: ,ame_action_usages acu

1860: cursor getReqAttributeIds(actionIdIn in integer
1861: ,ruleIdIn in integer) is
1862: select man.attribute_id
1863: from ame_mandatory_attributes man
1864: ,ame_action_usages acu
1865: ,ame_actions act
1866: where man.action_type_id = act.action_type_id
1867: and acu.action_id = act.action_id
1868: and acu.action_id = actionIdIn

Line 2110: -- insert the row in ame_action_usages

2106: l_acu_start_date := l_rul_start_date;
2107: end if;
2108: l_acu_end_date := l_rul_end_date;
2109: --
2110: -- insert the row in ame_action_usages
2111: --
2112: ame_acu_ins.ins(p_rule_id => p_rule_id
2113: ,p_action_id => p_action_id
2114: ,p_effective_date => l_effective_date

Line 2424: from ame_action_usages

2420: select action_id
2421: ,start_date
2422: ,end_date
2423: ,object_version_number
2424: from ame_action_usages
2425: where rule_id = p_rule_id
2426: and ((l_effective_date between start_date
2427: and nvl(end_date - ame_util.oneSecond, l_effective_date))
2428: or

Line 2720: from ame_action_usages

2716: l_usage_count number;
2717: --+
2718: cursor getActions is
2719: select action_id, start_date, end_date, object_version_number
2720: from ame_action_usages
2721: where rule_id = p_rule_id
2722: and ( l_effective_date between start_date and
2723: nvl(end_date - ame_util.oneSecond,l_effective_date ) or
2724: (l_effective_date < start_date and

Line 2770: ,ame_action_usages acu

2766: --+
2767: cursor getReqAttributes is
2768: select man.attribute_id
2769: from ame_mandatory_attributes man
2770: ,ame_action_usages acu
2771: ,ame_actions act
2772: where man.action_type_id = act.action_type_id
2773: and acu.action_id = act.action_id
2774: and acu.rule_id = p_rule_id

Line 3363: from ame_action_usages acu

3359: l_effective_date date;
3360: --+
3361: cursor getActionCount is
3362: select count(*)
3363: from ame_action_usages acu
3364: where rule_id = p_rule_id
3365: and ((l_effective_date between start_date and nvl(end_date - ame_util.oneSecond, l_effective_date))
3366: or
3367: (l_effective_date < start_date and start_date < nvl(end_date,start_date + ame_util.oneSecond)))

Line 3527: -- delete the row in ame_action_usages

3523: if l_swi_call and p_effective_date is not null then
3524: l_effective_date := p_effective_date;
3525: end if;
3526: --+
3527: -- delete the row in ame_action_usages
3528: --+
3529: ame_acu_del.del(p_effective_date => l_effective_date
3530: ,p_datetrack_mode => hr_api.g_delete
3531: ,p_rule_id => p_rule_id