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_RULE_API dependencies on AME_RULE_USAGES

Line 45: from ame_rule_usages

41: cursor ruleUsageCursor is
42: select start_date
43: ,end_date
44: ,priority
45: from ame_rule_usages
46: where rule_id =p_rule_id
47: and item_id = p_application_id
48: and (p_effective_date between start_date
49: and nvl(end_date - ame_util.oneSecond, p_effective_date)

Line 253: from ame_rule_usages

249: ,p_rul_end_date out nocopy date) as
250: begin
251: select min(start_date)
252: into p_rul_start_date
253: from ame_rule_usages
254: where rule_id = p_rule_id
255: and (sysdate between start_date
256: and nvl(end_date - ame_util.oneSecond, sysdate )
257: or

Line 262: from ame_rule_usages

258: (sysdate < start_date
259: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
260: select max(end_date)
261: into p_rul_end_date
262: from ame_rule_usages
263: where rule_id = p_rule_id
264: and (sysdate between start_date
265: and nvl(end_date - ame_util.oneSecond, sysdate )
266: or

Line 1249: -- insert the row in ame_rule_usages

1245: elsif l_overlapping_usage = 3 then
1246: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
1247: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1248: end if;
1249: -- insert the row in ame_rule_usages
1250: if l_rlu_start_date is null then
1251: l_rlu_start_date := l_effective_date;
1252: end if;
1253: if l_rlu_end_date is null then

Line 1455: from ame_rule_usages

1451: (l_effective_date < start_date
1452: and start_date < nvl(end_date,start_date + ame_util.oneSecond)));
1453: cursor getApplications is
1454: select item_id
1455: from ame_rule_usages
1456: where rule_id = p_rule_id
1457: and (l_effective_date between start_date
1458: and nvl(end_date - ame_util.oneSecond,l_effective_date ) or
1459: (l_effective_date < start_date

Line 1478: from ame_rule_usages

1474: where application_id = applicationIdIn
1475: and sysdate between start_date and nvl(end_date - (1/86400), sysdate);
1476: cursor getApplicationIds(p_rule_id in integer) is
1477: select distinct item_id
1478: from ame_rule_usages
1479: where rule_id = p_rule_id
1480: and ((sysdate between start_date and nvl(end_date - (1/86400),sysdate))
1481: or
1482: (sysdate < start_date and start_date < nvl(end_date, start_date + (1/86400)))

Line 1879: from ame_rule_usages

1875: );
1876: --+
1877: cursor getApplications(ruleIdIn in integer)is
1878: select item_id
1879: from ame_rule_usages
1880: where rule_id = ruleIdIn
1881: and (l_effective_date between start_date
1882: and nvl(end_date - ame_util.oneSecond, l_effective_date)
1883: or

Line 1902: from ame_rule_usages

1898: and nvl(end_date - ame_util.oneSecond,l_effective_date);
1899: --+
1900: cursor getApplicationIds(p_rule_id in integer) is
1901: select distinct item_id
1902: from ame_rule_usages
1903: where rule_id = p_rule_id
1904: and ((sysdate between start_date and nvl(end_date - (1/86400),sysdate))
1905: or
1906: (sysdate < start_date and start_date < nvl(end_date, start_date + (1/86400)))

Line 2539: -- update the row in ame_rule_usages. Parent row locking not needed.

2535: --
2536: l_rlu_object_version_number := p_object_version_number;
2537: l_rlu_start_date := p_start_date;
2538: l_rlu_end_date := p_end_date;
2539: -- update the row in ame_rule_usages. Parent row locking not needed.
2540: if l_swi_call and p_effective_date is not null then
2541: l_effective_date := p_effective_date;
2542: end if;
2543: ame_rlu_upd.upd(p_effective_date => l_effective_date

Line 2829: -- delete the row in ame_rule_usages

2825: l_effective_date := sysdate;
2826: l_rlu_object_version_number := p_object_version_number;
2827: l_rlu_start_date := p_start_date;
2828: l_rlu_end_date := p_end_date;
2829: -- delete the row in ame_rule_usages
2830: --
2831: ame_rlu_del.del(p_effective_date => l_effective_date
2832: ,p_datetrack_mode => hr_api.g_delete
2833: ,p_rule_id => p_rule_id

Line 2876: from ame_rule_usages

2872: --
2873: --if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2874: select count(*)
2875: into l_usage_count
2876: from ame_rule_usages
2877: where rule_id = p_rule_id
2878: and ((l_effective_date between start_date
2879: and nvl(end_date - ame_util.oneSecond,l_effective_date))
2880: or

Line 3043: from ame_rule_usages

3039: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
3040: --+
3041: cursor getApplications is
3042: select item_id
3043: from ame_rule_usages
3044: where rule_id = p_rule_id
3045: and ( l_effective_date between start_date and
3046: nvl(end_date - ame_util.oneSecond,l_effective_date ) or
3047: (l_effective_date < start_date and

Line 3392: from ame_rule_usages

3388: and l_effective_date between act.start_date and nvl(act.end_date - ame_util.oneSecond, l_effective_date);
3389: --+
3390: cursor getApplications(ruleIdIn in integer)is
3391: select item_id
3392: from ame_rule_usages
3393: where rule_id = ruleIdIn
3394: and (l_effective_date between start_date
3395: and nvl(end_date - ame_util.oneSecond, l_effective_date)
3396: or

Line 3661: from ame_rule_usages

3657: and start_date < nvl(end_date,start_date + ame_util.oneSecond)));
3658: --+
3659: cursor getApplicationIds(p_rule_id in integer) is
3660: select distinct item_id
3661: from ame_rule_usages
3662: where rule_id = p_rule_id
3663: and ((sysdate between start_date and nvl(end_date - (1/86400),sysdate))
3664: or
3665: (sysdate < start_date and start_date < nvl(end_date, start_date + (1/86400)))