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

Line 67: where ame_utility_pkg.check_seeddb = 'N'

63: l_count number;
64: cursor c_sel1 is
65: select null
66: from ame_approval_groups
67: where ame_utility_pkg.check_seeddb = 'N'
68: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
69: and approval_group_id = p_approval_group_id
70: and p_effective_date between start_date and
71: nvl(end_date -(1/86400), p_effective_date);

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

64: cursor c_sel1 is
65: select null
66: from ame_approval_groups
67: where ame_utility_pkg.check_seeddb = 'N'
68: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
69: and approval_group_id = p_approval_group_id
70: and p_effective_date between start_date and
71: nvl(end_date -(1/86400), p_effective_date);
72: begin

Line 263: upperTransIdPlaceholder := upper(ame_util.transactionIdPlaceholder);

259: fnd_message.raise_error;
260: end if;
261: tempInt := 1;
262: queryString := upper(p_query_string);
263: upperTransIdPlaceholder := upper(ame_util.transactionIdPlaceholder);
264: loop
265: transIdPlaceholderPosition :=
266: instrb(queryString, upperTransIdPlaceholder, 1, tempInt);
267: if(transIdPlaceholderPosition = 0) then

Line 271: instrb(p_query_string, ame_util.transactionIdPlaceholder, 1, tempInt);

267: if(transIdPlaceholderPosition = 0) then
268: exit;
269: end if;
270: transIdPlaceholderPosition2 :=
271: instrb(p_query_string, ame_util.transactionIdPlaceholder, 1, tempInt);
272: if(transIdPlaceholderPosition <> transIdPlaceholderPosition2) then
273: fnd_message.set_name('PER','AME_400635_APG_QRY_STR_BND_VAR');
274: fnd_message.raise_error;
275: end if;

Line 278: /*if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_groups',

274: fnd_message.raise_error;
275: end if;
276: tempInt := tempInt + 1;
277: end loop;
278: /*if(ame_util.isArgumentTooLong(tableNameIn => 'ame_approval_groups',
279: columnNameIn => 'query_string',
280: argumentIn => p_query_string)) then
281: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');
282: fnd_message.raise_error;

Line 285: ame_util.checkForSqlInjection(queryStringIn => queryString);

281: fnd_message.set_name('PER','AME_400163_ATT_USAGE_LONG');
282: fnd_message.raise_error;
283: end if;*/
284: /* The following utility handles the error. So nothing needs to be done here */
285: ame_util.checkForSqlInjection(queryStringIn => queryString);
286: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string
287: ,p_columns => 1
288: ,p_object => ame_util2.approverGroupObject
289: );

Line 286: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string

282: fnd_message.raise_error;
283: end if;*/
284: /* The following utility handles the error. So nothing needs to be done here */
285: ame_util.checkForSqlInjection(queryStringIn => queryString);
286: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string
287: ,p_columns => 1
288: ,p_object => ame_util2.approverGroupObject
289: );
290: if l_valid <> 'Y' then

Line 288: ,p_object => ame_util2.approverGroupObject

284: /* The following utility handles the error. So nothing needs to be done here */
285: ame_util.checkForSqlInjection(queryStringIn => queryString);
286: l_valid := ame_utility_pkg.validate_query(p_query_string => p_query_string
287: ,p_columns => 1
288: ,p_object => ame_util2.approverGroupObject
289: );
290: if l_valid <> 'Y' then
291: fnd_message.raise_error;
292: end if;

Line 378: --if l_created_by = ame_util.seededDataCreatedById and

374: --close C_Sel1;
375: --
376: -- NAME is non-updateable if the group is seeded
377:
378: --if l_created_by = ame_util.seededDataCreatedById and
379: if nvl(p_rec.name, hr_api.g_varchar2) <>
380: nvl(ame_apg_shd.g_old_rec.name,hr_api.g_varchar2)then
381: hr_api.argument_changed_error
382: (p_api_name => l_proc

Line 390: -- if l_created_by = ame_util.seededDataCreatedById and

386: end if;
387: --
388: -- DESCRIPTION is non-updateable if the group is seeded
389:
390: -- if l_created_by = ame_util.seededDataCreatedById and
391: -- nvl(p_rec.description, hr_api.g_varchar2) <>
392: -- nvl(ame_apg_shd.g_old_rec.description,hr_api.g_varchar2)then
393: -- hr_api.argument_changed_error
394: -- (p_api_name => l_proc

Line 402: --if l_created_by = ame_util.seededDataCreatedById and

398: --end if;
399: --
400: -- IS_STATIC is non-updateable if the group is seeded
401:
402: --if l_created_by = ame_util.seededDataCreatedById and
403: -- nvl(p_rec.is_static, hr_api.g_varchar2) <>
404: -- nvl(ame_apg_shd.g_old_rec.is_static,hr_api.g_varchar2)then
405: -- hr_api.argument_changed_error
406: -- (p_api_name => l_proc

Line 414: -- if l_created_by = ame_util.seededDataCreatedById and

410: --end if;
411: --
412: -- QUERY_STRING is non-updateable if the group is seeded
413:
414: -- if l_created_by = ame_util.seededDataCreatedById and
415: -- nvl(p_rec.query_string, hr_api.g_varchar2) <>
416: -- nvl(ame_apg_shd.g_old_rec.query_string,hr_api.g_varchar2)then
417: -- hr_api.argument_changed_error
418: -- (p_api_name => l_proc