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

Line 72: from ame_rule_usages

68: ruleCount integer;
69: begin
70: select count(*)
71: into ruleCount
72: from ame_rule_usages
73: where
74: item_id = applicationIdIn and
75: ((sysdate between start_date and
76: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 203: from ame_rule_usages

199: cursor ruleUsageCursor(ruleIdIn in integer,
200: applicationIdIn in integer,
201: processingDateIn in date) is
202: select start_date, end_date, priority
203: from ame_rule_usages
204: where rule_id = ruleIdIn and
205: item_id = applicationIdIn and
206: ( processingDateIn between start_date and
207: nvl(end_date - ame_util.oneSecond,processingDateIn ) or

Line 407: ame_rule_usages

403: begin
404: select approver_category
405: into approverCategory
406: from
407: ame_rule_usages
408: where
409: rule_id = ruleIdIn and
410: item_id = applicationIdIn and
411: start_date = usageStartDateIn and

Line 559: from ame_rule_usages

555: priority varchar2(20);
556: begin
557: select to_char(priority)
558: into priority
559: from ame_rule_usages
560: where
561: rule_id = ruleIdIn and
562: item_id = applicationIdIn and
563: usageStartDateIn between start_date and

Line 580: itemId ame_rule_usages.item_id%type;

576: raise;
577: return(null);
578: end getPriority;
579: function getItemId(ruleIdIn in integer) return integer as
580: itemId ame_rule_usages.item_id%type;
581: begin
582: select item_id
583: into itemId
584: from ame_rule_usages

Line 584: from ame_rule_usages

580: itemId ame_rule_usages.item_id%type;
581: begin
582: select item_id
583: into itemId
584: from ame_rule_usages
585: where
586: rule_id = ruleIdIn and
587: ((sysdate between start_date and
588: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 784: from ame_rule_usages

780: effectiveDate := sysdate;
781: end if;
782: select end_date
783: into usageEndDate
784: from ame_rule_usages
785: where
786: item_id = applicationIdIn and
787: rule_id = ruleIdIn and
788: effectiveDate between start_date and

Line 818: from ame_rule_usages

814: effectiveDate := sysdate;
815: end if;
816: select start_date
817: into usageStartDate
818: from ame_rule_usages
819: where
820: item_id = applicationIdIn and
821: rule_id = ruleIdIn and
822: effectiveDate between start_date and

Line 843: endDate ame_rule_usages.end_date%type;

839: end getEffectiveStartDateUsage;
840: function getUsageEndDate(ruleIdIn in integer,
841: applicationIdIn in integer,
842: processingDateIn in date) return varchar2 as
843: endDate ame_rule_usages.end_date%type;
844: begin
845: select end_date
846: into endDate
847: from ame_rule_usages

Line 847: from ame_rule_usages

843: endDate ame_rule_usages.end_date%type;
844: begin
845: select end_date
846: into endDate
847: from ame_rule_usages
848: where
849: rule_id = ruleIdIn and
850: item_id = applicationIdIn and
851: creation_date = processingDateIn;

Line 1080: from ame_rule_usages

1076: newStartDate date;
1077: begin
1078: select min(start_date)
1079: into ruleStartDate
1080: from ame_rule_usages
1081: where
1082: rule_id = ruleIdIn and
1083: ((sysdate between start_date and
1084: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 1115: from ame_rule_usages

1111: newEndDate date;
1112: begin
1113: select max(nvl(end_date,to_date('31/12/4712','DD/MM/YYYY')))
1114: into ruleEndDate
1115: from ame_rule_usages
1116: where
1117: rule_id = ruleIdIn and
1118: ((sysdate between start_date and
1119: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 1274: startDate ame_rule_usages.start_date%type;

1270: end getSubItemClassId;
1271: function getUsageStartDate(ruleIdIn in integer,
1272: applicationIdIn in integer,
1273: processingDateIn in date) return varchar2 as
1274: startDate ame_rule_usages.start_date%type;
1275: begin
1276: select start_date
1277: into startDate
1278: from ame_rule_usages

Line 1278: from ame_rule_usages

1274: startDate ame_rule_usages.start_date%type;
1275: begin
1276: select start_date
1277: into startDate
1278: from ame_rule_usages
1279: where
1280: rule_id = ruleIdIn and
1281: item_id = applicationIdIn and
1282: creation_date = processingDateIn;

Line 1625: from ame_rule_usages

1621: useCount integer;
1622: begin
1623: select count(*)
1624: into useCount
1625: from ame_rule_usages
1626: where
1627: rule_id = ruleIdIn and
1628: ((sysdate between start_date and
1629: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 1655: from ame_rule_usages

1651: useCount integer;
1652: begin
1653: select count(*)
1654: into useCount
1655: from ame_rule_usages
1656: where
1657: rule_id = ruleIdIn and
1658: item_id <> applicationIdIn and
1659: ((sysdate between start_date and

Line 2195: from ame_rule_usages

2191: raise invalidDateException;
2192: end if;
2193: select count(*)
2194: into useCount
2195: from ame_rule_usages
2196: where
2197: rule_id = ruleIdIn and
2198: item_id = itemIdIn and
2199: trunc(start_date) = startDateIn and

Line 2211: from ame_rule_usages

2207: end if;
2208: currentUserId := ame_util.getCurrentUserId;
2209: select count(*)
2210: into tempCount
2211: from ame_rule_usages
2212: where
2213: rule_id = ruleIdIn and
2214: item_id = itemIdIn and
2215: created_by = ame_util.seededDataCreatedById;

Line 2234: insert into ame_rule_usages(item_id,

2230: if(categoryIn is null) then
2231: approvalCategory := ame_util.approvalApproverCategory;
2232: end if;
2233: end if;
2234: insert into ame_rule_usages(item_id,
2235: rule_id,
2236: created_by,
2237: creation_date,
2238: last_updated_by,

Line 2585: ame_rule_usages

2581: applicationIdIn in integer,
2582: itemClassIdIn in integer default null) is
2583: select ame_rules.rule_id
2584: from ame_rules,
2585: ame_rule_usages
2586: where
2587: item_id = applicationIdIn and
2588: rule_type = typeIn and
2589: (item_class_id is null or

Line 2591: ame_rules.rule_id = ame_rule_usages.rule_id and

2587: item_id = applicationIdIn and
2588: rule_type = typeIn and
2589: (item_class_id is null or
2590: item_class_id = itemClassIdIn) and
2591: ame_rules.rule_id = ame_rule_usages.rule_id and
2592: ((sysdate between ame_rules.start_date and
2593: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
2594: (sysdate < ame_rules.start_date and
2595: ame_rules.start_date < nvl(ame_rules.end_date,

Line 2597: ((sysdate between ame_rule_usages.start_date and

2593: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
2594: (sysdate < ame_rules.start_date and
2595: ame_rules.start_date < nvl(ame_rules.end_date,
2596: ame_rules.start_date + ame_util.oneSecond))) and
2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
2599: (sysdate < ame_rule_usages.start_date and
2600: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
2601: ame_rule_usages.start_date + ame_util.oneSecond)));

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

2594: (sysdate < ame_rules.start_date and
2595: ame_rules.start_date < nvl(ame_rules.end_date,
2596: ame_rules.start_date + ame_util.oneSecond))) and
2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
2599: (sysdate < ame_rule_usages.start_date and
2600: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
2601: ame_rule_usages.start_date + ame_util.oneSecond)));
2602: actionIdList1 ame_util.idList;

Line 2599: (sysdate < ame_rule_usages.start_date and

2595: ame_rules.start_date < nvl(ame_rules.end_date,
2596: ame_rules.start_date + ame_util.oneSecond))) and
2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
2599: (sysdate < ame_rule_usages.start_date and
2600: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
2601: ame_rule_usages.start_date + ame_util.oneSecond)));
2602: actionIdList1 ame_util.idList;
2603: actionIdList2 ame_util.idList;

Line 2600: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

2596: ame_rules.start_date + ame_util.oneSecond))) and
2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
2599: (sysdate < ame_rule_usages.start_date and
2600: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
2601: ame_rule_usages.start_date + ame_util.oneSecond)));
2602: actionIdList1 ame_util.idList;
2603: actionIdList2 ame_util.idList;
2604: actionIdMatch boolean;

Line 2601: ame_rule_usages.start_date + ame_util.oneSecond)));

2597: ((sysdate between ame_rule_usages.start_date and
2598: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
2599: (sysdate < ame_rule_usages.start_date and
2600: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
2601: ame_rule_usages.start_date + ame_util.oneSecond)));
2602: actionIdList1 ame_util.idList;
2603: actionIdList2 ame_util.idList;
2604: actionIdMatch boolean;
2605: conditionIdList1 ame_util.idList;

Line 3224: from ame_rule_usages

3220: procedure changeAllAttributeUseCounts(ruleIdIn in integer,
3221: finalizeIn in boolean default true) as
3222: cursor applicationCursor(ruleIdIn in integer) is
3223: select item_id
3224: from ame_rule_usages
3225: where
3226: rule_id = ruleIdIn and
3227: ((sysdate between start_date and
3228: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 3371: from ame_rule_usages

3367: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
3368: for update;
3369: cursor usageDataCursor is
3370: select rule_id
3371: from ame_rule_usages
3372: where
3373: item_id = applicationIdIn and
3374: rule_id = ruleIdIn and
3375: start_date = oldStartDateIn and

Line 3435: update ame_rule_usages

3431: newStartDate := processingDate;
3432: end if;
3433: endDate := processingDate;
3434: currentUserId := ame_util.getCurrentUserId;
3435: update ame_rule_usages
3436: set
3437: last_updated_by = currentUserId,
3438: last_update_date = endDate,
3439: last_update_login = currentUserId,

Line 3810: ame_rule_usages u,

3806: u.priority priority,
3807: r.item_class_id,
3808: u.approver_category
3809: from
3810: ame_rule_usages u,
3811: ame_rules r,
3812: ame_item_class_usages i
3813: where
3814: u.rule_id = r.rule_id and

Line 3843: ame_rule_usages u,

3839: u.priority priority,
3840: null item_class_id,
3841: u.approver_category
3842: from
3843: ame_rule_usages u,
3844: ame_rules r
3845: where
3846: u.rule_id = r.rule_id and
3847: r.rule_type in (ame_util.substitutionRuleType, ame_util.listModRuleType) and

Line 3914: ame_rule_usages u

3910: distinct(r.rule_id) rule_id,
3911: r.description
3912: from
3913: ame_rules r,
3914: ame_rule_usages u
3915: where
3916: u.rule_id = r.rule_id and
3917: (r.item_class_id is null or
3918: r.item_class_id = itemClassIdIn) and

Line 4189: from ame_rule_usages,

4185: transactionTypeDescriptionsOut out nocopy ame_util.stringList) as
4186: cursor getAppUsagesCursor(ruleIdIn in integer) is
4187: select application_id,
4188: application_name
4189: from ame_rule_usages,
4190: ame_calling_apps
4191: where
4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and

Line 4192: ame_rule_usages.item_id = ame_calling_apps.application_id and

4188: application_name
4189: from ame_rule_usages,
4190: ame_calling_apps
4191: where
4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and
4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
4196: (ame_calling_apps.start_date <= sysdate and

Line 4193: ame_rule_usages.rule_id = ruleIdIn and

4189: from ame_rule_usages,
4190: ame_calling_apps
4191: where
4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and
4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
4196: (ame_calling_apps.start_date <= sysdate and
4197: (ame_calling_apps.end_date is null or sysdate < ame_calling_apps.end_date))

Line 4194: (ame_rule_usages.start_date <= sysdate and

4190: ame_calling_apps
4191: where
4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and
4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
4196: (ame_calling_apps.start_date <= sysdate and
4197: (ame_calling_apps.end_date is null or sysdate < ame_calling_apps.end_date))
4198: order by application_name;

Line 4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and

4191: where
4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and
4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
4196: (ame_calling_apps.start_date <= sysdate and
4197: (ame_calling_apps.end_date is null or sysdate < ame_calling_apps.end_date))
4198: order by application_name;
4199: tempIndex integer;

Line 4226: from ame_rule_usages

4222: prioritiesOut out nocopy ame_util.stringList) as
4223: cursor getRuleUsageCursor(ruleIdIn in integer) is
4224: select item_id,
4225: priority
4226: from ame_rule_usages
4227: where rule_id = ruleIdIn and
4228: ((sysdate between start_date and
4229: nvl(end_date - ame_util.oneSecond, sysdate)) or
4230: (sysdate < start_date and

Line 4603: update ame_rule_usages

4599: end if;
4600: getRequiredAttributes(ruleIdIn => ruleIdIn,
4601: attributeIdsOut => attributeIdList);
4602: currentUserId := ame_util.getCurrentUserId;
4603: update ame_rule_usages
4604: set
4605: last_updated_by = currentUserId,
4606: last_update_date = processingDate,
4607: last_update_login = currentUserId,