APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on AME_UTIL

Line 286: ,ame_util.approverOamGroupId

282: ,QUERY_STRING
283: ,ORDER_NUMBER
284: ) select
285: X_APPROVAL_GROUP_ID
286: ,ame_util.approverOamGroupId
287: ,X_APPROVAL_GROUP_ID
288: ,X_QUERY_STRING
289: ,1
290: from sys.dual;

Line 293: where PARAMETER_NAME = ame_util.approverOamGroupId

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

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

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

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

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

Line 354: ,ame_util.serializedVoting

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

Line 578: ame_util.runtimeException('ame_approval_groups_api'

574: );
575: end if;
576: exception
577: when others then
578: ame_util.runtimeException('ame_approval_groups_api'
579: ,'load_row'
580: ,sqlcode
581: ,sqlerrm);
582: raise;