APPS.AME_RLU_BUS dependencies on AME_UTIL

Line 18: -- ame_util.approvalApproverCategory

14: -- {Start Of Comments}
15: --
16: -- Description:
17: -- Check that approver category is one of the valid values:
18: -- ame_util.approvalApproverCategory
19: -- ame_util.fyiApproverCategory
20: --
21: -- Prerequisites:
22: -- None.

Line 19: -- ame_util.fyiApproverCategory

15: --
16: -- Description:
17: -- Check that approver category is one of the valid values:
18: -- ame_util.approvalApproverCategory
19: -- ame_util.fyiApproverCategory
20: --
21: -- Prerequisites:
22: -- None.
23: --

Line 47: if not (p_approver_category = ame_util.approvalApproverCategory or

43: (p_approver_category in varchar2,
44: p_effective_date in date) is
45: l_proc varchar2(72) := g_package||'chk_approver_category';
46: begin
47: if not (p_approver_category = ame_util.approvalApproverCategory or
48: p_approver_category = ame_util.fyiApproverCategory) then
49: fnd_message.set_name('PER','AME_400481_INV_APP_CAT');
50: fnd_message.raise_error;
51: end if;

Line 48: p_approver_category = ame_util.fyiApproverCategory) then

44: p_effective_date in date) is
45: l_proc varchar2(72) := g_package||'chk_approver_category';
46: begin
47: if not (p_approver_category = ame_util.approvalApproverCategory or
48: p_approver_category = ame_util.fyiApproverCategory) then
49: fnd_message.set_name('PER','AME_400481_INV_APP_CAT');
50: fnd_message.raise_error;
51: end if;
52: exception

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

99: from ame_calling_apps
100: where
101: application_id = p_item_id and
102: p_effective_date between start_date and
103: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
104: l_exists varchar2(1);
105: begin
106: open c_sel1;
107: fetch c_sel1 into l_exists;

Line 213: nvl(end_date - ame_util.oneSecond, p_effective_date)) or

209: from ame_rules
210: where
211: rule_id = p_rule_id and
212: ((p_effective_date between start_date and
213: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
214: (p_effective_date < start_date and
215: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
216: l_exists varchar2(1);
217: begin

Line 215: start_date < nvl(end_date,start_date + ame_util.oneSecond)));

211: rule_id = p_rule_id and
212: ((p_effective_date between start_date and
213: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
214: (p_effective_date < start_date and
215: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
216: l_exists varchar2(1);
217: begin
218: open c_sel1;
219: fetch c_sel1 into l_exists;