[Home] [Help]
373: 'OLD BATCH',
374: BATCH_ID
375: INTO P_BATCH_TYPE,L_BATCH_ID
376: FROM
377: AP_BATCHES
378: WHERE BATCH_NAME = p_batch_name_t;
379: EXCEPTION
380: WHEN NO_DATA_FOUND THEN
381: P_BATCH_TYPE := 'NEW BATCH';
386: /*SRW.MESSAGE('1'
387: ,DEBUG_INFO)*/NULL;
388: END IF;
389: SELECT
390: AP_BATCHES_S.NEXTVAL
391: INTO L_BATCH_ID
392: FROM
393: SYS.DUAL;
394: END IF;