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

Line 1: PACKAGE BODY AME_RULE_USAGES_API2 AS

1: PACKAGE BODY AME_RULE_USAGES_API2 AS
2: /* $Header: amersapi.pkb 120.2 2005/10/14 04:13 ubhat noship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATED_BY out nocopy NUMBER,

Line 51: from AME_RULE_USAGES

47: X_ITEM_ID in NUMBER,
48: X_RULE_ID in NUMBER
49: ) is
50: select 'FOUND'
51: from AME_RULE_USAGES
52: where RULE_ID = X_RULE_ID
53: and ITEM_ID = X_ITEM_ID;
54:
55: begin

Line 116: from AME_RULE_USAGES

112: X_ITEM_ID in NUMBER,
113: X_RULE_ID in NUMBER
114: ) is
115: select COUNT(*)
116: from AME_RULE_USAGES
117: where RULE_ID = X_RULE_ID
118: and ITEM_ID = X_ITEM_ID;
119:
120: begin

Line 144: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID

140:
141: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type,
142: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
143: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
144: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
145: from AME_RULES, AME_RULE_USAGES
146: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
147: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
148: and ((sysdate between AME_RULES.START_DATE

Line 145: from AME_RULES, AME_RULE_USAGES

141: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type,
142: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
143: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
144: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
145: from AME_RULES, AME_RULE_USAGES
146: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
147: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
148: and ((sysdate between AME_RULES.START_DATE
149: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))

Line 146: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID

142: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
143: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
144: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
145: from AME_RULES, AME_RULE_USAGES
146: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
147: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
148: and ((sysdate between AME_RULES.START_DATE
149: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
150: or (sysdate < AME_RULES.START_DATE

Line 147: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID

143: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
144: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
145: from AME_RULES, AME_RULE_USAGES
146: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
147: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
148: and ((sysdate between AME_RULES.START_DATE
149: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
150: or (sysdate < AME_RULES.START_DATE
151: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,

Line 153: and ((sysdate between AME_RULE_USAGES.START_DATE

149: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
150: or (sysdate < AME_RULES.START_DATE
151: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
152: AME_RULES.START_DATE + (1/86400))))
153: and ((sysdate between AME_RULE_USAGES.START_DATE
154: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
155: or (sysdate < AME_RULE_USAGES.START_DATE
156: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
157: AME_RULE_USAGES.START_DATE + (1/86400))));

Line 154: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))

150: or (sysdate < AME_RULES.START_DATE
151: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
152: AME_RULES.START_DATE + (1/86400))))
153: and ((sysdate between AME_RULE_USAGES.START_DATE
154: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
155: or (sysdate < AME_RULE_USAGES.START_DATE
156: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
157: AME_RULE_USAGES.START_DATE + (1/86400))));
158: RULE_COUNT integer;

Line 155: or (sysdate < AME_RULE_USAGES.START_DATE

151: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
152: AME_RULES.START_DATE + (1/86400))))
153: and ((sysdate between AME_RULE_USAGES.START_DATE
154: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
155: or (sysdate < AME_RULE_USAGES.START_DATE
156: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
157: AME_RULE_USAGES.START_DATE + (1/86400))));
158: RULE_COUNT integer;
159: TEMP_COUNT integer;

Line 156: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,

152: AME_RULES.START_DATE + (1/86400))))
153: and ((sysdate between AME_RULE_USAGES.START_DATE
154: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
155: or (sysdate < AME_RULE_USAGES.START_DATE
156: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
157: AME_RULE_USAGES.START_DATE + (1/86400))));
158: RULE_COUNT integer;
159: TEMP_COUNT integer;
160: NEW_USE_COUNT integer;

Line 157: AME_RULE_USAGES.START_DATE + (1/86400))));

153: and ((sysdate between AME_RULE_USAGES.START_DATE
154: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
155: or (sysdate < AME_RULE_USAGES.START_DATE
156: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
157: AME_RULE_USAGES.START_DATE + (1/86400))));
158: RULE_COUNT integer;
159: TEMP_COUNT integer;
160: NEW_USE_COUNT integer;
161: begin

Line 242: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,

238: raise;
239: return(null);
240: end CALCULATE_USE_COUNT;
241:
242: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
243: X_APPLICATION_ID ame_rule_usages.item_id%type) is
244: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
245: select AME_CONDITIONS.ATTRIBUTE_ID
246: from AME_CONDITIONS,

Line 243: X_APPLICATION_ID ame_rule_usages.item_id%type) is

239: return(null);
240: end CALCULATE_USE_COUNT;
241:
242: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
243: X_APPLICATION_ID ame_rule_usages.item_id%type) is
244: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
245: select AME_CONDITIONS.ATTRIBUTE_ID
246: from AME_CONDITIONS,
247: AME_CONDITION_USAGES

Line 244: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is

240: end CALCULATE_USE_COUNT;
241:
242: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
243: X_APPLICATION_ID ame_rule_usages.item_id%type) is
244: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
245: select AME_CONDITIONS.ATTRIBUTE_ID
246: from AME_CONDITIONS,
247: AME_CONDITION_USAGES
248: where

Line 323: from ame_rule_usages aru,

319: select aa.action_id,
320: aa.action_type_id,
321: aat.name,
322: aa.parameter
323: from ame_rule_usages aru,
324: ame_action_usages aau,
325: ame_actions aa,
326: ame_action_types aat
327: where aru.rule_id = x_rule_id

Line 402: insert into AME_RULE_USAGES

398: X_OBJECT_VERSION_NUMBER in NUMBER)
399: is
400: begin
401:
402: insert into AME_RULE_USAGES
403: (
404: ITEM_ID,
405: RULE_ID,
406: APPROVER_CATEGORY,

Line 436: delete from AME_RULE_USAGES

432: X_ITEM_ID in NUMBER,
433: X_RULE_ID in NUMBER
434: ) is
435: begin
436: delete from AME_RULE_USAGES
437: where ITEM_ID = X_ITEM_ID
438: and RULE_ID = X_RULE_ID;
439: if (sql%notfound) then
440: raise no_data_found;

Line 538: END AME_RULE_USAGES_API2;

534: sqlerrm);
535: raise;
536: end LOAD_ROW;
537: --
538: END AME_RULE_USAGES_API2;