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

Line 20: -- type is ame_util.numberAttributeType

16: -- {Start Of Comments}
17: --
18: -- Description:
19: -- Validates that the approver_type_id field can only be populated if attribute
20: -- type is ame_util.numberAttributeType
21: -- Validates that the approver_type_id if not null, is a foreign key to
22: -- ame_approver_types.approver_type_id.
23: --
24: -- Prerequisites:

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

58: from ame_approver_types
59: where
60: approver_type_id = p_approver_type_id and
61: p_effective_date between start_date and
62: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
63: l_exists varchar2(1);
64: begin
65: if p_approver_type_id is not null then
66: if p_attribute_type = ame_util.numberAttributeType then

Line 66: if p_attribute_type = ame_util.numberAttributeType then

62: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
63: l_exists varchar2(1);
64: begin
65: if p_approver_type_id is not null then
66: if p_attribute_type = ame_util.numberAttributeType then
67: open c_sel1;
68: fetch c_sel1 into l_exists;
69: if c_sel1%notfound then
70: close c_sel1;

Line 98: -- ame_util.booleanAttributeType

94: -- {Start Of Comments}
95: --
96: -- Description:
97: -- Validates that the attribute type is one of the following:
98: -- ame_util.booleanAttributeType
99: -- ame_util.currencyAttributeType
100: -- ame_util.dateAttributeType
101: -- ame_util.numberAttributeType
102: -- ame_util.stringAttributeType

Line 99: -- ame_util.currencyAttributeType

95: --
96: -- Description:
97: -- Validates that the attribute type is one of the following:
98: -- ame_util.booleanAttributeType
99: -- ame_util.currencyAttributeType
100: -- ame_util.dateAttributeType
101: -- ame_util.numberAttributeType
102: -- ame_util.stringAttributeType
103: --

Line 100: -- ame_util.dateAttributeType

96: -- Description:
97: -- Validates that the attribute type is one of the following:
98: -- ame_util.booleanAttributeType
99: -- ame_util.currencyAttributeType
100: -- ame_util.dateAttributeType
101: -- ame_util.numberAttributeType
102: -- ame_util.stringAttributeType
103: --
104: -- Prerequisites:

Line 101: -- ame_util.numberAttributeType

97: -- Validates that the attribute type is one of the following:
98: -- ame_util.booleanAttributeType
99: -- ame_util.currencyAttributeType
100: -- ame_util.dateAttributeType
101: -- ame_util.numberAttributeType
102: -- ame_util.stringAttributeType
103: --
104: -- Prerequisites:
105: -- None.

Line 102: -- ame_util.stringAttributeType

98: -- ame_util.booleanAttributeType
99: -- ame_util.currencyAttributeType
100: -- ame_util.dateAttributeType
101: -- ame_util.numberAttributeType
102: -- ame_util.stringAttributeType
103: --
104: -- Prerequisites:
105: -- None.
106: --

Line 132: if not (p_attribute_type = ame_util.booleanAttributeType or

128: p_object_version_number in number,
129: p_attribute_type in ame_attributes.attribute_type%type) is
130: l_proc varchar2(72) := g_package||'chk_attribute_type';
131: begin
132: if not (p_attribute_type = ame_util.booleanAttributeType or
133: p_attribute_type = ame_util.currencyAttributeType or
134: p_attribute_type = ame_util.dateAttributeType or
135: p_attribute_type = ame_util.numberAttributeType or
136: p_attribute_type = ame_util.stringAttributeType) then

Line 133: p_attribute_type = ame_util.currencyAttributeType or

129: p_attribute_type in ame_attributes.attribute_type%type) is
130: l_proc varchar2(72) := g_package||'chk_attribute_type';
131: begin
132: if not (p_attribute_type = ame_util.booleanAttributeType or
133: p_attribute_type = ame_util.currencyAttributeType or
134: p_attribute_type = ame_util.dateAttributeType or
135: p_attribute_type = ame_util.numberAttributeType or
136: p_attribute_type = ame_util.stringAttributeType) then
137: fnd_message.set_name('PER','AME_400471_INV_ATTRIBUTE_TYPE');

Line 134: p_attribute_type = ame_util.dateAttributeType or

130: l_proc varchar2(72) := g_package||'chk_attribute_type';
131: begin
132: if not (p_attribute_type = ame_util.booleanAttributeType or
133: p_attribute_type = ame_util.currencyAttributeType or
134: p_attribute_type = ame_util.dateAttributeType or
135: p_attribute_type = ame_util.numberAttributeType or
136: p_attribute_type = ame_util.stringAttributeType) then
137: fnd_message.set_name('PER','AME_400471_INV_ATTRIBUTE_TYPE');
138: fnd_message.raise_error;

Line 135: p_attribute_type = ame_util.numberAttributeType or

131: begin
132: if not (p_attribute_type = ame_util.booleanAttributeType or
133: p_attribute_type = ame_util.currencyAttributeType or
134: p_attribute_type = ame_util.dateAttributeType or
135: p_attribute_type = ame_util.numberAttributeType or
136: p_attribute_type = ame_util.stringAttributeType) then
137: fnd_message.set_name('PER','AME_400471_INV_ATTRIBUTE_TYPE');
138: fnd_message.raise_error;
139: end if;

