APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on AME_UTIL

Line 287: ,ame_util.approverOamGroupId

283: ,ORDER_NUMBER
284: ,APPROVAL_GROUP_MEMBERS_ID
285: ) select
286: X_APPROVAL_GROUP_ID
287: ,ame_util.approverOamGroupId
288: ,X_APPROVAL_GROUP_ID
289: ,X_QUERY_STRING
290: ,1
291: ,AME_APPROVAL_GROUP_MEMBERS_S.NEXTVAL

Line 295: where PARAMETER_NAME = ame_util.approverOamGroupId

291: ,AME_APPROVAL_GROUP_MEMBERS_S.NEXTVAL
292: from sys.dual;
293: update AME_APPROVAL_GROUP_MEMBERS
294: set QUERY_STRING = X_QUERY_STRING
295: where PARAMETER_NAME = ame_util.approverOamGroupId
296: and PARAMETER = to_char(X_APPROVAL_GROUP_ID)
297: and APPROVAL_GROUP_ID <> X_APPROVAL_GROUP_ID;
298: end POPULATE_APP_GRP_MEMBERS;
299:

Line 313: and nvl(end_date - ame_util.oneSecond,sysdate);

309: cursor get_active_application is
310: select APPLICATION_ID
311: from AME_CALLING_APPS
312: where sysdate between start_date
313: and nvl(end_date - ame_util.oneSecond,sysdate);
314: TYPE APPLICATION_ID_TAB is table of NUMBER index by BINARY_INTEGER;
315: APPLICATION_ID_LIST APPLICATION_ID_TAB;
316: L_ORDER_NUMBER NUMBER;
317: begin

Line 336: and nvl(end_date - ame_util.oneSecond,sysdate);

332: into L_ORDER_NUMBER
333: from AME_APPROVAL_GROUP_CONFIG
334: where application_id = APPLICATION_ID_LIST(indx)
335: and sysdate between start_date
336: and nvl(end_date - ame_util.oneSecond,sysdate);
337: --
338: -- Now insert a row for each application_id.
339: --
340: insert into AME_APPROVAL_GROUP_CONFIG(

Line 356: ,ame_util.serializedVoting

352: ,OBJECT_VERSION_NUMBER
353: ) select
354: APPLICATION_ID_LIST(indx)
355: ,X_APPROVAL_GROUP_ID
356: ,ame_util.serializedVoting
357: ,L_ORDER_NUMBER
358: ,X_CREATED_BY
359: ,X_CREATION_DATE
360: ,X_LAST_UPDATED_BY

Line 586: ame_util.runtimeException('ame_approval_groups_api'

582: end;
583: end if;
584: exception
585: when others then
586: ame_util.runtimeException('ame_approval_groups_api'
587: ,'load_row'
588: ,sqlcode
589: ,sqlerrm);
590: raise;