DBA Data[Home] [Help]

APPS.PON_TRANSFORM_BIDDING_PKG dependencies on PON_TRANSFORM_BIDDING_PKG

Line 1: PACKAGE BODY PON_TRANSFORM_BIDDING_PKG AS

1: PACKAGE BODY PON_TRANSFORM_BIDDING_PKG AS
2: -- $Header: PONTFBDB.pls 120.4 2006/08/02 10:46:35 rpatel noship $
3: --
4:
5: --

Line 470: * nvl(PON_TRANSFORM_BIDDING_PKG.untransform_one_price(p_auction_header_id,

466: -- Untransformed View and LOT or LINE Line Type
467: ELSE
468: SELECT
469: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity))
470: * nvl(PON_TRANSFORM_BIDDING_PKG.untransform_one_price(p_auction_header_id,
471: bl.line_number, bl.price, al.quantity, p_tpid, p_site), 0)
472: INTO v_quote_amount
473: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
474: WHERE bl.bid_number = p_bid_number

Line 614: x_site_id := PON_TRANSFORM_BIDDING_PKG.FIND_USER_SITE(p_auction_header_id, p_trading_partner_id, p_trading_partner_contact_id);

610: --
611: WHEN NO_DATA_FOUND THEN
612:
613: if (p_vendor_site_id is null) then -- look in invitees table, if there is a site
614: x_site_id := PON_TRANSFORM_BIDDING_PKG.FIND_USER_SITE(p_auction_header_id, p_trading_partner_id, p_trading_partner_contact_id);
615:
616: else
617: x_site_id := p_vendor_site_id;
618:

Line 661: END PON_TRANSFORM_BIDDING_PKG;

657: END GET_DISPLAY_CURRENCY_INFO;
658: --
659: --
660: --
661: END PON_TRANSFORM_BIDDING_PKG;