APPS.AME_ATTRIBUTE_USAGES_API dependencies on AME_RULE_USAGES

Line 11: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID

7: X_APPLICATION_ID ame_attribute_usages.application_id%type)
8: return integer as
9: cursor RULE_CURSOR
10: (X_APPLICATION_ID ame_attribute_usages.application_id%type) is
11: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
12: from AME_RULES, AME_RULE_USAGES
13: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
14: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
15: and ((sysdate between AME_RULES.START_DATE

Line 12: from AME_RULES, AME_RULE_USAGES

8: return integer as
9: cursor RULE_CURSOR
10: (X_APPLICATION_ID ame_attribute_usages.application_id%type) is
11: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
12: from AME_RULES, AME_RULE_USAGES
13: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
14: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
15: and ((sysdate between AME_RULES.START_DATE
16: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))

Line 13: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID

9: cursor RULE_CURSOR
10: (X_APPLICATION_ID ame_attribute_usages.application_id%type) is
11: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
12: from AME_RULES, AME_RULE_USAGES
13: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
14: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
15: and ((sysdate between AME_RULES.START_DATE
16: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
17: or (sysdate < AME_RULES.START_DATE

Line 14: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID

10: (X_APPLICATION_ID ame_attribute_usages.application_id%type) is
11: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
12: from AME_RULES, AME_RULE_USAGES
13: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
14: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
15: and ((sysdate between AME_RULES.START_DATE
16: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
17: or (sysdate < AME_RULES.START_DATE
18: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,

Line 20: and ((sysdate between AME_RULE_USAGES.START_DATE

16: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
17: or (sysdate < AME_RULES.START_DATE
18: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
19: AME_RULES.START_DATE + (1/86400))))
20: and ((sysdate between AME_RULE_USAGES.START_DATE
21: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
22: or (sysdate < AME_RULE_USAGES.START_DATE
23: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
24: AME_RULE_USAGES.START_DATE + (1/86400))));

Line 21: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))

17: or (sysdate < AME_RULES.START_DATE
18: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
19: AME_RULES.START_DATE + (1/86400))))
20: and ((sysdate between AME_RULE_USAGES.START_DATE
21: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
22: or (sysdate < AME_RULE_USAGES.START_DATE
23: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
24: AME_RULE_USAGES.START_DATE + (1/86400))));
25: MANDATORY_COUNT integer;

Line 22: or (sysdate < AME_RULE_USAGES.START_DATE

18: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
19: AME_RULES.START_DATE + (1/86400))))
20: and ((sysdate between AME_RULE_USAGES.START_DATE
21: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
22: or (sysdate < AME_RULE_USAGES.START_DATE
23: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
24: AME_RULE_USAGES.START_DATE + (1/86400))));
25: MANDATORY_COUNT integer;
26: NEW_USE_COUNT integer;

Line 23: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,

19: AME_RULES.START_DATE + (1/86400))))
20: and ((sysdate between AME_RULE_USAGES.START_DATE
21: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
22: or (sysdate < AME_RULE_USAGES.START_DATE
23: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
24: AME_RULE_USAGES.START_DATE + (1/86400))));
25: MANDATORY_COUNT integer;
26: NEW_USE_COUNT integer;
27: RULE_COUNT integer;

Line 24: AME_RULE_USAGES.START_DATE + (1/86400))));

20: and ((sysdate between AME_RULE_USAGES.START_DATE
21: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
22: or (sysdate < AME_RULE_USAGES.START_DATE
23: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
24: AME_RULE_USAGES.START_DATE + (1/86400))));
25: MANDATORY_COUNT integer;
26: NEW_USE_COUNT integer;
27: RULE_COUNT integer;
28: TEMP_COUNT integer;