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_ACF_BUS dependencies on AME_UTIL

Line 107: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

103: from ame_action_types
104: where
105: action_type_id = p_action_type_id and
106: p_effective_date between start_date and
107: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
108: l_exists varchar2(1);
109: begin
110: open c_sel1;
111: fetch c_sel1 into l_exists;

Line 173: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

169: from ame_calling_apps
170: where
171: application_id = p_application_id and
172: p_effective_date between start_date and
173: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
174: l_exists varchar2(1);
175: begin
176: open c_sel1;
177: fetch c_sel1 into l_exists;

Line 204: -- ame_util.consensusVoting;

200: -- {Start Of Comments}
201: --
202: -- Description:
203: -- Validates that the voting regime is one of the following:
204: -- ame_util.consensusVoting;
205: -- ame_util.firstApproverVoting;
206: -- ame_util.serializedVoting;
207: --
208: -- Prerequisites:

Line 205: -- ame_util.firstApproverVoting;

201: --
202: -- Description:
203: -- Validates that the voting regime is one of the following:
204: -- ame_util.consensusVoting;
205: -- ame_util.firstApproverVoting;
206: -- ame_util.serializedVoting;
207: --
208: -- Prerequisites:
209: -- None.

Line 206: -- ame_util.serializedVoting;

202: -- Description:
203: -- Validates that the voting regime is one of the following:
204: -- ame_util.consensusVoting;
205: -- ame_util.firstApproverVoting;
206: -- ame_util.serializedVoting;
207: --
208: -- Prerequisites:
209: -- None.
210: --

Line 264: -- ame_util.consensusVoting;

260: -- {Start Of Comments}
261: --
262: -- Description:
263: -- Validates that the voting regime is one of the following:
264: -- ame_util.consensusVoting;
265: -- ame_util.firstApproverVoting;
266: -- ame_util.serializedVoting;
267: --
268: -- Prerequisites:

Line 265: -- ame_util.firstApproverVoting;

261: --
262: -- Description:
263: -- Validates that the voting regime is one of the following:
264: -- ame_util.consensusVoting;
265: -- ame_util.firstApproverVoting;
266: -- ame_util.serializedVoting;
267: --
268: -- Prerequisites:
269: -- None.

Line 266: -- ame_util.serializedVoting;

262: -- Description:
263: -- Validates that the voting regime is one of the following:
264: -- ame_util.consensusVoting;
265: -- ame_util.firstApproverVoting;
266: -- ame_util.serializedVoting;
267: --
268: -- Prerequisites:
269: -- None.
270: --

Line 304: p_voting_regime not in (ame_util.consensusVoting,

300: AND ROWNUM < 2;
301: --chain of authority(rule_type = 1) needs voting regime(not null)
302: if ( l_rule_type = 1 AND
303: ( p_voting_regime IS NULL OR
304: p_voting_regime not in (ame_util.consensusVoting,
305: ame_util.firstApproverVoting,
306: ame_util.serializedVoting)
307: )
308: )then

Line 305: ame_util.firstApproverVoting,

301: --chain of authority(rule_type = 1) needs voting regime(not null)
302: if ( l_rule_type = 1 AND
303: ( p_voting_regime IS NULL OR
304: p_voting_regime not in (ame_util.consensusVoting,
305: ame_util.firstApproverVoting,
306: ame_util.serializedVoting)
307: )
308: )then
309: -- AT MESSAGE

Line 306: ame_util.serializedVoting)

302: if ( l_rule_type = 1 AND
303: ( p_voting_regime IS NULL OR
304: p_voting_regime not in (ame_util.consensusVoting,
305: ame_util.firstApproverVoting,
306: ame_util.serializedVoting)
307: )
308: )then
309: -- AT MESSAGE
310: -- The voting regime specified is invalid

Line 332: -- ame_util.parallelChainsMode;

328: -- {Start Of Comments}
329: --
330: -- Description:
331: -- Validates that the chain ordering mode is one of the following:
332: -- ame_util.parallelChainsMode;
333: -- ame_util.serialChainsMode;
334: --
335: -- Prerequisites:
336: -- None.

Line 333: -- ame_util.serialChainsMode;

329: --
330: -- Description:
331: -- Validates that the chain ordering mode is one of the following:
332: -- ame_util.parallelChainsMode;
333: -- ame_util.serialChainsMode;
334: --
335: -- Prerequisites:
336: -- None.
337: --

Line 371: p_chain_ordering_mode not in (ame_util.parallelChainsMode,

367: AND ROWNUM < 2;
368: --chain of authority(rule_type = 1) requires non null chain ordering mode
369: IF ( l_rule_type =1 AND
370: (p_chain_ordering_mode IS NULL OR
371: p_chain_ordering_mode not in (ame_util.parallelChainsMode,
372: ame_util.serialChainsMode)
373: )
374: )then
375: -- AT MESSAGE

Line 372: ame_util.serialChainsMode)

368: --chain of authority(rule_type = 1) requires non null chain ordering mode
369: IF ( l_rule_type =1 AND
370: (p_chain_ordering_mode IS NULL OR
371: p_chain_ordering_mode not in (ame_util.parallelChainsMode,
372: ame_util.serialChainsMode)
373: )
374: )then
375: -- AT MESSAGE
376: -- The chain ordering mode specified is invalid

Line 439: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

435: from ame_action_type_config
436: where
437: application_id = p_application_id and
438: p_effective_date between start_date and
439: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
440: if(p_order_number not between 1 and max_order_number) then
441: -- AT MESSAGE
442: -- The order number specified is invalid
443: fnd_message.set_name('PAY','HR_7200_INVALID_ORD_NUM');

Line 519: where ame_utility_pkg.is_seed_user(acf.created_by) = ame_util.seededDataCreatedById

515:
516: cursor c_sel2 is
517: select null
518: from ame_action_type_config acf
519: where ame_utility_pkg.is_seed_user(acf.created_by) = ame_util.seededDataCreatedById
520: and ame_utility_pkg.check_seeddb = 'N'
521: and acf.action_type_id = p_action_type_id
522: and acf.application_id = p_application_id
523: and sysdate between acf.start_date and

Line 520: and ame_utility_pkg.check_seeddb = 'N'

516: cursor c_sel2 is
517: select null
518: from ame_action_type_config acf
519: where ame_utility_pkg.is_seed_user(acf.created_by) = ame_util.seededDataCreatedById
520: and ame_utility_pkg.check_seeddb = 'N'
521: and acf.action_type_id = p_action_type_id
522: and acf.application_id = p_application_id
523: and sysdate between acf.start_date and
524: nvl(acf.end_date - (1/86400), sysdate);