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_TYPES

Line 76: ame_action_types

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
80: ame_action_type_config.application_id = p_ame_application_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 79: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

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
83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

Line 84: sysdate between ame_action_types.start_date 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
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);

Line 85: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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
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

Line 109: ame_action_types

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
113: ame_action_type_config.application_id = p_ame_application_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 112: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

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
116: sysdate between ame_action_type_config.start_date and

Line 118: sysdate between ame_action_types.start_date 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
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

Line 119: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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
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);

Line 143: ame_action_types.object_version_number

139: p_rule_type in number) is
140: select ame_action_type_config.action_type_id,
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

Line 146: ame_action_types

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
150: ame_action_type_config.application_id = p_ame_application_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 149: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

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
153: sysdate between ame_action_type_config.start_date and

Line 155: sysdate between ame_action_types.start_date 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
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;

Line 156: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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
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';

Line 216: ame_action_types.object_version_number

212: p_rule_type in number) is
213: select ame_action_type_config.action_type_id,
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

Line 219: ame_action_types

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
223: ame_action_type_config.application_id = p_ame_application_id and

Line 221: ame_action_type_config.action_type_id = ame_action_types.action_type_id and

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
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

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 229: sysdate between ame_action_types.start_date 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
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;

Line 230: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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
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';

Line 357: -- insert the row in ame_action_types.

353: ,p_hook_type => 'BP'
354: );
355: end;
356: --
357: -- insert the row in ame_action_types.
358: ame_aty_ins.ins(p_effective_date => l_effective_date,
359: p_name => p_name,
360: p_procedure_name => p_procedure_name,
361: p_description => p_description,

Line 1090: from ame_action_types

1086: ) is
1087: --cursors
1088: cursor C_Sel1 is
1089: select name
1090: from ame_action_types
1091: where action_type_id = p_action_type_id
1092: and sysdate between start_date and
1093: nvl(end_date - (1/86400), sysdate);
1094: cursor C_Sel2 is

Line 1113: l_action_type_name ame_action_types.name%TYPE;

1109: l_start_date date;
1110: l_end_date date;
1111: l_language_code fnd_languages.language_code%TYPE;
1112: l_description ame_actions.description%TYPE;
1113: l_action_type_name ame_action_types.name%TYPE;
1114: l_approver varchar2(100);
1115: --
1116: begin
1117: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1526: from ame_action_types

1522: --
1523: --cursors
1524: cursor C_Sel1 is
1525: select name
1526: from ame_action_types
1527: where action_type_id = p_action_type_id
1528: and sysdate between start_date and
1529: nvl(end_date - (1/86400), sysdate);
1530: cursor C_Sel2 is

Line 1548: l_action_type_name ame_action_types.name%TYPE;

1544: l_start_date date;
1545: l_end_date date;
1546: l_language_code fnd_languages.language_code%TYPE;
1547: l_description ame_actions.description%TYPE;
1548: l_action_type_name ame_action_types.name%TYPE;
1549: l_approver varchar2(100);
1550: --
1551: begin
1552: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1733: ,ame_action_types actionTypes

1729: p_effective_date in date) is
1730: select count(*)
1731: from ame_action_usages ruleUsages
1732: ,ame_actions actions
1733: ,ame_action_types actionTypes
1734: where ruleUsages.action_id = actions.action_id
1735: and actions.action_type_id = actionTypes.action_type_id
1736: and actionTypes.action_type_id = p_action_type_id
1737: and p_effective_date