43: FUNCTION Dynamic_Sql(x_statement IN VARCHAR2,
44: P_Group_Id IN NUMBER) RETURN NUMBER IS
45: x_cursor_id NUMBER;
46: x_num_rows NUMBER;
47: x_run_def1 NUMBER:=WIP_CONSTANTS.RUNNING;
48: x_run_def2 NUMBER:=WIP_CONSTANTS.WARNING;
49: x_process_phase NUMBER:=WIP_CONSTANTS.ML_VALIDATION;
50: BEGIN
51: begin
44: P_Group_Id IN NUMBER) RETURN NUMBER IS
45: x_cursor_id NUMBER;
46: x_num_rows NUMBER;
47: x_run_def1 NUMBER:=WIP_CONSTANTS.RUNNING;
48: x_run_def2 NUMBER:=WIP_CONSTANTS.WARNING;
49: x_process_phase NUMBER:=WIP_CONSTANTS.ML_VALIDATION;
50: BEGIN
51: begin
52: x_cursor_id := dbms_sql.open_cursor;
45: x_cursor_id NUMBER;
46: x_num_rows NUMBER;
47: x_run_def1 NUMBER:=WIP_CONSTANTS.RUNNING;
48: x_run_def2 NUMBER:=WIP_CONSTANTS.WARNING;
49: x_process_phase NUMBER:=WIP_CONSTANTS.ML_VALIDATION;
50: BEGIN
51: begin
52: x_cursor_id := dbms_sql.open_cursor;
53: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);