DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_DEFAULTING_PKG

Line 1: PACKAGE BODY PON_BID_DEFAULTING_PKG AS

1: PACKAGE BODY PON_BID_DEFAULTING_PKG AS
2: --$Header: PONBDDFB.pls 120.52.12010000.3 2009/01/07 12:10:50 amundhra ship $
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_BID_DEFAULTING_PKG';
5: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_BID_DEFAULTING_PKG';

1: PACKAGE BODY PON_BID_DEFAULTING_PKG AS
2: --$Header: PONBDDFB.pls 120.52.12010000.3 2009/01/07 12:10:50 amundhra ship $
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_BID_DEFAULTING_PKG';
5: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.bidDefaultingPkg.';
7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;
8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;

Line 1433: SET bid_start_price = nvl((SELECT pon_bid_defaulting_pkg.apply_price_factors(p_auc_header_id, l_prev_rnd_active_bid_number, al.line_number, bl1.unit_price, bl1.quantity)

1429: -- if active bid exists then
1430: -- update the bid_start_price for the current bid lines
1431: -- using values from the previous round auction/bid
1432: UPDATE pon_bid_item_prices bl
1433: SET bid_start_price = nvl((SELECT pon_bid_defaulting_pkg.apply_price_factors(p_auc_header_id, l_prev_rnd_active_bid_number, al.line_number, bl1.unit_price, bl1.quantity)
1434: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1
1435: WHERE al.auction_header_id = l_auction_header_id_prev_round
1436: AND al.line_number = bl.line_number
1437: AND al.line_number = bl1.line_number

Line 4636: END PON_BID_DEFAULTING_PKG;

4632: END IF;
4633: END IF;
4634: return NULL;
4635: END apply_price_factors;
4636: END PON_BID_DEFAULTING_PKG;