APPS.PO_INQ_SV dependencies on PO_DOCUMENT_TYPES_VL

Line 1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,

1929: ===========================================================================*/
1930:
1931: FUNCTION get_type_name
1932: (
1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS

Line 1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE

1930:
1931: FUNCTION get_type_name
1932: (
1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS
1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

Line 1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE

1932: (
1933: p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS
1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1939: BEGIN
1940:

Line 1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;

1934: p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
1935: )
1936: RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE
1937: IS
1938: x_type_name PO_DOCUMENT_TYPES_VL.type_name%TYPE;
1939: BEGIN
1940:
1941: SELECT type_name
1942: INTO x_type_name

Line 1943: FROM po_document_types_vl

1939: BEGIN
1940:
1941: SELECT type_name
1942: INTO x_type_name
1943: FROM po_document_types_vl
1944: WHERE document_type_code = p_document_type_code
1945: AND document_subtype = p_document_subtype;
1946:
1947: return (x_type_name);