APPS.POS_ASL_CAPACITY_PKG dependencies on DBMS_SQL

Line 200: l_cursor := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

Line 207: dbms_sql.close_cursor(l_cursor);

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