362: begin
363:
364: BEGIN
365: SELECT application_id INTO appid
366: FROM fnd_application
367: WHERE application_short_name = X_APP_SHORT_NAME;
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: -- Since this should never happen, throwing an exception with hard coded message text
483: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
484:
485: BEGIN
486: SELECT application_id INTO appid
487: FROM fnd_application
488: WHERE application_short_name = X_APP_SHORT_NAME;
489: EXCEPTION
490: WHEN NO_DATA_FOUND THEN
491: -- Since this should never happen, throwing an exception with hard coded message text