12: instr(release_name, ' ')-1,
13: length(release_name))),
14: release_name)
15: INTO l_release_name
16: FROM fnd_product_groups;
17:
18: return(l_release_name);
19: END;
20:
23: l_flag varchar2(1);
24: BEGIN
25: SELECT nvl(multi_org_flag, 'N')
26: INTO l_flag
27: FROM fnd_product_groups;
28:
29: return(l_flag);
30: END;
31:
34: l_flag varchar2(1);
35: BEGIN
36: SELECT nvl(multi_lingual_flag, 'N')
37: INTO l_flag
38: FROM fnd_product_groups;
39:
40: return(l_flag);
41: END;
42:
45: l_flag varchar2(1);
46: BEGIN
47: SELECT nvl(multi_currency_flag, 'N')
48: INTO l_flag
49: FROM fnd_product_groups;
50:
51: return(l_flag);
52: END;
53: