APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on PON_LARGE_AUCTION_UTIL_PKG

Line 1: PACKAGE BODY PON_LARGE_AUCTION_UTIL_PKG AS

1: PACKAGE BODY PON_LARGE_AUCTION_UTIL_PKG AS
2: -- $Header: PONLGUTB.pls 120.15 2006/03/09 15:51:28 liangxia noship $
3:
4: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.concRequestsPkg.';

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

134: WHERE ah.auction_header_id = p_auc_header_id;
135:
136: -- Define the initial batch range (line numbers are indexed from 1)
137: l_batch_start := 1;
138: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
139: l_batch_end := l_max_line_number;
140: ELSE
141: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
142: END IF;

Line 141: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;

137: l_batch_start := 1;
138: IF (l_max_line_number < PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE) THEN
139: l_batch_end := l_max_line_number;
140: ELSE
141: l_batch_end := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
142: END IF;
143:
144: -- Delete header attributes here
145: DELETE FROM pon_bid_attribute_values

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

198: END IF;
199:
200: -- Find the new batch range
201: l_batch_start := l_batch_end + 1;
202: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
203: l_batch_end := l_max_line_number;
204: ELSE
205: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
206: END IF;

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

201: l_batch_start := l_batch_end + 1;
202: IF (l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE > l_max_line_number) THEN
203: l_batch_end := l_max_line_number;
204: ELSE
205: l_batch_end := l_batch_end + PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
206: END IF;
207:
208: END LOOP;
209:

Line 978: pon_large_auction_util_pkg.delete_bid( p_auc_header_id, p_bid_number);

974: -- Initialize API return status to SUCCESS
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976:
977: -- Delete related records from tables for this bid
978: pon_large_auction_util_pkg.delete_bid( p_auc_header_id, p_bid_number);
979:
980:
981: -- Delete contract terms
982: select conterms_exist_flag into l_conterms_exist_flag

Line 1007: PON_LARGE_AUCTION_UTIL_PKG.delete_bid_header_attachment

1003: end if;
1004: end if;
1005:
1006: -- Delete bid header attachment
1007: PON_LARGE_AUCTION_UTIL_PKG.delete_bid_header_attachment
1008: (
1009: p_auc_header_id => p_auc_header_id,
1010: p_bid_number => p_bid_number
1011: );

Line 1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');

1017: WHEN PON_FAIL_CALL_DEL_DOC THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019:
1020: if FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'PON_FAIL_CALL_DEL_DOC');
1022: end if;
1023: WHEN OTHERS THEN
1024:
1025: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1028: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );

1024:
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: if FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL then
1028: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'PON.PLSQL.PON_LARGE_AUCTION_UTIL_PKG.delete_bid_from_header', 'Others:' || substr(1, 255, sqlerrm) );
1029: end if;
1030: END delete_bid_by_header;
1031:
1032: -- Delete bid header attachment

Line 1053: END PON_LARGE_AUCTION_UTIL_PKG;

1049: WHEN OTHERS THEN
1050: null;
1051: END;
1052:
1053: END PON_LARGE_AUCTION_UTIL_PKG;