APPS.POS_ASN dependencies on DBMS_SQL

Line 1657: l_cursor := dbms_sql.open_cursor;

1653: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
1654: to_char(p_col) || '; ' ||
1655: ' end;';
1656:
1657: l_cursor := dbms_sql.open_cursor;
1658: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1659: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1660: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1661:

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

1654: to_char(p_col) || '; ' ||
1655: ' end;';
1656:
1657: l_cursor := dbms_sql.open_cursor;
1658: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1659: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1660: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1661:
1662: l_execute := dbms_sql.execute(l_cursor);

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

1655: ' end;';
1656:
1657: l_cursor := dbms_sql.open_cursor;
1658: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1659: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1660: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1661:
1662: l_execute := dbms_sql.execute(l_cursor);
1663: dbms_sql.variable_value(l_cursor, 'l_result', l_result);

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

1656:
1657: l_cursor := dbms_sql.open_cursor;
1658: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1659: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1660: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1661:
1662: l_execute := dbms_sql.execute(l_cursor);
1663: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1664: dbms_sql.close_cursor(l_cursor);

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

1658: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1659: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1660: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1661:
1662: l_execute := dbms_sql.execute(l_cursor);
1663: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1664: dbms_sql.close_cursor(l_cursor);
1665: return l_result;
1666:

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

1659: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1660: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1661:
1662: l_execute := dbms_sql.execute(l_cursor);
1663: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1664: dbms_sql.close_cursor(l_cursor);
1665: return l_result;
1666:
1667: ELSE

Line 1664: dbms_sql.close_cursor(l_cursor);

1660: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1661:
1662: l_execute := dbms_sql.execute(l_cursor);
1663: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1664: dbms_sql.close_cursor(l_cursor);
1665: return l_result;
1666:
1667: ELSE
1668: