APPS.MRP_UTIL dependencies on MFG_LOOKUPS

Line 55: FUNCTION lookup_desc(l_type in mfg_lookups.lookup_type%TYPE,

51: return;
52: END MRP_OUT;
53:
54: --
55: FUNCTION lookup_desc(l_type in mfg_lookups.lookup_type%TYPE,
56: l_code in mfg_lookups.lookup_code%TYPE) RETURN VARCHAR2 IS
57:
58: CURSOR cur_desc(x_type mfg_lookups.lookup_type%TYPE,
59: x_code mfg_lookups.lookup_code%TYPE)

Line 56: l_code in mfg_lookups.lookup_code%TYPE) RETURN VARCHAR2 IS

52: END MRP_OUT;
53:
54: --
55: FUNCTION lookup_desc(l_type in mfg_lookups.lookup_type%TYPE,
56: l_code in mfg_lookups.lookup_code%TYPE) RETURN VARCHAR2 IS
57:
58: CURSOR cur_desc(x_type mfg_lookups.lookup_type%TYPE,
59: x_code mfg_lookups.lookup_code%TYPE)
60: IS

Line 58: CURSOR cur_desc(x_type mfg_lookups.lookup_type%TYPE,

54: --
55: FUNCTION lookup_desc(l_type in mfg_lookups.lookup_type%TYPE,
56: l_code in mfg_lookups.lookup_code%TYPE) RETURN VARCHAR2 IS
57:
58: CURSOR cur_desc(x_type mfg_lookups.lookup_type%TYPE,
59: x_code mfg_lookups.lookup_code%TYPE)
60: IS
61: SELECT meaning
62: FROM mfg_lookups

Line 59: x_code mfg_lookups.lookup_code%TYPE)

55: FUNCTION lookup_desc(l_type in mfg_lookups.lookup_type%TYPE,
56: l_code in mfg_lookups.lookup_code%TYPE) RETURN VARCHAR2 IS
57:
58: CURSOR cur_desc(x_type mfg_lookups.lookup_type%TYPE,
59: x_code mfg_lookups.lookup_code%TYPE)
60: IS
61: SELECT meaning
62: FROM mfg_lookups
63: WHERE lookup_code = x_code

Line 62: FROM mfg_lookups

58: CURSOR cur_desc(x_type mfg_lookups.lookup_type%TYPE,
59: x_code mfg_lookups.lookup_code%TYPE)
60: IS
61: SELECT meaning
62: FROM mfg_lookups
63: WHERE lookup_code = x_code
64: AND lookup_type = x_type;
65:
66: l_desc mfg_lookups.meaning%TYPE;

Line 66: l_desc mfg_lookups.meaning%TYPE;

62: FROM mfg_lookups
63: WHERE lookup_code = x_code
64: AND lookup_type = x_type;
65:
66: l_desc mfg_lookups.meaning%TYPE;
67: BEGIN
68: IF l_code is null then return null;
69: ELSE
70: open cur_desc(l_type,l_code);