DBA Data[Home] [Help]

APPS.PON_MULTIPLE_RESPONSE_PKG dependencies on PON_LARGE_AUCTION_UTIL_PKG

Line 305: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN

301: WHERE ah.auction_header_id = p_auc_header_id;
302:
303: -- Define the initial batch range (line numbers are indexed from 1)
304: l_batch_start := 1;
305: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
306: l_batch_end := l_max_line_number;
307: ELSE
308: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
309: END IF;

Line 308: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

304: l_batch_start := 1;
305: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
306: l_batch_end := l_max_line_number;
307: ELSE
308: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
309: END IF;
310:
311: WHILE (l_batch_start <= l_max_line_number) LOOP
312:

Line 347: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN

343: AND bl.auction_line_number <> -1; --Donot update unsolicited lines.
344:
345: -- Find the new batch range
346: l_batch_start := l_batch_end + 1;
347: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
348: l_batch_end := l_max_line_number;
349: ELSE
350: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
351: END IF;

Line 350: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

346: l_batch_start := l_batch_end + 1;
347: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
348: l_batch_end := l_max_line_number;
349: ELSE
350: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
351: END IF;
352:
353: END LOOP;
354: -- END BATCHING