Line 85: l_origination_type mfg_lookups.meaning%TYPE := '';
81: FUNCTION get_origination_type (
82: p_origination_type IN NUMBER
83: )
84: RETURN VARCHAR2 IS 85: l_origination_type mfg_lookups.meaning%TYPE := ''; 86: BEGIN
87:
88: SELECT meaning
89: into l_origination_type
Line 90: FROM mfg_lookups
86: BEGIN
87:
88: SELECT meaning
89: into l_origination_type 90: FROM mfg_lookups 91: WHERE lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
92: AND lookup_code = p_origination_type;
93:
94: IF SQL%NOTFOUND THEN