77: END get_result_esig_status;
78:
79:
80: ---------------------------------------------------------------------
81: FUNCTION get_mfg_lookups_meaning (p_lookup_type IN VARCHAR2,
82: p_lookup_code IN NUMBER)
83: RETURN VARCHAR2 IS
84: ---------------------------------------------------------------------
85:
86: l_meaning VARCHAR2(80);
87:
88: CURSOR C1 IS
89: SELECT meaning
90: FROM mfg_lookups
91: WHERE lookup_code = p_lookup_code
92: AND lookup_type = p_lookup_type;
93:
94: BEGIN
104:
105:
106: RETURN l_meaning;
107:
108: END get_mfg_lookups_meaning;
109:
110: -- R12 ERES Support in Service Family. Bug 4345768
111: -- START
112: -- This function returns if a given plan is