61: END planning_group;
62:
63:
64: FUNCTION lookup_fnd (arg_lookup_type IN varchar2, arg_lookup_code IN varchar2)
65: return fnd_lookups.meaning%type IS
66: meaning_text fnd_lookups.meaning%type;
67: CURSOR c1 is
68: select meaning
69: from fnd_lookups
62:
63:
64: FUNCTION lookup_fnd (arg_lookup_type IN varchar2, arg_lookup_code IN varchar2)
65: return fnd_lookups.meaning%type IS
66: meaning_text fnd_lookups.meaning%type;
67: CURSOR c1 is
68: select meaning
69: from fnd_lookups
70: where lookup_type = arg_lookup_type and lookup_code = arg_lookup_code;
65: return fnd_lookups.meaning%type IS
66: meaning_text fnd_lookups.meaning%type;
67: CURSOR c1 is
68: select meaning
69: from fnd_lookups
70: where lookup_type = arg_lookup_type and lookup_code = arg_lookup_code;
71: BEGIN
72: IF arg_lookup_code is null or arg_lookup_code is null THEN
73: return null;