APPS.AME_CONDITION_USAGES_API dependencies on AME_CONDITION_USAGES

Line 1: PACKAGE BODY AME_CONDITION_USAGES_API AS

1: PACKAGE BODY AME_CONDITION_USAGES_API AS
2: /* $Header: amecsapi.pkb 120.1 2005/10/14 04:12:25 ubhat noship $ */
3:
4: procedure OWNER_TO_WHO (
5: X_OWNER in VARCHAR2,

Line 27: from AME_CONDITION_USAGES

23: X_CONDITION_ID in NUMBER,
24: X_RULE_ID in NUMBER
25: ) is
26: select COUNT(*)
27: from AME_CONDITION_USAGES
28: where CONDITION_ID = X_CONDITION_ID
29: and RULE_ID = X_RULE_ID;
30:
31: X_ATTRIBUTE_ID NUMBER;

Line 59: from AME_CONDITION_USAGES

55: X_CONDITION_ID in NUMBER,
56: X_RULE_ID in NUMBER
57: ) is
58: select COUNT(*)
59: from AME_CONDITION_USAGES
60: where CONDITION_ID = X_CONDITION_ID
61: and RULE_ID = X_RULE_ID;
62: cursor CSR_GET_RULE_ID
63: (

Line 105: insert into AME_CONDITION_USAGES

101: is
102:
103: begin
104:
105: insert into AME_CONDITION_USAGES
106: (
107: RULE_ID,
108: CONDITION_ID,
109: CREATED_BY,

Line 136: delete from AME_CONDITION_USAGES

132: X_RULE_ID in NUMBER,
133: X_CONDITION_ID in NUMBER)
134: is
135: begin
136: delete from AME_CONDITION_USAGES
137: where RULE_ID = X_RULE_ID
138: and CONDITION_ID = X_CONDITION_ID;
139:
140: if (sql%notfound) then

Line 189: ame_util.runtimeException('ame_condition_usages_api',

185: end if;
186: end if;
187: exception
188: when others then
189: ame_util.runtimeException('ame_condition_usages_api',
190: 'load_row',
191: sqlcode,
192: sqlerrm);
193: raise;

Line 196: END AME_CONDITION_USAGES_API;

192: sqlerrm);
193: raise;
194: end LOAD_ROW;
195: --
196: END AME_CONDITION_USAGES_API;