APPS.PON_BID_DEFAULTING_PKG dependencies on PON_LARGE_AUCTION_UTIL_PKG

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

874: WHERE ah.auction_header_id = p_auc_header_id;
875:
876: -- Define the initial batch range (line numbers are indexed from 1)
877: l_batch_start := 1;
878: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
879: l_batch_end := l_max_line_number;
880: ELSE
881: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
882: END IF;

Line 881: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

877: l_batch_start := 1;
878: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
879: l_batch_end := l_max_line_number;
880: ELSE
881: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
882: END IF;
883:
884: WHILE (l_batch_start <= l_max_line_number) LOOP
885:

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

915: AND bl.line_number BETWEEN l_batch_start AND l_batch_end;
916:
917: -- Find the new batch range
918: l_batch_start := l_batch_end + 1;
919: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
920: l_batch_end := l_max_line_number;
921: ELSE
922: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
923: END IF;

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

918: l_batch_start := l_batch_end + 1;
919: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
920: l_batch_end := l_max_line_number;
921: ELSE
922: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
923: END IF;
924:
925: END LOOP;
926:

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

3185: WHERE ah.auction_header_id = p_auc_header_id;
3186:
3187: -- Define the initial range (line numbers are indexed from 1)
3188: l_batch_start := 1;
3189: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
3190: l_batch_end := l_max_line_number;
3191: ELSE
3192: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3193: END IF;

Line 3192: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

3188: l_batch_start := 1;
3189: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
3190: l_batch_end := l_max_line_number;
3191: ELSE
3192: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3193: END IF;
3194:
3195: WHILE (l_batch_start <= l_max_line_number) LOOP
3196:

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

3555: END IF;
3556:
3557: -- Find the new range
3558: l_batch_start := l_batch_end + 1;
3559: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3560: l_batch_end := l_max_line_number;
3561: ELSE
3562: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3563: END IF;

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

3558: l_batch_start := l_batch_end + 1;
3559: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3560: l_batch_end := l_max_line_number;
3561: ELSE
3562: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3563: END IF;
3564:
3565: END LOOP;
3566:

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

3720: WHERE ah.auction_header_id = l_auc_header_id;
3721:
3722: -- Define the initial range (line numbers are indexed from 1)
3723: l_batch_start := 1;
3724: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
3725: l_batch_end := l_max_line_number;
3726: ELSE
3727: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3728: END IF;

Line 3727: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

3723: l_batch_start := 1;
3724: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
3725: l_batch_end := l_max_line_number;
3726: ELSE
3727: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3728: END IF;
3729:
3730: WHILE (l_batch_start <= l_max_line_number) LOOP
3731:

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

3759: END IF;
3760:
3761: -- Find the new range
3762: l_batch_start := l_batch_end + 1;
3763: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3764: l_batch_end := l_max_line_number;
3765: ELSE
3766: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3767: END IF;

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

3762: l_batch_start := l_batch_end + 1;
3763: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3764: l_batch_end := l_max_line_number;
3765: ELSE
3766: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3767: END IF;
3768:
3769: END LOOP;
3770: