[Home] [Help]
168: WHEN no_data_found THEN /* Try the translated name. */
169: BEGIN
170: SELECT application_id
171: INTO application_id_ret
172: FROM fnd_application_tl
173: WHERE application_name = application_name_in
174: AND rownum = 1;
175: RETURN application_id_ret;
176: EXCEPTION
205: WHEN no_data_found THEN /* Try the translated name. */
206: BEGIN
207: SELECT application_short_name
208: INTO application_sn_ret
209: FROM fnd_application_tl t,
210: fnd_application b
211: WHERE t.application_name = application_name_in
212: AND rownum = 1
213: AND t.application_id = b.application_id;