APPS.AME_CONDITION_USAGES_API2 dependencies on AME_CONDITION_USAGES

Line 1: PACKAGE BODY AME_CONDITION_USAGES_API2 AS

1: PACKAGE BODY AME_CONDITION_USAGES_API2 AS
2: /* $Header: amecgapi.pkb 120.1 2005/10/14 04:11:53 ubhat noship $ */
3:
4: procedure OWNER_TO_WHO (
5: X_OWNER in VARCHAR2,

Line 43: from AME_CONDITION_USAGES

39: X_CONDITION_ID in NUMBER,
40: X_RULE_ID in NUMBER
41: ) is
42: select 'FOUND'
43: from AME_CONDITION_USAGES
44: where CONDITION_ID = X_CONDITION_ID
45: and RULE_ID = X_RULE_ID;
46: begin
47: open CSR_GET_CONDITION_ID (

Line 91: from AME_CONDITION_USAGES

87: X_CONDITION_ID in NUMBER,
88: X_RULE_ID in NUMBER
89: ) is
90: select COUNT(*)
91: from AME_CONDITION_USAGES
92: where CONDITION_ID = X_CONDITION_ID
93: and RULE_ID = X_RULE_ID;
94:
95: X_ATTRIBUTE_ID NUMBER;

Line 123: from AME_CONDITION_USAGES

119: X_CONDITION_ID in NUMBER,
120: X_RULE_ID in NUMBER
121: ) is
122: select COUNT(*)
123: from AME_CONDITION_USAGES
124: where CONDITION_ID = X_CONDITION_ID
125: and RULE_ID = X_RULE_ID;
126: cursor CSR_GET_RULE_ID
127: (

Line 168: insert into AME_CONDITION_USAGES

164: is
165:
166: begin
167:
168: insert into AME_CONDITION_USAGES
169: (
170: RULE_ID,
171: CONDITION_ID,
172: CREATED_BY,

Line 199: delete from AME_CONDITION_USAGES

195: X_RULE_ID in NUMBER,
196: X_CONDITION_ID in NUMBER)
197: is
198: begin
199: delete from AME_CONDITION_USAGES
200: where RULE_ID = X_RULE_ID
201: and CONDITION_ID = X_CONDITION_ID;
202: if (sql%notfound) then
203: raise no_data_found;

Line 305: ame_util.runtimeException('ame_condition_usages_api',

301: end if;
302: end if;
303: exception
304: when others then
305: ame_util.runtimeException('ame_condition_usages_api',
306: 'load_row',
307: sqlcode,
308: sqlerrm);
309: raise;

Line 312: END AME_CONDITION_USAGES_API2;

308: sqlerrm);
309: raise;
310: end LOAD_ROW;
311: --
312: END AME_CONDITION_USAGES_API2;