APPS.AME_APPROVER_TYPES_API dependencies on AME_APPROVER_TYPES

Line 1: PACKAGE BODY AME_APPROVER_TYPES_API AS

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

Line 31: from AME_APPROVER_TYPES

27: select ROWID, APPROVER_TYPE_ID,
28: LAST_UPDATED_BY,
29: to_char(LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
30: nvl(OBJECT_VERSION_NUMBER,1)
31: from AME_APPROVER_TYPES
32: where ORIG_SYSTEM = X_ORIG_SYSTEM
33: and sysdate between START_DATE
34: and nvl(END_DATE - (1/86400), sysdate);
35: begin

Line 90: insert into AME_APPROVER_TYPES

86: X_START_DATE in DATE,
87: X_OBJECT_VERSION_NUMBER in NUMBER)
88: is
89: begin
90: insert into AME_APPROVER_TYPES
91: (
92: APPROVER_TYPE_ID,
93: ORIG_SYSTEM,
94: QUERY_VARIABLE_1_LABEL,

Line 143: update AME_APPROVER_TYPES set

139: X_APPROVER_TYPE_ROWID in VARCHAR2,
140: X_END_DATE in DATE)
141: is
142: begin
143: update AME_APPROVER_TYPES set
144: END_DATE = X_END_DATE
145: where ROWID = X_APPROVER_TYPE_ROWID;
146: end UPDATE_ROW;
147:

Line 171: update AME_APPROVER_TYPES

167: X_END_DATE in DATE,
168: X_OBJECT_VERSION_NUMBER in NUMBER
169: ) is
170: begin
171: update AME_APPROVER_TYPES
172: set QUERY_VARIABLE_1_LABEL = X_QUERY_VARIABLE_1_LABEL,
173: QUERY_VARIABLE_2_LABEL = X_QUERY_VARIABLE_2_LABEL,
174: QUERY_VARIABLE_3_LABEL = X_QUERY_VARIABLE_3_LABEL,
175: QUERY_VARIABLE_4_LABEL = X_QUERY_VARIABLE_4_LABEL,

Line 198: delete from AME_APPROVER_TYPES

194: procedure DELETE_ROW (
195: X_APPROVER_TYPE_ID in NUMBER
196: ) is
197: begin
198: delete from AME_APPROVER_TYPES
199: where APPROVER_TYPE_ID = X_APPROVER_TYPE_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 253: from AME_APPROVER_TYPES;

249: -- the current row was not found insert a new row
250: if X_APPROVER_TYPE_ID is null then
251: select nvl(max(APPROVER_TYPE_ID)+1, 0)
252: into X_APPROVER_TYPE_ID
253: from AME_APPROVER_TYPES;
254: INSERT_ROW (
255: X_APPROVER_TYPE_ID,
256: X_ORIG_SYSTEM,
257: X_QUERY_VARIABLE_1_LABEL,

Line 337: ame_util.runtimeException('ame_approver_types_api',

333: end if;
334: end if;
335: exception
336: when others then
337: ame_util.runtimeException('ame_approver_types_api',
338: 'load_row',
339: sqlcode,
340: sqlerrm);
341: raise;

Line 344: END AME_APPROVER_TYPES_API;

340: sqlerrm);
341: raise;
342: end LOAD_ROW;
343:
344: END AME_APPROVER_TYPES_API;