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

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

42: select null
43: from ame_calling_apps
44: where application_id = p_application_id
45: and p_effective_date between start_date
46: and nvl(end_date - ame_util.oneSecond, p_effective_date);
47: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_ID';
48: l_dummy varchar2(1);
49: --
50: Begin

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

109: select null
110: from ame_item_classes
111: where item_class_id = p_item_class_id
112: and p_effective_date between start_date
113: and nvl(end_date - ame_util.oneSecond, p_effective_date);
114: l_proc varchar2(72) := g_package || 'CHK_ITEM_CLASS_ID';
115: l_dummy varchar2(1);
116: --
117: Begin

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

179: from ame_item_class_usages
180: where item_class_id = p_item_class_id
181: and application_id = p_application_id
182: and p_effective_date between start_date
183: and nvl(end_date - ame_util.oneSecond, p_effective_date);
184: l_proc varchar2(72) := g_package || 'CHK_ITEM_CLASS_USAGE';
185: l_dummy varchar2(1);
186: --
187: Begin

Line 301: l_upper_trans_id_placeholder ame_util.stringType;

297: l_upper_item_id_query ame_item_class_usages.item_id_query%type;
298: l_trans_id_placeholder_pos integer;
299: l_trans_id_placeholder_pos2 integer;
300: l_temp_count integer;
301: l_upper_trans_id_placeholder ame_util.stringType;
302: l_query_validation varchar2(1000);
303: --
304: Begin
305: hr_utility.set_location(' Entering:'||l_proc,10);

Line 323: l_upper_trans_id_placeholder := upper(ame_util.transactionIdPlaceholder);

319: -- Check for any other place holder columns other than place holder
320: -- column for transaction ID
321: l_temp_count := 1;
322: l_upper_item_id_query := upper(p_item_id_query);
323: l_upper_trans_id_placeholder := upper(ame_util.transactionIdPlaceholder);
324: loop
325: l_trans_id_placeholder_pos :=
326: instrb(l_upper_item_id_query, l_upper_trans_id_placeholder, 1, l_temp_count);
327: if(l_trans_id_placeholder_pos = 0) then

Line 331: instrb(p_item_id_query, ame_util.transactionIdPlaceholder, 1, l_temp_count);

327: if(l_trans_id_placeholder_pos = 0) then
328: exit;
329: end if;
330: l_trans_id_placeholder_pos2 :=
331: instrb(p_item_id_query, ame_util.transactionIdPlaceholder, 1, l_temp_count);
332: if(l_trans_id_placeholder_pos <> l_trans_id_placeholder_pos2) then
333: fnd_message.set_name('PER','AME_400377_ADM_IC_QUERY2');
334: fnd_message.raise_error;
335: end if;

Line 338: select ame_utility_pkg.validate_query(p_item_id_query,'1',ame_util2.itemClassObject)

334: fnd_message.raise_error;
335: end if;
336: l_temp_count := l_temp_count + 1;
337: end loop;
338: select ame_utility_pkg.validate_query(p_item_id_query,'1',ame_util2.itemClassObject)
339: into l_query_validation
340: from dual;
341: if l_query_validation <> 'Y' then
342: fnd_message.raise_error;

Line 365: -- ame_util.serialItems and ame_util.parallelItems for item_class_par_mode

361: -- {Start Of Comments}
362: --
363: -- Description:
364: -- This procedure ensures that no other value is entered other than
365: -- ame_util.serialItems and ame_util.parallelItems for item_class_par_mode
366: --
367: -- Pre-Requisites:
368: -- chk_application_id and chk_item_class_id must have been validated
369: --