Line 136: p_attribute_type = ame_util.stringAttributeType) then

132: if not (p_attribute_type = ame_util.booleanAttributeType or
133: p_attribute_type = ame_util.currencyAttributeType or
134: p_attribute_type = ame_util.dateAttributeType or
135: p_attribute_type = ame_util.numberAttributeType or
136: p_attribute_type = ame_util.stringAttributeType) then
137: fnd_message.set_name('PER','AME_400471_INV_ATTRIBUTE_TYPE');
138: fnd_message.raise_error;
139: end if;
140: exception

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

191: from ame_item_classes
192: where
193: item_class_id = p_item_class_id and
194: p_effective_date between start_date and
195: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
196: l_exists varchar2(1);
197: begin
198: open c_sel1;
199: fetch c_sel1 into l_exists;

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

256: from ame_attributes
257: where
258: trim(upper(name)) = trim(upper(p_name)) and
259: p_effective_date between start_date and
260: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
261: begin
262: hr_api.mandatory_arg_error
263: (p_api_name => l_proc
264: ,p_argument => 'name'

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

326: from ame_attribute_usages
327: where
328: attribute_id = p_attribute_id and
329: p_effective_date between start_date and
330: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
331: cursor c_sel2 is
332: select null
333: from ame_mandatory_attributes
334: where

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

333: from ame_mandatory_attributes
334: where
335: attribute_id = p_attribute_id and
336: p_effective_date between start_date and
337: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
338: l_exists varchar2(1);
339: begin
340: open c_sel1;
341: fetch c_sel1 into l_exists;

Line 380: nvl(end_date - ame_util.oneSecond, p_start_date) ;

376: select count(*)
377: from ame_attribute_usages
378: where attribute_id = p_attribute_id and
379: p_start_date between start_date and
380: nvl(end_date - ame_util.oneSecond, p_start_date) ;
381: --
382: Cursor C_Sel2 is
383: select count(*)
384: from ame_mandatory_attributes

Line 387: nvl(end_date - ame_util.oneSecond, p_start_date) ;

383: select count(*)
384: from ame_mandatory_attributes
385: where attribute_id = p_attribute_id
386: and p_start_date between start_date and
387: nvl(end_date - ame_util.oneSecond, p_start_date) ;
388: --
389: --
390: Cursor C_Sel3 is
391: select count(*)

Line 395: nvl(end_date - ame_util.oneSecond, p_start_date) ;

391: select count(*)
392: from ame_conditions
393: where attribute_id = p_attribute_id
394: and p_start_date between start_date and
395: nvl(end_date - ame_util.oneSecond, p_start_date) ;
396: --
397: l_child_count integer;
398: --
399: --

Line 521: if ame_utility_pkg.check_seeddb() = 'N' then

517: );
518: end if;
519: --Added an extra if condition so that no error is thrown when the description for a seeded attribute is modified
520: --using AME Developer responsibility.
521: if ame_utility_pkg.check_seeddb() = 'N' then
522: if nvl(ame_util.seededDataCreatedById,hr_api.g_number) =
523: nvl(ame_utility_pkg.is_seed_user(ame_atr_shd.g_old_rec.created_by),hr_api.g_number) and
524: nvl(p_rec.description,hr_api.g_varchar2) <>
525: nvl(ame_atr_shd.g_old_rec.description,hr_api.g_varchar2)

Line 522: if nvl(ame_util.seededDataCreatedById,hr_api.g_number) =

518: end if;
519: --Added an extra if condition so that no error is thrown when the description for a seeded attribute is modified
520: --using AME Developer responsibility.
521: if ame_utility_pkg.check_seeddb() = 'N' then
522: if nvl(ame_util.seededDataCreatedById,hr_api.g_number) =
523: nvl(ame_utility_pkg.is_seed_user(ame_atr_shd.g_old_rec.created_by),hr_api.g_number) and
524: nvl(p_rec.description,hr_api.g_varchar2) <>
525: nvl(ame_atr_shd.g_old_rec.description,hr_api.g_varchar2)
526: then

Line 523: nvl(ame_utility_pkg.is_seed_user(ame_atr_shd.g_old_rec.created_by),hr_api.g_number) and

519: --Added an extra if condition so that no error is thrown when the description for a seeded attribute is modified
520: --using AME Developer responsibility.
521: if ame_utility_pkg.check_seeddb() = 'N' then
522: if nvl(ame_util.seededDataCreatedById,hr_api.g_number) =
523: nvl(ame_utility_pkg.is_seed_user(ame_atr_shd.g_old_rec.created_by),hr_api.g_number) and
524: nvl(p_rec.description,hr_api.g_varchar2) <>
525: nvl(ame_atr_shd.g_old_rec.description,hr_api.g_varchar2)
526: then
527: hr_api.argument_changed_error