10:
11: BEGIN
12:
13: SELECT T.TYPE_NAME into L_Type_Name
14: from PO_DOCUMENT_TYPES_ALL_TL T
15: WHERE T.LANGUAGE = userenv('LANG')
16: and T.DOCUMENT_TYPE_CODE = 'REQUISITION'
17: AND T.DOCUMENT_SUBTYPE = X_Subtype
18: and NVL(T.org_id, -99) = NVL(X_Org_Id, -99);
364:
365: BEGIN
366:
367: SELECT T.TYPE_NAME into L_Type_Name
368: from PO_DOCUMENT_TYPES_ALL_TL T
369: WHERE T.LANGUAGE = userenv('LANG')
370: and T.DOCUMENT_TYPE_CODE IN ('PO', 'PA')
371: AND T.DOCUMENT_SUBTYPE = X_Subtype
372: and NVL(T.org_id, -99) = NVL(X_Org_Id, -99);