APPS.PON_BID_DEFAULTING_PKG dependencies on PON_LARGE_AUCTION_UTIL_PKG

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

858: WHERE ah.auction_header_id = p_auc_header_id;
859:
860: -- Define the initial batch range (line numbers are indexed from 1)
861: l_batch_start := 1;
862: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
863: l_batch_end := l_max_line_number;
864: ELSE
865: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
866: END IF;

Line 865: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

861: l_batch_start := 1;
862: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
863: l_batch_end := l_max_line_number;
864: ELSE
865: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
866: END IF;
867:
868: WHILE (l_batch_start <= l_max_line_number) LOOP
869:

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

899: AND bl.line_number BETWEEN l_batch_start AND l_batch_end;
900:
901: -- Find the new batch range
902: l_batch_start := l_batch_end + 1;
903: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
904: l_batch_end := l_max_line_number;
905: ELSE
906: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
907: END IF;

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

902: l_batch_start := l_batch_end + 1;
903: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
904: l_batch_end := l_max_line_number;
905: ELSE
906: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
907: END IF;
908:
909: END LOOP;
910:

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

2851: WHERE ah.auction_header_id = p_auc_header_id;
2852:
2853: -- Define the initial range (line numbers are indexed from 1)
2854: l_batch_start := 1;
2855: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
2856: l_batch_end := l_max_line_number;
2857: ELSE
2858: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
2859: END IF;

Line 2858: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

2854: l_batch_start := 1;
2855: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
2856: l_batch_end := l_max_line_number;
2857: ELSE
2858: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
2859: END IF;
2860:
2861: WHILE (l_batch_start <= l_max_line_number) LOOP
2862:

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

3008: END IF;
3009:
3010: -- Find the new range
3011: l_batch_start := l_batch_end + 1;
3012: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3013: l_batch_end := l_max_line_number;
3014: ELSE
3015: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3016: END IF;

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

3011: l_batch_start := l_batch_end + 1;
3012: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3013: l_batch_end := l_max_line_number;
3014: ELSE
3015: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3016: END IF;
3017:
3018: END LOOP;
3019:

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

3150: WHERE ah.auction_header_id = l_auc_header_id;
3151:
3152: -- Define the initial range (line numbers are indexed from 1)
3153: l_batch_start := 1;
3154: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
3155: l_batch_end := l_max_line_number;
3156: ELSE
3157: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3158: END IF;

Line 3157: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

3153: l_batch_start := 1;
3154: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
3155: l_batch_end := l_max_line_number;
3156: ELSE
3157: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3158: END IF;
3159:
3160: WHILE (l_batch_start <= l_max_line_number) LOOP
3161:

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

3189: END IF;
3190:
3191: -- Find the new range
3192: l_batch_start := l_batch_end + 1;
3193: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3194: l_batch_end := l_max_line_number;
3195: ELSE
3196: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3197: END IF;

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

3192: l_batch_start := l_batch_end + 1;
3193: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
3194: l_batch_end := l_max_line_number;
3195: ELSE
3196: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
3197: END IF;
3198:
3199: END LOOP;
3200: