APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_HEADERS_ALL_V

Line 12502: pon_auction_headers_all_v

12498: v_is_paused,
12499: v_staggered_closing_interval,
12500: v_trading_partner_contact_id
12501: FROM
12502: pon_auction_headers_all_v
12503: WHERE
12504: auction_header_id = p_auction_header_id;
12505:
12506: x_time_left := TIME_REMAINING(p_auction_header_id);

Line 12613: pon_auction_headers_all_v ah,

12609: x_retainage_flag,
12610: x_payment_rate_rype_enabled
12611: FROM
12612: po_all_doc_style_lines ps,
12613: pon_auction_headers_all_v ah,
12614: po_doc_style_headers pdsh,
12615: po_style_enabled_pay_items pspay,
12616: po_lookup_codes fl_pay_item
12617: WHERE

Line 13265: FROM fnd_lookups fl, pon_auction_headers_all_v pav

13261: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
13262: or lookup_code = pav.technical_lock_status))
13263: ||')', '')
13264: INTO l_buyer_meaning, l_buyer_sealed_meaning
13265: FROM fnd_lookups fl, pon_auction_headers_all_v pav
13266: WHERE pav.auction_header_id = p_auction_header_id
13267: AND fl.lookup_type = 'PON_AUCTION_STATUS'
13268: AND fl.lookup_code = pav.negotiation_status;
13269:

Line 13313: FROM fnd_lookups fl, pon_auction_headers_all_v pav

13309: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
13310: or lookup_code = decode(pav.sealed_auction_status, 'UNLOCKED', pav.sealed_auction_status,pav.technical_lock_status)) )
13311: ||')', '')
13312: INTO l_supp_meaning, l_supp_sealed_meaning
13313: FROM fnd_lookups fl, pon_auction_headers_all_v pav
13314: WHERE pav.auction_header_id = p_auction_header_id
13315: AND fl.lookup_type = 'PON_AUCTION_STATUS'
13316: AND fl.lookup_code = pav.suppl_negotiation_status;
13317:

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

13718: -- p_view_by_date - view_by_date column
13719: -- p_open_bidding_date - open_bidding_date column
13720: -- p_close_bidding_date - close_bidding_date column
13721: --
13722: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
13723: -- view to get the value for the suppl_negotiation_status
13724: -- column in the view. Prior to the use of this function the
13725: -- same code existed as decodes in the view itself.
13726: --========================================================================

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

13786: -- p_award_status - award_status column
13787: -- p_award_approval_status - award_approval_status column
13788: -- p_outcome_status - outcome_status column
13789: --
13790: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
13791: -- view to get the value for the negotiation_status
13792: -- column in the view. Prior to the use of this function the
13793: -- same code existed as decodes in the view itself.
13794: --========================================================================