APPS.AME_APPROVER_TYPE_USAGES_API dependencies on AME_APPROVER_TYPE_USAGES

Line 1: PACKAGE BODY AME_APPROVER_TYPE_USAGES_API AS

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

Line 51: from AME_APPROVER_TYPE_USAGES

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

Line 123: insert into AME_APPROVER_TYPE_USAGES

119: X_OBJECT_VERSION_NUMBER in NUMBER
120: )
121: is
122: begin
123: insert into AME_APPROVER_TYPE_USAGES
124: (
125: APPROVER_TYPE_ID,
126: ACTION_TYPE_ID,
127: CREATED_BY,

Line 154: update AME_APPROVER_TYPE_USAGES set

150: X_APPROVER_TYPE_USAGE_ROWID in VARCHAR2,
151: X_END_DATE in DATE)
152: is
153: begin
154: update AME_APPROVER_TYPE_USAGES set
155: END_DATE = X_END_DATE
156: where ROWID = X_APPROVER_TYPE_USAGE_ROWID;
157: end UPDATE_ROW;
158: procedure DELETE_ROW (

Line 163: delete from AME_APPROVER_TYPE_USAGES

159: X_APPROVER_TYPE_ID in NUMBER,
160: X_ACTION_TYPE_ID in NUMBER
161: ) is
162: begin
163: delete from AME_APPROVER_TYPE_USAGES
164: where APPROVER_TYPE_ID = X_APPROVER_TYPE_ID
165: and ACTION_TYPE_ID = X_ACTION_TYPE_ID;
166:
167: if (sql%notfound) then

Line 183: update AME_APPROVER_TYPE_USAGES

179: X_END_DATE in DATE,
180: X_OBJECT_VERSION_NUMBER in NUMBER
181: ) is
182: begin
183: update AME_APPROVER_TYPE_USAGES
184: set CREATED_BY = X_CREATED_BY,
185: CREATION_DATE = X_CREATION_DATE,
186: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
187: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 296: END AME_APPROVER_TYPE_USAGES_API;

292: sqlerrm);
293: raise;
294: end LOAD_ROW;
295:
296: END AME_APPROVER_TYPE_USAGES_API;