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

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

49: cursor csr_atr_type is
50: select attribute_type
51: from ame_attributes
52: where p_effective_date between start_date
53: and nvl(end_date - ame_util.oneSecond, p_effective_date)
54: and attribute_id in (select attribute_id
55: from ame_conditions
56: where condition_id = p_condition_id
57: and p_effective_date between start_date and

Line 58: nvl(end_date - ame_util.oneSecond,

54: and attribute_id in (select attribute_id
55: from ame_conditions
56: where condition_id = p_condition_id
57: and p_effective_date between start_date and
58: nvl(end_date - ame_util.oneSecond,
59: p_effective_date)
60: );
61: l_func varchar2(72) := g_package||'is_string_condition';
62: l_atr_type varchar2(20);

Line 75: if(csr_atr_type%found and l_atr_type = ame_util.stringAttributeType) then

71: fnd_message.raise_error;
72: else
73: open csr_atr_type;
74: fetch csr_atr_type into l_atr_type;
75: if(csr_atr_type%found and l_atr_type = ame_util.stringAttributeType) then
76: l_return_value := true;
77: end if;
78: close csr_atr_type;
79: end if;

Line 464: nvl(end_date - ame_util.oneSecond,sysdate);

460: select string_value, object_version_number
461: from ame_string_values
462: where condition_id = p_condition_id
463: and sysdate between start_date and
464: nvl(end_date - ame_util.oneSecond,sysdate);
465: cursor csr_rules(p_chk_condition_id number) is
466: select null
467: from ame_rules,
468: ame_rule_usages,

Line 474: nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))

470: where ame_rules.rule_id = ame_condition_usages.rule_id
471: and ame_rules.rule_id = ame_rule_usages.rule_id
472: and ame_condition_usages.condition_id = p_chk_condition_id
473: and ((sysdate between ame_rules.start_date and
474: nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))
475: or
476: (sysdate < ame_rules.start_date and
477: ame_rules.start_date < nvl(ame_rules.end_date,
478: ame_rules.start_date + ame_util.oneSecond)))

Line 478: ame_rules.start_date + ame_util.oneSecond)))

474: nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))
475: or
476: (sysdate < ame_rules.start_date and
477: ame_rules.start_date < nvl(ame_rules.end_date,
478: ame_rules.start_date + ame_util.oneSecond)))
479: and ((sysdate between ame_rule_usages.start_date and
480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and

Line 480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))

476: (sysdate < ame_rules.start_date and
477: ame_rules.start_date < nvl(ame_rules.end_date,
478: ame_rules.start_date + ame_util.oneSecond)))
479: and ((sysdate between ame_rule_usages.start_date and
480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
484: ame_rule_usages.start_date + ame_util.oneSecond)))

Line 484: ame_rule_usages.start_date + ame_util.oneSecond)))

480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
484: ame_rule_usages.start_date + ame_util.oneSecond)))
485: and ((sysdate between ame_condition_usages.start_date and
486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))
487: or
488: (sysdate < ame_condition_usages.start_date and

Line 486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))

482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
484: ame_rule_usages.start_date + ame_util.oneSecond)))
485: and ((sysdate between ame_condition_usages.start_date and
486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))
487: or
488: (sysdate < ame_condition_usages.start_date and
489: ame_condition_usages.start_date <
490: nvl(ame_condition_usages.end_date,

Line 491: ame_condition_usages.start_date + ame_util.oneSecond)));

487: or
488: (sysdate < ame_condition_usages.start_date and
489: ame_condition_usages.start_date <
490: nvl(ame_condition_usages.end_date,
491: ame_condition_usages.start_date + ame_util.oneSecond)));
492: --
493: l_proc varchar2(72) := g_package||'delete_ame_condition';
494: l_object_version_number number;
495: l_start_date date;

Line 499: l_string_value_tab ame_util.longestStringList;

495: l_start_date date;
496: l_end_date date;
497: l_isStringCondition boolean;
498: l_key varchar2(1);
499: l_string_value_tab ame_util.longestStringList;
500: l_object_version_number_tab ame_util.idList;
501: --
502: begin
503: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 500: l_object_version_number_tab ame_util.idList;

496: l_end_date date;
497: l_isStringCondition boolean;
498: l_key varchar2(1);
499: l_string_value_tab ame_util.longestStringList;
500: l_object_version_number_tab ame_util.idList;
501: --
502: begin
503: hr_utility.set_location('Entering:'|| l_proc, 10);
504: --