APPS.AME_ACTION_TYPE_USAGES_API dependencies on AME_ACTION_TYPE_USAGES

Line 1: PACKAGE BODY AME_ACTION_TYPE_USAGES_API AS

1: PACKAGE BODY AME_ACTION_TYPE_USAGES_API AS
2: /* $Header: amecuapi.pkb 120.2 2005/10/14 04:12:33 ubhat noship $ */
3: X_AME_INSTALLATION_LEVEL varchar2(255);
4: procedure OWNER_TO_WHO (
5: X_OWNER in VARCHAR2,

Line 41: from AME_ACTION_TYPE_USAGES

37: ) is select ROWID,
38: LAST_UPDATED_BY,
39: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
40: nvl(OBJECT_VERSION_NUMBER,1)
41: from AME_ACTION_TYPE_USAGES
42: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
43: and RULE_TYPE = X_RULE_TYPE
44: and sysdate between START_DATE
45: and nvl(END_DATE - (1/86400), sysdate);

Line 113: ame_util.runtimeException(packageNameIn => 'ame_action_type_usages_api',

109: exception
110: when invalidRuleTypeException then
111: errorCode := -20001;
112: errorMessage := 'OAM is attempting to upload an invalid rule type. ';
113: ame_util.runtimeException(packageNameIn => 'ame_action_type_usages_api',
114: routineNameIn => 'validate_rule_type',
115: exceptionNumberIn => errorCode,
116: exceptionStringIn => errorMessage);
117: raise_application_error(errorCode,

Line 120: ame_util.runtimeException('ame_action_type_usages_api',

116: exceptionStringIn => errorMessage);
117: raise_application_error(errorCode,
118: errorMessage);
119: when others then
120: ame_util.runtimeException('ame_action_type_usages_api',
121: 'validate_rule_type',
122: sqlcode,
123: sqlerrm);
124: raise;

Line 139: insert into AME_ACTION_TYPE_USAGES

135: X_OBJECT_VERSION_NUMBER in NUMBER
136: )
137: is
138: begin
139: insert into AME_ACTION_TYPE_USAGES
140: (
141: ACTION_TYPE_ID,
142: RULE_TYPE,
143: CREATED_BY,

Line 169: update AME_ACTION_TYPE_USAGES set

165: X_ACTION_USAGE_ROWID in VARCHAR2,
166: X_END_DATE in DATE)
167: is
168: begin
169: update AME_ACTION_TYPE_USAGES set
170: END_DATE = X_END_DATE
171: where ROWID = X_ACTION_USAGE_ROWID;
172: end UPDATE_ROW;
173:

Line 179: delete from AME_ACTION_TYPE_USAGES

175: X_ACTION_TYPE_ID in NUMBER,
176: X_RULE_TYPE in NUMBER
177: ) is
178: begin
179: delete from AME_ACTION_TYPE_USAGES
180: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
181: and RULE_TYPE = X_RULE_TYPE;
182:
183: if (sql%notfound) then

Line 278: END AME_ACTION_TYPE_USAGES_API;

274: sqlcode,
275: sqlerrm);
276: raise;
277: end LOAD_ROW;
278: END AME_ACTION_TYPE_USAGES_API;