Line 91: l_offering_name ota_offerings_tl.name%TYPE;
87: function get_offering_name (p_offering_id in number)
88: return varchar2
89: IS
90: 91: l_offering_name ota_offerings_tl.name%TYPE; 92:
93: CURSOR c_get_offering_name
94: IS
95: SELECT name from ota_offerings_tl
Line 95: SELECT name from ota_offerings_tl
91: l_offering_name ota_offerings_tl.name%TYPE;
92:
93: CURSOR c_get_offering_name
94: IS 95: SELECT name from ota_offerings_tl 96: where
97: language=userenv('LANG')
98: and
99: offering_id = p_offering_id;