327: -- Obtain the maximum order number allotted for that application_id.
328: --
329: select nvl(max(order_number),0)+1
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: --
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(
339: APPLICATION_ID
340: ,APPROVAL_GROUP_ID
341: ,VOTING_REGIME
342: ,ORDER_NUMBER