694: SELECT 'OLD BATCH',
695: batch_id
696: INTO p_batch_type,
697: l_batch_id
698: FROM ap_batches_all
699: WHERE batch_name = P_batch_name;
700:
701: EXCEPTION
702: WHEN NO_DATA_FOUND THEN
3492: ---------------------------------------------
3493: -- Insert ap_batches
3494: ---------------------------------------------
3495: debug_info := 'Insert ap_batches';
3496: -- bug 5441261. Insert should be into AP_BATCHES_ALL
3497: INSERT INTO ap_batches_all(
3498: batch_id,
3499: batch_name,
3500: batch_date,
3493: -- Insert ap_batches
3494: ---------------------------------------------
3495: debug_info := 'Insert ap_batches';
3496: -- bug 5441261. Insert should be into AP_BATCHES_ALL
3497: INSERT INTO ap_batches_all(
3498: batch_id,
3499: batch_name,
3500: batch_date,
3501: last_update_date,