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_ACTION_API dependencies on AME_ACTION_TYPE_USAGES

Line 38: from ame_action_type_usages

34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: select count(*)
37: into l_temp_count
38: from ame_action_type_usages
39: where
40: action_type_id = p_action_type_id and
41: sysdate between start_date and
42: nvl(end_date - ame_util.oneSecond, sysdate);

Line 50: from ame_action_type_usages

46: return(ame_util.authorityRuleType);
47: else
48: select rule_type
49: into l_rule_type
50: from ame_action_type_usages
51: where
52: action_type_id = p_action_type_id and
53: sysdate between start_date and
54: nvl(end_date - ame_util.oneSecond, sysdate);

Line 75: ame_action_type_usages,

71: l_rule_type := get_allowed_rule_type(p_action_type_id => p_action_type_id);
72: select max(order_number)
73: into l_order_number
74: from ame_action_type_config,
75: ame_action_type_usages,
76: ame_action_types
77: where
78: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
79: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

Line 78: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and

74: from ame_action_type_config,
75: ame_action_type_usages,
76: ame_action_types
77: where
78: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
79: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
80: ame_action_type_config.application_id = p_ame_application_id and
81: ame_action_type_usages.rule_type = l_rule_type and
82: sysdate between ame_action_type_config.start_date and

Line 81: ame_action_type_usages.rule_type = l_rule_type and

77: where
78: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
79: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
80: ame_action_type_config.application_id = p_ame_application_id and
81: ame_action_type_usages.rule_type = l_rule_type and
82: sysdate between ame_action_type_config.start_date and
83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
84: sysdate between ame_action_types.start_date and
85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 86: sysdate between ame_action_type_usages.start_date and

82: sysdate between ame_action_type_config.start_date and
83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
84: sysdate between ame_action_types.start_date and
85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
86: sysdate between ame_action_type_usages.start_date and
87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
88: return(l_order_number);
89: exception
90: when others then

Line 87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
84: sysdate between ame_action_types.start_date and
85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
86: sysdate between ame_action_type_usages.start_date and
87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
88: return(l_order_number);
89: exception
90: when others then
91: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 108: ame_action_type_usages,

104: l_rule_type := get_allowed_rule_type(p_action_type_id => p_action_type_id);
105: select count(*)
106: into l_temp_count
107: from ame_action_type_config,
108: ame_action_type_usages,
109: ame_action_types
110: where
111: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
112: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

Line 111: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and

107: from ame_action_type_config,
108: ame_action_type_usages,
109: ame_action_types
110: where
111: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
112: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
113: ame_action_type_config.application_id = p_ame_application_id and
114: ame_action_type_config.order_number = p_order_number and
115: ame_action_type_usages.rule_type = l_rule_type and

Line 115: ame_action_type_usages.rule_type = l_rule_type and

111: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
112: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
113: ame_action_type_config.application_id = p_ame_application_id and
114: ame_action_type_config.order_number = p_order_number and
115: ame_action_type_usages.rule_type = l_rule_type and
116: sysdate between ame_action_type_config.start_date and
117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
118: sysdate between ame_action_types.start_date and
119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 120: sysdate between ame_action_type_usages.start_date and

116: sysdate between ame_action_type_config.start_date and
117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
118: sysdate between ame_action_types.start_date and
119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
120: sysdate between ame_action_type_usages.start_date and
121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
122: if(l_temp_count > 1) then
123: return(false);
124: else

Line 121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
118: sysdate between ame_action_types.start_date and
119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
120: sysdate between ame_action_type_usages.start_date and
121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
122: if(l_temp_count > 1) then
123: return(false);
124: else
125: return(true);

Line 145: ame_action_type_usages,

141: ame_action_type_config.order_number,
142: ame_action_type_config.object_version_number,
143: ame_action_types.object_version_number
144: from ame_action_type_config,
145: ame_action_type_usages,
146: ame_action_types
147: where
148: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
149: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

Line 148: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and

