APPS.PO_INQ_SV dependencies on PO_DOCUMENT_TYPES_VL

Line 1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,

1875: ===========================================================================*/
1876:
1877: FUNCTION get_type_name
1878: (
1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS

Line 1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE

1876:
1877: FUNCTION get_type_name
1878: (
1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS
1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

Line 1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE

1878: (
1879: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS
1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1885: BEGIN
1886:

Line 1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

1880: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1881: )
1882: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1883: IS
1884: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1885: BEGIN
1886:
1887: SELECT type_name
1888: INTO x_type_name

Line 1889: FROM po_document_types_vl

1885: BEGIN
1886:
1887: SELECT type_name
1888: INTO x_type_name
1889: FROM po_document_types_vl
1890: WHERE document_type_code = p_document_type_code
1891: AND document_subtype = p_document_subtype;
1892:
1893: return (x_type_name);