DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 889: p_auction_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,

885: This function will be used in the select lists of various VOs that need
886: to query auction status
887: ======================================================================*/
888: FUNCTION GET_AUCTION_STATUS_DISPLAY(
889: p_auction_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,
890: p_user_trading_partner_id IN pon_auction_headers_all.TRADING_PARTNER_ID%TYPE) RETURN VARCHAR2;
891:
892: /*======================================================================
893: FUNCTION : GET_MONITOR_IMAGE_AND_STATUS PUBLIC

Line 890: p_user_trading_partner_id IN pon_auction_headers_all.TRADING_PARTNER_ID%TYPE) RETURN VARCHAR2;

886: to query auction status
887: ======================================================================*/
888: FUNCTION GET_AUCTION_STATUS_DISPLAY(
889: p_auction_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,
890: p_user_trading_partner_id IN pon_auction_headers_all.TRADING_PARTNER_ID%TYPE) RETURN VARCHAR2;
891:
892: /*======================================================================
893: FUNCTION : GET_MONITOR_IMAGE_AND_STATUS PUBLIC
894: PARAMETERS:

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

943: -- p_award_status - award_status column
944: -- p_award_approval_status - award_approval_status column
945: -- p_outcome_status - outcome_status column
946: --
947: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
948: -- view to get the value for the negotiation_status
949: -- column in the view. Prior to the use of this function the
950: -- same code existed as decodes in the view itself.
951: --========================================================================

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

968: -- p_view_by_date - view_by_date column
969: -- p_open_bidding_date - open_bidding_date column
970: -- p_close_bidding_date - close_bidding_date column
971: --
972: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
973: -- view to get the value for the suppl_negotiation_status
974: -- column in the view. Prior to the use of this function the
975: -- same code existed as decodes in the view itself.
976: --========================================================================