APPS.AME_ACTION_TYPE_CONFIG_API dependencies on AME_ACTION_TYPE_CONFIG

Line 1: PACKAGE BODY AME_ACTION_TYPE_CONFIG_API AS

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

Line 52: from AME_ACTION_TYPE_CONFIG

48: select ROWID,
49: LAST_UPDATED_BY,
50: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
51: nvl(OBJECT_VERSION_NUMBER,1)
52: from AME_ACTION_TYPE_CONFIG
53: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
54: and APPLICATION_ID = X_APPLICATION_ID
55: and sysdate between START_DATE
56: and nvl(END_DATE - (1/86400), sysdate);

Line 124: insert into AME_ACTION_TYPE_CONFIG

120: X_START_DATE in DATE,
121: X_OBJECT_VERSION_NUMBER in NUMBER)
122: is
123: begin
124: insert into AME_ACTION_TYPE_CONFIG
125: (
126: APPLICATION_ID,
127: ACTION_TYPE_ID,
128: VOTING_REGIME,

Line 170: update AME_ACTION_TYPE_CONFIG

166: X_END_DATE in DATE,
167: X_OBJECT_VERSION_NUMBER in NUMBER
168: ) is
169: begin
170: update AME_ACTION_TYPE_CONFIG
171: set VOTING_REGIME = X_VOTING_REGIME,
172: ORDER_NUMBER = X_ORDER_NUMBER,
173: CHAIN_ORDERING_MODE = X_CHAIN_ORDERING_MODE,
174: CREATED_BY = X_CREATED_BY,

Line 189: update AME_ACTION_TYPE_CONFIG set

185: X_CONFIG_ROWID in VARCHAR2,
186: X_END_DATE in DATE)
187: is
188: begin
189: update AME_ACTION_TYPE_CONFIG set
190: END_DATE = X_END_DATE
191: where ROWID = X_CONFIG_ROWID;
192: end UPDATE_ROW;
193: procedure DELETE_ROW (

Line 198: delete from AME_ACTION_TYPE_CONFIG

194: X_APPLICATION_ID in NUMBER,
195: X_ACTION_TYPE_ID in NUMBER
196: ) is
197: begin
198: delete from AME_ACTION_TYPE_CONFIG
199: where APPLICATION_ID = X_APPLICATION_ID
200: and ACTION_TYPE_ID = X_ACTION_TYPE_ID;
201:
202: if (sql%notfound) then

Line 310: ame_util.runtimeException('ame_action_type_config_api',

306: end if;
307: end;
308: exception
309: when others then
310: ame_util.runtimeException('ame_action_type_config_api',
311: 'load_row',
312: sqlcode,
313: sqlerrm);
314: raise;

Line 317: END AME_ACTION_TYPE_CONFIG_API;

313: sqlerrm);
314: raise;
315: end LOAD_ROW;
316: --
317: END AME_ACTION_TYPE_CONFIG_API;