3012: */
3013:
3014: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3015: select type_name
3016: from po_document_types_tl tl, FND_LANGUAGES fl
3017: where fl.nls_language = p_language
3018: and tl.LANGUAGE = fl.language_code
3019: and tl.document_type_code = 'REQUISITION'
3020: and tl.document_subtype = p_doc_subtype;
3021:
3022: /*
3023: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3024: select MEANING
3025: from FND_LOOKUP_VALUES flv, FND_LANGUAGES fl
3026: where
3027: fl.nls_language = p_language
3028: and flv.LANGUAGE = fl.language_code
3029: and flv.lookup_type='REQUISITION TYPE'