DBA Data[Home] [Help]

APPS.FND_OID_PLUG dependencies on DBMS_SQL

Line 394: c := dbms_sql.open_cursor;

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);

Line 395: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);

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);

Line 396: dbms_sql.bind_variable(c, ':2', param);

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);

Line 397: dbms_sql.bind_variable(c,':1',result,4000);

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:

Line 398: res := dbms_sql.execute(c);

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)

Line 399: dbms_sql.variable_value(c,':1',result);

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

Line 400: dbms_sql.close_cursor(c);

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');