390: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
391: then
392: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
393: end if;
394: c := dbms_sql.open_cursor;
395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
396: dbms_sql.bind_variable(c, ':2', param);
397: dbms_sql.bind_variable(c,':1',result,4000);
398: res := dbms_sql.execute(c);
391: then
392: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
393: end if;
394: c := dbms_sql.open_cursor;
395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
396: dbms_sql.bind_variable(c, ':2', param);
397: dbms_sql.bind_variable(c,':1',result,4000);
398: res := dbms_sql.execute(c);
399: dbms_sql.variable_value(c,':1',result);
392: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
393: end if;
394: c := dbms_sql.open_cursor;
395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
396: dbms_sql.bind_variable(c, ':2', param);
397: dbms_sql.bind_variable(c,':1',result,4000);
398: res := dbms_sql.execute(c);
399: dbms_sql.variable_value(c,':1',result);
400: dbms_sql.close_cursor(c);
393: end if;
394: c := dbms_sql.open_cursor;
395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
396: dbms_sql.bind_variable(c, ':2', param);
397: dbms_sql.bind_variable(c,':1',result,4000);
398: res := dbms_sql.execute(c);
399: dbms_sql.variable_value(c,':1',result);
400: dbms_sql.close_cursor(c);
401:
394: c := dbms_sql.open_cursor;
395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
396: dbms_sql.bind_variable(c, ':2', param);
397: dbms_sql.bind_variable(c,':1',result,4000);
398: res := dbms_sql.execute(c);
399: dbms_sql.variable_value(c,':1',result);
400: dbms_sql.close_cursor(c);
401:
402: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
396: dbms_sql.bind_variable(c, ':2', param);
397: dbms_sql.bind_variable(c,':1',result,4000);
398: res := dbms_sql.execute(c);
399: dbms_sql.variable_value(c,':1',result);
400: dbms_sql.close_cursor(c);
401:
402: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
403: then
396: dbms_sql.bind_variable(c, ':2', param);
397: dbms_sql.bind_variable(c,':1',result,4000);
398: res := dbms_sql.execute(c);
399: dbms_sql.variable_value(c,':1',result);
400: dbms_sql.close_cursor(c);
401:
402: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
403: then
404: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');