APPS.POS_ASL_TOLERANCE_PKG dependencies on DBMS_SQL

Line 198: l_cursor := dbms_sql.open_cursor;

194: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
195: to_char(p_col) || '; ' ||
196: ' end;';
197:
198: l_cursor := dbms_sql.open_cursor;
199: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
200: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
202:

Line 199: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);

195: to_char(p_col) || '; ' ||
196: ' end;';
197:
198: l_cursor := dbms_sql.open_cursor;
199: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
200: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
202:
203: l_execute := dbms_sql.execute(l_cursor);

Line 200: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);

196: ' end;';
197:
198: l_cursor := dbms_sql.open_cursor;
199: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
200: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
202:
203: l_execute := dbms_sql.execute(l_cursor);
204: dbms_sql.variable_value(l_cursor, 'l_result', l_result);

Line 201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);

197:
198: l_cursor := dbms_sql.open_cursor;
199: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
200: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
202:
203: l_execute := dbms_sql.execute(l_cursor);
204: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
205: dbms_sql.close_cursor(l_cursor);

Line 203: l_execute := dbms_sql.execute(l_cursor);

199: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
200: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
202:
203: l_execute := dbms_sql.execute(l_cursor);
204: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
205: dbms_sql.close_cursor(l_cursor);
206: return l_result;
207:

Line 204: dbms_sql.variable_value(l_cursor, 'l_result', l_result);

200: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
202:
203: l_execute := dbms_sql.execute(l_cursor);
204: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
205: dbms_sql.close_cursor(l_cursor);
206: return l_result;
207:
208: ELSE

Line 205: dbms_sql.close_cursor(l_cursor);

201: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
202:
203: l_execute := dbms_sql.execute(l_cursor);
204: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
205: dbms_sql.close_cursor(l_cursor);
206: return l_result;
207:
208: ELSE
209: