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.11.12020000.2 2013/02/09 10:49:09 hvutukur ship $
3: --
4:
5: --

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

558: -- Untransformed View and LOT or LINE Line Type
559: ELSE
560: SELECT
561: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity))
562: * nvl(PON_TRANSFORM_BIDDING_PKG.untransform_one_price(p_auction_header_id,
563: bl.line_number, bl.price, al.quantity, p_tpid, p_site), 0)
564: INTO v_quote_amount
565: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
566: WHERE bl.bid_number = p_bid_number

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

702: --
703: WHEN NO_DATA_FOUND THEN
704:
705: if (p_vendor_site_id is null) then -- look in invitees table, if there is a site
706: x_site_id := PON_TRANSFORM_BIDDING_PKG.FIND_USER_SITE(p_auction_header_id, p_trading_partner_id, p_trading_partner_contact_id);
707:
708: else
709: x_site_id := p_vendor_site_id;
710:

Line 1001: END PON_TRANSFORM_BIDDING_PKG;

997: RETURN v_unawarded_bid_total;
998: END get_unawarded_bid_total;
999: --
1000: --
1001: END PON_TRANSFORM_BIDDING_PKG;