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

Line 1: PACKAGE BODY AME_RULE_USAGES_API AS

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

Line 43: from AME_RULE_USAGES

39: X_ITEM_ID in NUMBER,
40: X_RULE_ID in NUMBER
41: ) is
42: select COUNT(*)
43: from AME_RULE_USAGES
44: where RULE_ID = X_RULE_ID
45: and ITEM_ID = X_ITEM_ID;
46:
47: begin

Line 71: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID

67:
68: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type,
69: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
70: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
71: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
72: from AME_RULES, AME_RULE_USAGES
73: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
74: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
75: and ((sysdate between AME_RULES.START_DATE

Line 72: from AME_RULES, AME_RULE_USAGES

68: function CALCULATE_USE_COUNT(X_ATTRIBUTE_ID ame_attribute_usages.attribute_id%type,
69: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
70: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
71: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
72: from AME_RULES, AME_RULE_USAGES
73: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
74: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
75: and ((sysdate between AME_RULES.START_DATE
76: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))

Line 73: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID

69: X_APPLICATION_ID ame_attribute_usages.application_id%type) return integer as
70: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
71: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
72: from AME_RULES, AME_RULE_USAGES
73: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
74: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
75: and ((sysdate between AME_RULES.START_DATE
76: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
77: or (sysdate < AME_RULES.START_DATE

Line 74: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID

70: cursor RULE_CURSOR(X_APPLICATION_ID in integer) is
71: select AME_RULE_USAGES.RULE_ID, AME_RULES.ACTION_ID
72: from AME_RULES, AME_RULE_USAGES
73: where AME_RULES.RULE_ID = AME_RULE_USAGES.RULE_ID
74: and AME_RULE_USAGES.ITEM_ID = X_APPLICATION_ID
75: and ((sysdate between AME_RULES.START_DATE
76: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
77: or (sysdate < AME_RULES.START_DATE
78: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,

Line 80: and ((sysdate between AME_RULE_USAGES.START_DATE

76: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
77: or (sysdate < AME_RULES.START_DATE
78: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
79: AME_RULES.START_DATE + (1/86400))))
80: and ((sysdate between AME_RULE_USAGES.START_DATE
81: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
82: or (sysdate < AME_RULE_USAGES.START_DATE
83: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
84: AME_RULE_USAGES.START_DATE + (1/86400))));

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

77: or (sysdate < AME_RULES.START_DATE
78: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
79: AME_RULES.START_DATE + (1/86400))))
80: and ((sysdate between AME_RULE_USAGES.START_DATE
81: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
82: or (sysdate < AME_RULE_USAGES.START_DATE
83: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
84: AME_RULE_USAGES.START_DATE + (1/86400))));
85: RULE_COUNT integer;

Line 82: or (sysdate < AME_RULE_USAGES.START_DATE

78: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,
79: AME_RULES.START_DATE + (1/86400))))
80: and ((sysdate between AME_RULE_USAGES.START_DATE
81: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
82: or (sysdate < AME_RULE_USAGES.START_DATE
83: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
84: AME_RULE_USAGES.START_DATE + (1/86400))));
85: RULE_COUNT integer;
86: TEMP_COUNT integer;

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

79: AME_RULES.START_DATE + (1/86400))))
80: and ((sysdate between AME_RULE_USAGES.START_DATE
81: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
82: or (sysdate < AME_RULE_USAGES.START_DATE
83: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
84: AME_RULE_USAGES.START_DATE + (1/86400))));
85: RULE_COUNT integer;
86: TEMP_COUNT integer;
87: NEW_USE_COUNT integer;

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

80: and ((sysdate between AME_RULE_USAGES.START_DATE
81: and nvl(AME_RULE_USAGES.END_DATE - (1/86400), sysdate))
82: or (sysdate < AME_RULE_USAGES.START_DATE
83: and AME_RULE_USAGES.START_DATE < nvl(AME_RULE_USAGES.END_DATE,
84: AME_RULE_USAGES.START_DATE + (1/86400))));
85: RULE_COUNT integer;
86: TEMP_COUNT integer;
87: NEW_USE_COUNT integer;
88: begin

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

165: raise;
166: return(null);
167: end CALCULATE_USE_COUNT;
168:
169: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
170: X_APPLICATION_ID ame_rule_usages.item_id%type) is
171: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
172: select AME_CONDITIONS.ATTRIBUTE_ID
173: from AME_CONDITIONS,

Line 170: X_APPLICATION_ID ame_rule_usages.item_id%type) is

166: return(null);
167: end CALCULATE_USE_COUNT;
168:
169: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
170: X_APPLICATION_ID ame_rule_usages.item_id%type) is
171: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
172: select AME_CONDITIONS.ATTRIBUTE_ID
173: from AME_CONDITIONS,
174: AME_CONDITION_USAGES

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

167: end CALCULATE_USE_COUNT;
168:
169: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type,
170: X_APPLICATION_ID ame_rule_usages.item_id%type) is
171: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
172: select AME_CONDITIONS.ATTRIBUTE_ID
173: from AME_CONDITIONS,
174: AME_CONDITION_USAGES
175: where

Line 254: insert into AME_RULE_USAGES

250: X_OBJECT_VERSION_NUMBER in NUMBER)
251: is
252: begin
253:
254: insert into AME_RULE_USAGES
255: (
256: ITEM_ID,
257: RULE_ID,
258: APPROVER_CATEGORY,

Line 288: delete from AME_RULE_USAGES

284: X_ITEM_ID in NUMBER,
285: X_RULE_ID in NUMBER
286: ) is
287: begin
288: delete from AME_RULE_USAGES
289: where ITEM_ID = X_ITEM_ID
290: and RULE_ID = X_RULE_ID;
291:
292: if (sql%notfound) then

Line 306: from ame_rule_usages aru,

302: select aa.action_id,
303: aa.action_type_id,
304: aat.name,
305: aa.parameter
306: from ame_rule_usages aru,
307: ame_action_usages aau,
308: ame_actions aa,
309: ame_action_types aat
310: where aru.rule_id = x_rule_id

Line 429: END AME_RULE_USAGES_API;

425: sqlerrm);
426: raise;
427: end LOAD_ROW;
428: --
429: END AME_RULE_USAGES_API;