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

Line 70: select ame_utility_pkg.is_seed_user(created_by)

66: fnd_message.raise_error;
67: END IF;
68: -- EDIT_HERE: Add checks to ensure non-updateable args have
69: -- not been updated.
70: select ame_utility_pkg.is_seed_user(created_by)
71: into createdBy
72: from ame_action_types
73: where
74: action_type_id = p_rec.action_type_id and

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

72: from ame_action_types
73: where
74: action_type_id = p_rec.action_type_id and
75: p_effective_date between start_date and
76: nvl(end_date - ame_util.oneSecond, p_effective_date);
77: IF createdBy = ame_util.seededDataCreatedById
78: and ame_utility_pkg.check_seeddb = 'N' then
79: IF
80: nvl(p_rec.name,

Line 77: IF createdBy = ame_util.seededDataCreatedById

73: where
74: action_type_id = p_rec.action_type_id and
75: p_effective_date between start_date and
76: nvl(end_date - ame_util.oneSecond, p_effective_date);
77: IF createdBy = ame_util.seededDataCreatedById
78: and ame_utility_pkg.check_seeddb = 'N' then
79: IF
80: nvl(p_rec.name,
81: hr_api.g_number) <>

Line 78: and ame_utility_pkg.check_seeddb = 'N' then

74: action_type_id = p_rec.action_type_id and
75: p_effective_date between start_date and
76: nvl(end_date - ame_util.oneSecond, p_effective_date);
77: IF createdBy = ame_util.seededDataCreatedById
78: and ame_utility_pkg.check_seeddb = 'N' then
79: IF
80: nvl(p_rec.name,
81: hr_api.g_number) <>
82: nvl(ame_aty_shd.g_old_rec.name,

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

155: from ame_action_types
156: where
157: name = p_name and
158: p_effective_date between start_date and
159: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
160: l_exists varchar2(1);
161: begin
162: hr_api.mandatory_arg_error
163: (p_api_name => l_proc

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

272: from ame_action_types
273: where
274: procedure_name = p_procedure_name and
275: p_effective_date between start_date and
276: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
277: l_exists varchar2(1);
278: begin
279: hr_api.mandatory_arg_error
280: (p_api_name => l_proc

Line 314: -- ame_util.booleanTrue

310: -- {Start Of Comments}
311: --
312: -- Description:
313: -- Validates that the dynamic description is one of the following:
314: -- ame_util.booleanTrue
315: -- ame_util.booleanFalse
316: --
317: -- Prerequisites:
318: -- None.

Line 315: -- ame_util.booleanFalse

311: --
312: -- Description:
313: -- Validates that the dynamic description is one of the following:
314: -- ame_util.booleanTrue
315: -- ame_util.booleanFalse
316: --
317: -- Prerequisites:
318: -- None.
319: --

Line 338: (p_dynamic_description in ame_util.charType) is

334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: procedure chk_dynamic_description
338: (p_dynamic_description in ame_util.charType) is
339: l_proc varchar2(72) := g_package||'chk_dynamic_description';
340: begin
341: if p_dynamic_description not in (ame_util.booleanTrue,
342: ame_util.booleanFalse) then

Line 341: if p_dynamic_description not in (ame_util.booleanTrue,

337: procedure chk_dynamic_description
338: (p_dynamic_description in ame_util.charType) is
339: l_proc varchar2(72) := g_package||'chk_dynamic_description';
340: begin
341: if p_dynamic_description not in (ame_util.booleanTrue,
342: ame_util.booleanFalse) then
343: -- AT MESSAGE
344: -- The dynamic description specified is invalid
345: fnd_message.set_name('PAY','HR_7777_INVALID_PRIMARY_KEY');

Line 342: ame_util.booleanFalse) then

338: (p_dynamic_description in ame_util.charType) is
339: l_proc varchar2(72) := g_package||'chk_dynamic_description';
340: begin
341: if p_dynamic_description not in (ame_util.booleanTrue,
342: ame_util.booleanFalse) then
343: -- AT MESSAGE
344: -- The dynamic description specified is invalid
345: fnd_message.set_name('PAY','HR_7777_INVALID_PRIMARY_KEY');
346: fnd_message.raise_error;

Line 392: p_description_query in ame_util.charType) is

388: -- {End Of Comments}
389: -- ----------------------------------------------------------------------------
390: procedure chk_description_query
391: (p_dynamic_description in varchar2,
392: p_description_query in ame_util.charType) is
393: l_proc varchar2(72) := g_package||'chk_description_query';
394: l_valid varchar2(1000);
395: begin
396: IF(p_dynamic_description = ame_util.booleanTrue) then

Line 396: IF(p_dynamic_description = ame_util.booleanTrue) then

392: p_description_query in ame_util.charType) is
393: l_proc varchar2(72) := g_package||'chk_description_query';
394: l_valid varchar2(1000);
395: begin
396: IF(p_dynamic_description = ame_util.booleanTrue) then
397: hr_api.mandatory_arg_error
398: (p_api_name => l_proc,
399: p_argument => 'description_query',
400: p_argument_value => p_description_query);

Line 409: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then

405: fnd_message.set_name('PER','AME_400372_ACT_DYNAMIC_DESC2');
406: fnd_message.raise_error;
407: END IF;
408: /* Verify that the description query includes at least one of the bind variables */
409: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
410: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
411: fnd_message.set_name('PER', 'AME_400370_ACT_DYNAMIC_DESC');
412: fnd_message.raise_error;
413: END IF;

Line 410: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then

406: fnd_message.raise_error;
407: END IF;
408: /* Verify that the description query includes at least one of the bind variables */
409: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
410: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
411: fnd_message.set_name('PER', 'AME_400370_ACT_DYNAMIC_DESC');
412: fnd_message.raise_error;
413: END IF;
414: END IF;

Line 416: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then

412: fnd_message.raise_error;
413: END IF;
414: END IF;
415: IF(instrb(p_description_query, ':', 1, 1) > 0) then
416: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
417: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
418: fnd_message.set_name('PER', 'AME_400371_ACT_INV_BIND_VAR');
419: fnd_message.raise_error;
420: END IF;

Line 417: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then

413: END IF;
414: END IF;
415: IF(instrb(p_description_query, ':', 1, 1) > 0) then
416: IF(instrb(p_description_query, ame_util.actionParameterOne, 1, 1) = 0) then
417: IF(instrb(p_description_query, ame_util.actionParameterTwo, 1, 1) = 0) then
418: fnd_message.set_name('PER', 'AME_400371_ACT_INV_BIND_VAR');
419: fnd_message.raise_error;
420: END IF;
421: END IF;

Line 423: ame_util.checkForSqlInjection(queryStringIn => upper(p_description_query));

419: fnd_message.raise_error;
420: END IF;
421: END IF;
422: END IF;
423: ame_util.checkForSqlInjection(queryStringIn => upper(p_description_query));
424: l_valid := ame_utility_pkg.validate_query(p_query_string => p_description_query
425: ,p_columns => 1
426: ,p_object => ame_util2.actionTypeObject
427: );

Line 424: l_valid := ame_utility_pkg.validate_query(p_query_string => p_description_query

420: END IF;
421: END IF;
422: END IF;
423: ame_util.checkForSqlInjection(queryStringIn => upper(p_description_query));
424: l_valid := ame_utility_pkg.validate_query(p_query_string => p_description_query
425: ,p_columns => 1
426: ,p_object => ame_util2.actionTypeObject
427: );
428: if l_valid <> 'Y' then

Line 426: ,p_object => ame_util2.actionTypeObject

422: END IF;
423: ame_util.checkForSqlInjection(queryStringIn => upper(p_description_query));
424: l_valid := ame_utility_pkg.validate_query(p_query_string => p_description_query
425: ,p_columns => 1
426: ,p_object => ame_util2.actionTypeObject
427: );
428: if l_valid <> 'Y' then
429: fnd_message.raise_error;
430: end if;

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

489: from ame_action_type_usages
490: where
491: action_type_id = p_action_type_id and
492: p_effective_date between start_date and
493: nvl(end_date - ame_util.oneSecond, p_effective_date);
494: cursor c_sel2 is
495: select null
496: from ame_action_type_config
497: where

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

496: from ame_action_type_config
497: where
498: action_type_id = p_action_type_id and
499: p_effective_date between start_date and
500: nvl(end_date - ame_util.oneSecond, p_effective_date);
501: cursor c_sel3 is
502: select null
503: from ame_approver_type_usages
504: where

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

503: from ame_approver_type_usages
504: where
505: action_type_id = p_action_type_id and
506: p_effective_date between start_date and
507: nvl(end_date - ame_util.oneSecond, p_effective_date);
508: cursor c_sel4 is
509: select null
510: from ame_mandatory_attributes
511: where

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

510: from ame_mandatory_attributes
511: where
512: action_type_id = p_action_type_id and
513: p_effective_date between start_date and
514: nvl(end_date - ame_util.oneSecond, p_effective_date);
515: cursor c_sel5 Is
516: select null
517: from ame_action_types
518: where

Line 520: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and

516: select null
517: from ame_action_types
518: where
519: action_type_id = p_action_type_id and
520: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
521: ame_utility_pkg.check_seeddb = 'N';
522: cursor c_sel6 Is
523: select null
524: from ame_actions

Line 521: ame_utility_pkg.check_seeddb = 'N';

517: from ame_action_types
518: where
519: action_type_id = p_action_type_id and
520: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
521: ame_utility_pkg.check_seeddb = 'N';
522: cursor c_sel6 Is
523: select null
524: from ame_actions
525: where

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

524: from ame_actions
525: where
526: action_type_id = p_action_type_id and
527: p_effective_date between start_date and
528: nvl(end_date - ame_util.oneSecond, p_effective_date);
529: l_exists varchar2(1);
530: begin
531: open c_sel1;
532: fetch c_sel1 into l_exists;