330: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
331: )
332: RETURN bis_vg_types.view_table_rec_type
333: IS
334: l_str fnd_application.application_short_name%TYPE;
335: l_pos NUMBER;
336: l_view_rec bis_vg_types.view_table_rec_type;
337:
338: CURSOR app_cursor(p_short_name IN VARCHAR2) IS
336: l_view_rec bis_vg_types.view_table_rec_type;
337:
338: CURSOR app_cursor(p_short_name IN VARCHAR2) IS
339: SELECT application_id
340: FROM fnd_application
341: WHERE application_short_name = Lower(p_short_name);
342:
343: BEGIN
344: BIS_DEBUG_PUB.Add('> get_app_info');