628: select doc.internal_name
629: into rt_value
630: from
631: pon_auction_headers_all ah,
632: PON_AUC_DOCTYPES doc
633: where
634: ah.auction_header_id = to_number(p_id)
635: and ah.DOCTYPE_ID = doc.DOCTYPE_ID;
636:
638:
639: select doctl.NAME
640: into rt_value
641: from pon_auction_headers_all ah,
642: PON_AUC_DOCTYPES_TL doctl
643: where
644: ah.auction_header_id = to_number(p_id)
645: and ah.DOCTYPE_ID = doctl.DOCTYPE_ID
646: and doctl.LANGUAGE = userenv('LANG');