APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_HEADERS_ALL_V

Line 13358: pon_auction_headers_all_v

13354: v_is_paused,
13355: v_staggered_closing_interval,
13356: v_trading_partner_contact_id
13357: FROM
13358: pon_auction_headers_all_v
13359: WHERE
13360: auction_header_id = p_auction_header_id;
13361:
13362: x_time_left := TIME_REMAINING(p_auction_header_id);

Line 13470: pon_auction_headers_all_v ah,

13466: x_retainage_flag,
13467: x_payment_rate_rype_enabled
13468: FROM
13469: po_all_doc_style_lines ps,
13470: pon_auction_headers_all_v ah,
13471: po_doc_style_headers pdsh,
13472: po_style_enabled_pay_items pspay,
13473: po_lookup_codes fl_pay_item
13474: WHERE

Line 14124: FROM fnd_lookups fl, pon_auction_headers_all_v pav

14120: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14121: or lookup_code = pav.technical_lock_status))
14122: ||')', '')
14123: INTO l_buyer_meaning, l_buyer_sealed_meaning
14124: FROM fnd_lookups fl, pon_auction_headers_all_v pav
14125: WHERE pav.auction_header_id = p_auction_header_id
14126: AND fl.lookup_type = 'PON_AUCTION_STATUS'
14127: AND fl.lookup_code = pav.negotiation_status;
14128:

Line 14172: FROM fnd_lookups fl, pon_auction_headers_all_v pav

14168: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14169: or lookup_code = decode(pav.sealed_auction_status, 'UNLOCKED', pav.sealed_auction_status,pav.technical_lock_status)) )
14170: ||')', '')
14171: INTO l_supp_meaning, l_supp_sealed_meaning
14172: FROM fnd_lookups fl, pon_auction_headers_all_v pav
14173: WHERE pav.auction_header_id = p_auction_header_id
14174: AND fl.lookup_type = 'PON_AUCTION_STATUS'
14175: AND fl.lookup_code = pav.suppl_negotiation_status;
14176:

Line 14581: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v

14577: -- p_view_by_date - view_by_date column
14578: -- p_open_bidding_date - open_bidding_date column
14579: -- p_close_bidding_date - close_bidding_date column
14580: --
14581: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
14582: -- view to get the value for the suppl_negotiation_status
14583: -- column in the view. Prior to the use of this function the
14584: -- same code existed as decodes in the view itself.
14585: --========================================================================

Line 14649: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v

14645: -- p_award_status - award_status column
14646: -- p_award_approval_status - award_approval_status column
14647: -- p_outcome_status - outcome_status column
14648: --
14649: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
14650: -- view to get the value for the negotiation_status
14651: -- column in the view. Prior to the use of this function the
14652: -- same code existed as decodes in the view itself.
14653: --========================================================================