Line 396: p_item_class_par_mode not in (ame_util.serialItems,

392: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
393: hr_multi_message.no_all_inclusive_error
394: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
395: if nvl(p_item_class_par_mode, hr_api.g_varchar2) <> hr_api.g_varchar2 and
396: p_item_class_par_mode not in (ame_util.serialItems,
397: ame_util.parallelItems
398: ) then
399: fnd_message.set_name('PER','AME_400766_INV_PARAM_MODE');
400: fnd_message.raise_error;

Line 397: ame_util.parallelItems

393: hr_multi_message.no_all_inclusive_error
394: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
395: if nvl(p_item_class_par_mode, hr_api.g_varchar2) <> hr_api.g_varchar2 and
396: p_item_class_par_mode not in (ame_util.serialItems,
397: ame_util.parallelItems
398: ) then
399: fnd_message.set_name('PER','AME_400766_INV_PARAM_MODE');
400: fnd_message.raise_error;
401: end if;

Line 421: -- ame_util.serialSublists, ame_util.parallelSublists, ame_util.preFirst

417: -- {Start Of Comments}
418: --
419: -- Description:
420: -- This procedure ensures that no other value is entered other than
421: -- ame_util.serialSublists, ame_util.parallelSublists, ame_util.preFirst
422: -- and ame_util.preAndAuthorityFirst for item_class_sublist_mode
423: --
424: -- Pre-Requisites:
425: -- chk_application_id and chk_item_class_id must have been validated

Line 422: -- and ame_util.preAndAuthorityFirst for item_class_sublist_mode

418: --
419: -- Description:
420: -- This procedure ensures that no other value is entered other than
421: -- ame_util.serialSublists, ame_util.parallelSublists, ame_util.preFirst
422: -- and ame_util.preAndAuthorityFirst for item_class_sublist_mode
423: --
424: -- Pre-Requisites:
425: -- chk_application_id and chk_item_class_id must have been validated
426: --

Line 454: p_item_class_sublist_mode not in (ame_util.serialSublists

450: hr_multi_message.no_all_inclusive_error
451: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
452: if nvl(p_item_class_sublist_mode, hr_api.g_varchar2) <>
453: hr_api.g_varchar2 and
454: p_item_class_sublist_mode not in (ame_util.serialSublists
455: ,ame_util.parallelSublists
456: ,ame_util.preFirst
457: ,ame_util.preAndAuthorityFirst
458: ) then

Line 455: ,ame_util.parallelSublists

451: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
452: if nvl(p_item_class_sublist_mode, hr_api.g_varchar2) <>
453: hr_api.g_varchar2 and
454: p_item_class_sublist_mode not in (ame_util.serialSublists
455: ,ame_util.parallelSublists
456: ,ame_util.preFirst
457: ,ame_util.preAndAuthorityFirst
458: ) then
459: fnd_message.set_name('PER','AME_400767_INV_SUBLIST_MODE');

Line 456: ,ame_util.preFirst

452: if nvl(p_item_class_sublist_mode, hr_api.g_varchar2) <>
453: hr_api.g_varchar2 and
454: p_item_class_sublist_mode not in (ame_util.serialSublists
455: ,ame_util.parallelSublists
456: ,ame_util.preFirst
457: ,ame_util.preAndAuthorityFirst
458: ) then
459: fnd_message.set_name('PER','AME_400767_INV_SUBLIST_MODE');
460: fnd_message.raise_error;

Line 457: ,ame_util.preAndAuthorityFirst

453: hr_api.g_varchar2 and
454: p_item_class_sublist_mode not in (ame_util.serialSublists
455: ,ame_util.parallelSublists
456: ,ame_util.preFirst
457: ,ame_util.preAndAuthorityFirst
458: ) then
459: fnd_message.set_name('PER','AME_400767_INV_SUBLIST_MODE');
460: fnd_message.raise_error;
461: end if;

Line 592: ame_utility_pkg.check_seeddb = 'N' and

588: cursor c_sel1 Is
589: select null
590: from ame_item_class_usages
591: where
592: ame_utility_pkg.check_seeddb = 'N' and
593: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
594: item_class_id = p_item_class_id and
595: application_id = p_application_id ;
596: l_exists varchar2(1);

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

589: select null
590: from ame_item_class_usages
591: where
592: ame_utility_pkg.check_seeddb = 'N' and
593: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
594: item_class_id = p_item_class_id and
595: application_id = p_application_id ;
596: l_exists varchar2(1);
597: begin