APPS.AME_ATTRIBUTE_USAGES_API dependencies on AME_ACTION_USAGES

Line 61: -- action_id is already migrated from ame_rules to ame_action_usages

57: if(TEMP_COUNT > 0) then
58: NEW_USE_COUNT := NEW_USE_COUNT + 1;
59: else
60: if TEMPRULE.ACTION_ID is null then
61: -- action_id is already migrated from ame_rules to ame_action_usages
62: select count(*)
63: into TEMP_COUNT
64: from AME_MANDATORY_ATTRIBUTES,
65: AME_ACTIONS,

Line 66: AME_ACTION_USAGES

62: select count(*)
63: into TEMP_COUNT
64: from AME_MANDATORY_ATTRIBUTES,
65: AME_ACTIONS,
66: AME_ACTION_USAGES
67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
69: AME_ACTIONS.ACTION_TYPE_ID
70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID

Line 70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID

66: AME_ACTION_USAGES
67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
69: AME_ACTIONS.ACTION_TYPE_ID
70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID
71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID
72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
74: and sysdate between AME_ACTIONS.START_DATE

Line 71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID

67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
69: AME_ACTIONS.ACTION_TYPE_ID
70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID
71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID
72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
74: and sysdate between AME_ACTIONS.START_DATE
75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)

Line 76: and ((sysdate between AME_ACTION_USAGES.START_DATE

72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
74: and sysdate between AME_ACTIONS.START_DATE
75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))
78: or (sysdate < AME_ACTION_USAGES.START_DATE
79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
80: AME_ACTION_USAGES.START_DATE + (1/86400))));

Line 77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))

73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
74: and sysdate between AME_ACTIONS.START_DATE
75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))
78: or (sysdate < AME_ACTION_USAGES.START_DATE
79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
80: AME_ACTION_USAGES.START_DATE + (1/86400))));
81: else

Line 78: or (sysdate < AME_ACTION_USAGES.START_DATE

74: and sysdate between AME_ACTIONS.START_DATE
75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))
78: or (sysdate < AME_ACTION_USAGES.START_DATE
79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
80: AME_ACTION_USAGES.START_DATE + (1/86400))));
81: else
82: -- action_id is yet to be migrated from ame_rules to ame_action_usages

Line 79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,

75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))
78: or (sysdate < AME_ACTION_USAGES.START_DATE
79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
80: AME_ACTION_USAGES.START_DATE + (1/86400))));
81: else
82: -- action_id is yet to be migrated from ame_rules to ame_action_usages
83: select count(*)

Line 80: AME_ACTION_USAGES.START_DATE + (1/86400))));

76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))
78: or (sysdate < AME_ACTION_USAGES.START_DATE
79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
80: AME_ACTION_USAGES.START_DATE + (1/86400))));
81: else
82: -- action_id is yet to be migrated from ame_rules to ame_action_usages
83: select count(*)
84: into TEMP_COUNT

Line 82: -- action_id is yet to be migrated from ame_rules to ame_action_usages

78: or (sysdate < AME_ACTION_USAGES.START_DATE
79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,
80: AME_ACTION_USAGES.START_DATE + (1/86400))));
81: else
82: -- action_id is yet to be migrated from ame_rules to ame_action_usages
83: select count(*)
84: into TEMP_COUNT
85: from AME_MANDATORY_ATTRIBUTES,
86: AME_ACTIONS,