DBA Data[Home] [Help]

APPS.FWK_TBX_SEED dependencies on FWK_TBX_LOOKUP_TYPES_TL

Line 10: insert into fwk_tbx_lookup_types_tl (

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,

Line 25: from fwk_tbx_lookup_types_tl t

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:

Line 91: update fwk_tbx_lookup_types_tl set

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')

Line 148: delete from fwk_tbx_lookup_types_tl

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;