461: if (p_qual_proc is not null) then
462: --
463: statem := 'BEGIN '||p_qual_proc||'(:objectid, :qual); END;';
464: --
465: hr_utility.trace(statem);
466:
467: sql_cur := dbms_sql.open_cursor;
468: dbms_sql.parse(sql_cur,
469: statem,
883: where short_name = l_upg_def_nm;
884: --
885: statem := 'BEGIN '||upgrade_proc||'(:objectid); END;';
886: --
887: hr_utility.trace(statem);
888:
889: sql_cur := dbms_sql.open_cursor;
890: dbms_sql.parse(sql_cur,
891: statem,