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_CONFIG

Line 16: from ame_action_type_config

12: begin
13: hr_utility.set_location('Entering:'|| l_proc, 10);
14: select order_number
15: into l_order_number
16: from ame_action_type_config
17: where
18: action_type_id = p_action_type_id and
19: application_id = p_ame_application_id and
20: sysdate between start_date and

Line 74: from ame_action_type_config,

70: hr_utility.set_location('Entering:'|| l_proc, 10);
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

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

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
84: sysdate between ame_action_types.start_date and

Line 82: sysdate between ame_action_type_config.start_date and

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
86: sysdate between ame_action_type_usages.start_date and

Line 83: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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
86: sysdate between ame_action_type_usages.start_date and
87: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

Line 107: from ame_action_type_config,

103: hr_utility.set_location('Entering:'|| l_proc, 10);
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

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

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

Line 114: ame_action_type_config.order_number = p_order_number and

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
117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
118: sysdate between ame_action_types.start_date and

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

Line 117: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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
120: sysdate between ame_action_type_usages.start_date and
121: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

Line 140: select ame_action_type_config.action_type_id,

136: p_order_number in number) as
137: cursor c_sel1(p_ame_application_id in number,
138: p_order_number in 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,

Line 141: ame_action_type_config.order_number,

137: cursor c_sel1(p_ame_application_id in number,
138: p_order_number in 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,

Line 142: ame_action_type_config.object_version_number,

138: p_order_number in 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

Line 144: from ame_action_type_config,

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
148: ame_action_types.action_type_id = ame_action_type_usages.action_type_id 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 150: ame_action_type_config.application_id = p_ame_application_id and

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

Line 151: ame_action_type_config.order_number > p_order_number and

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
154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
155: sysdate between ame_action_types.start_date and

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

Line 154: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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
157: sysdate between ame_action_type_usages.start_date and
158: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

Line 213: select ame_action_type_config.action_type_id,

209: cursor c_sel1(p_ame_application_id in number,
210: p_action_type_id in number,
211: p_order_number in 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,

Line 214: ame_action_type_config.order_number,

210: p_action_type_id in number,
211: p_order_number in 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,

Line 215: ame_action_type_config.object_version_number,

211: p_order_number in 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

Line 217: from ame_action_type_config,

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

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

Line 224: ame_action_type_config.action_type_id <> p_action_type_id and

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

Line 225: ame_action_type_config.order_number >= p_order_number and

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

Line 227: sysdate between ame_action_type_config.start_date 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
231: sysdate between ame_action_type_usages.start_date and

Line 228: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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
231: sysdate between ame_action_type_usages.start_date and
232: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

Line 413: create_ame_action_type_config(p_validate => p_validate,

409: p_object_version_number => l_axu_object_version_number,
410: p_start_date => l_axu_start_date,
411: p_end_date => l_axu_end_date);
412: /*
413: create_ame_action_type_config(p_validate => p_validate,
414: p_action_type_id => l_action_type_id,
415: p_application_id => p_application_id,
416: p_rule_type => p_rule_type,
417: p_object_version_number => l_acf_object_version_number,

Line 759: l_proc varchar2(72) := g_package||'create_ame_action_type_config';

755: ,p_start_date out nocopy date
756: ,p_end_date out nocopy date
757: ) is
758: -- local variables
759: l_proc varchar2(72) := g_package||'create_ame_action_type_config';
760: l_effective_date date;
761: l_object_version_number number;
762: l_start_date date;
763: l_end_date date;

Line 772: savepoint create_ame_action_type_config;

768: -- Set the effective date to the sysdate
769: l_effective_date := sysdate;
770: -- Issue a savepoint.
771: --
772: savepoint create_ame_action_type_config;
773: -- Call DBMS_UTILITY.FORMAT_CALL_STACK to check if the call has been
774: -- made from the 'AME_ACTION_SWI' package.
775: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_ACTION_SWI') <> 0) then
776: -- insert the row in ame_action_type_config with default voting regime

Line 776: -- insert the row in ame_action_type_config with default voting regime

772: savepoint create_ame_action_type_config;
773: -- Call DBMS_UTILITY.FORMAT_CALL_STACK to check if the call has been
774: -- made from the 'AME_ACTION_SWI' package.
775: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,'AME_ACTION_SWI') <> 0) then
776: -- insert the row in ame_action_type_config with default voting regime
777: -- and default chain ordering mode.
778: /* l_voting_regime := ame_util.serializedVoting;
779: l_chain_ordering_mode := ame_util.serialChainsMode;
780: */

Line 891: ROLLBACK TO create_ame_action_type_config;

887: --
888: -- As the Validate_Enabled exception has been raised
889: -- we must rollback to the savepoint
890: --
891: ROLLBACK TO create_ame_action_type_config;
892: --
893: -- Only set output warning arguments
894: -- (Any key or derived arguments must be set to null
895: -- when validation only mode is being used.)

Line 912: ROLLBACK TO create_ame_action_type_config;

908: p_start_date := null;
909: p_end_date := null;
910: --
911: hr_utility.set_location(' Leaving:'||l_proc, 70);
912: ROLLBACK TO create_ame_action_type_config;
913: raise;
914: --
915: end create_ame_action_type_conf;
916: --

Line 932: from ame_action_type_config axu

928: ) is
929: --cursors
930: cursor C_Sel1 is
931: select axu.application_id
932: from ame_action_type_config axu
933: where axu.action_type_id = p_action_type_id
934: and sysdate between axu.start_date
935: and nvl(axu.end_date - (1/86400), sysdate)
936: and not exists(select null

Line 1715: from ame_action_type_config

1711: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
1712: cursor action_type_conf_cur(p_action_type_id in number,
1713: p_effective_date in date) is
1714: select count(*)
1715: from ame_action_type_config
1716: where
1717: action_type_id = p_action_type_id
1718: and p_effective_date
1719: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);