144: from ame_action_type_config,
145: ame_action_type_usages,
146: ame_action_types
147: where
148: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
149: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
150: ame_action_type_config.application_id = p_ame_application_id and
151: ame_action_type_config.order_number > p_order_number and
152: ame_action_type_usages.rule_type = p_rule_type and

Line 152: ame_action_type_usages.rule_type = p_rule_type and

148: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
149: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
150: ame_action_type_config.application_id = p_ame_application_id and
151: ame_action_type_config.order_number > p_order_number and
152: ame_action_type_usages.rule_type = p_rule_type and
153: sysdate between ame_action_type_config.start_date and
154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
155: sysdate between ame_action_types.start_date and
156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 157: sysdate between ame_action_type_usages.start_date and

153: sysdate between ame_action_type_config.start_date and
154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
155: sysdate between ame_action_types.start_date and
156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
157: sysdate between ame_action_type_usages.start_date and
158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
159: order by order_number;
160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';
161: l_action_type_ids ame_util.idList;

Line 158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
155: sysdate between ame_action_types.start_date and
156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
157: sysdate between ame_action_type_usages.start_date and
158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
159: order by order_number;
160: l_proc varchar2(72) := g_package||'decrement_action_type_ord_nums';
161: l_action_type_ids ame_util.idList;
162: l_order_numbers ame_util.idList;

Line 218: ame_action_type_usages,

214: ame_action_type_config.order_number,
215: ame_action_type_config.object_version_number,
216: ame_action_types.object_version_number
217: from ame_action_type_config,
218: ame_action_type_usages,
219: ame_action_types
220: where
221: ame_action_type_config.action_type_id = ame_action_types.action_type_id and
222: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and

Line 222: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and

218: ame_action_type_usages,
219: ame_action_types
220: where
221: ame_action_type_config.action_type_id = ame_action_types.action_type_id and
222: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
223: ame_action_type_config.application_id = p_ame_application_id and
224: ame_action_type_config.action_type_id <> p_action_type_id and
225: ame_action_type_config.order_number >= p_order_number and
226: ame_action_type_usages.rule_type = p_rule_type and

Line 226: ame_action_type_usages.rule_type = p_rule_type and

222: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
223: ame_action_type_config.application_id = p_ame_application_id and
224: ame_action_type_config.action_type_id <> p_action_type_id and
225: ame_action_type_config.order_number >= p_order_number and
226: ame_action_type_usages.rule_type = p_rule_type and
227: sysdate between ame_action_type_config.start_date and
228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
229: sysdate between ame_action_types.start_date and
230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 231: sysdate between ame_action_type_usages.start_date and

227: sysdate between ame_action_type_config.start_date and
228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
229: sysdate between ame_action_types.start_date and
230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
231: sysdate between ame_action_type_usages.start_date and
232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
233: order by order_number;
234: l_proc varchar2(72) := g_package||'increment_action_type_ord_nums';
235: l_effective_date date;

Line 232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
229: sysdate between ame_action_types.start_date and
230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
231: sysdate between ame_action_type_usages.start_date and
232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
233: order by order_number;
234: l_proc varchar2(72) := g_package||'increment_action_type_ord_nums';
235: l_effective_date date;
236: l_action_type_ids ame_util.idList;

Line 396: -- insert the row in ame_action_type_usages

392: (p_module_name => 'create_ame_action_type'
393: ,p_hook_type => 'AP'
394: );
395: end;
396: -- insert the row in ame_action_type_usages
397: -- Call DBMS_UTILITY.FORMAT_CALL_STACK to check if the call has been
398: -- made from the 'AME_ACTION_SWI' package.
399: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_ACTION_SWI') = 0) then
400: create_ame_appr_type_usage(p_validate => p_validate,

Line 1707: from ame_action_type_usages

1703:
1704: cursor action_type_usage_cur(p_action_type_id in number,
1705: p_effective_date in date) is
1706: select rule_type, object_version_number
1707: from ame_action_type_usages
1708: where
1709: action_type_id = p_action_type_id
1710: and p_effective_date
1711: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);