6: p_description varchar2)
7: is
8: begin
9:
10: insert into fwk_tbx_lookup_types_tl (
11: lookup_type,
12: display_name,
13: description,
14: language,
21: 'US'
22: from dual
23: where not exists
24: (select null
25: from fwk_tbx_lookup_types_tl t
26: where t.lookup_type = p_lookup_type
27: and t.language = 'US');
28:
29:
87: p_description varchar2)
88: is
89: begin
90:
91: update fwk_tbx_lookup_types_tl set
92: lookup_type = p_lookup_type,
93: display_name = p_display_name,
94: description = p_description,
95: source_lang = userenv('LANG')
144: procedure delete_lookup_type(p_lookup_type varchar2)
145: is
146: begin
147:
148: delete from fwk_tbx_lookup_types_tl
149: where lookup_type = p_lookup_type;
150:
151: if (sql%notfound) then
152: raise no_data_found;