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_ATTRIBUTE_USAGES_API dependencies on AME_MANDATORY_ATTRIBUTES

Line 33: from AME_MANDATORY_ATTRIBUTES

29: begin
30: NEW_USE_COUNT := 0;
31: select COUNT(*)
32: into MANDATORY_COUNT
33: from AME_MANDATORY_ATTRIBUTES
34: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
35: and ACTION_TYPE_ID = ame_util.mandAttActionTypeId
36: and SYSDATE between START_DATE
37: and nvl(END_DATE - (1/86400), sysdate);

Line 64: from AME_MANDATORY_ATTRIBUTES,

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,
66: AME_ACTION_USAGES
67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =

Line 67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID

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
71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID

Line 68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =

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
71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID
72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE

Line 72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE

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)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE

Line 73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)

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)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))

Line 85: from AME_MANDATORY_ATTRIBUTES,

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,
87: AME_RULES
88: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =

Line 88: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID

84: into TEMP_COUNT
85: from AME_MANDATORY_ATTRIBUTES,
86: AME_ACTIONS,
87: AME_RULES
88: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
90: AME_ACTIONS.ACTION_TYPE_ID
91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID
92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID

Line 89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =

85: from AME_MANDATORY_ATTRIBUTES,
86: AME_ACTIONS,
87: AME_RULES
88: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
90: AME_ACTIONS.ACTION_TYPE_ID
91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID
92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID
93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE

Line 93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE

89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
90: AME_ACTIONS.ACTION_TYPE_ID
91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID
92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID
93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
94: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
95: and sysdate between AME_ACTIONS.START_DATE
96: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
97: and ((sysdate between AME_RULES.START_DATE

Line 94: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)

90: AME_ACTIONS.ACTION_TYPE_ID
91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID
92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID
93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
94: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
95: and sysdate between AME_ACTIONS.START_DATE
96: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
97: and ((sysdate between AME_RULES.START_DATE
98: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))