DBA Data[Home] [Help]

APPS.FWK_TBX_SEED dependencies on FWK_TBX_LOOKUP_CODES_TL

Line 60: insert into fwk_tbx_lookup_codes_tl (

56: from fwk_tbx_lookup_codes_b
57: where lookup_type = p_lookup_type
58: and lookup_code = p_lookup_code);
59:
60: insert into fwk_tbx_lookup_codes_tl (
61: lookup_type,
62: lookup_code,
63: meaning,
64: description,

Line 77: from fwk_tbx_lookup_codes_tl t

73: 'US'
74: from dual
75: where not exists
76: (select null
77: from fwk_tbx_lookup_codes_tl t
78: where t.lookup_type = p_lookup_type
79: and t.lookup_code = p_lookup_code
80: and t.language = 'US');
81:

Line 127: update fwk_tbx_lookup_codes_tl set

123: if (sql%notfound) then
124: raise no_data_found;
125: end if;
126:
127: update fwk_tbx_lookup_codes_tl set
128: lookup_type = p_lookup_type,
129: lookup_code = p_lookup_code,
130: meaning = p_meaning,
131: description = p_description,

Line 171: delete from fwk_tbx_lookup_codes_tl

167: if (sql%notfound) then
168: raise no_data_found;
169: end if;
170:
171: delete from fwk_tbx_lookup_codes_tl
172: where lookup_type = p_lookup_type
173: and lookup_code = p_lookup_code;
174:
175: if (sql%notfound) then