DBA Data[Home] [Help]

APPS.FND_OID_PLUG dependencies on DBMS_SQL

Line 1075: c := dbms_sql.open_cursor;

1071: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1072: then
1073: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1074: end if;
1075: c := dbms_sql.open_cursor;
1076: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
1077: dbms_sql.bind_variable(c, ':2', param);
1078: dbms_sql.bind_variable(c,':1',result,4000);
1079: res := dbms_sql.execute(c);

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

1072: then
1073: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1074: end if;
1075: c := dbms_sql.open_cursor;
1076: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
1077: dbms_sql.bind_variable(c, ':2', param);
1078: dbms_sql.bind_variable(c,':1',result,4000);
1079: res := dbms_sql.execute(c);
1080: dbms_sql.variable_value(c,':1',result);

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

1073: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1074: end if;
1075: c := dbms_sql.open_cursor;
1076: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
1077: dbms_sql.bind_variable(c, ':2', param);
1078: dbms_sql.bind_variable(c,':1',result,4000);
1079: res := dbms_sql.execute(c);
1080: dbms_sql.variable_value(c,':1',result);
1081: dbms_sql.close_cursor(c);

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

1074: end if;
1075: c := dbms_sql.open_cursor;
1076: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
1077: dbms_sql.bind_variable(c, ':2', param);
1078: dbms_sql.bind_variable(c,':1',result,4000);
1079: res := dbms_sql.execute(c);
1080: dbms_sql.variable_value(c,':1',result);
1081: dbms_sql.close_cursor(c);
1082:

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

1075: c := dbms_sql.open_cursor;
1076: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
1077: dbms_sql.bind_variable(c, ':2', param);
1078: dbms_sql.bind_variable(c,':1',result,4000);
1079: res := dbms_sql.execute(c);
1080: dbms_sql.variable_value(c,':1',result);
1081: dbms_sql.close_cursor(c);
1082:
1083: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

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

1076: dbms_sql.parse(c, stmt, dbms_sql.NATIVE);
1077: dbms_sql.bind_variable(c, ':2', param);
1078: dbms_sql.bind_variable(c,':1',result,4000);
1079: res := dbms_sql.execute(c);
1080: dbms_sql.variable_value(c,':1',result);
1081: dbms_sql.close_cursor(c);
1082:
1083: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1084: then

Line 1081: dbms_sql.close_cursor(c);

1077: dbms_sql.bind_variable(c, ':2', param);
1078: dbms_sql.bind_variable(c,':1',result,4000);
1079: res := dbms_sql.execute(c);
1080: dbms_sql.variable_value(c,':1',result);
1081: dbms_sql.close_cursor(c);
1082:
1083: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1084: then
1085: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END');