APPS.POS_ASN_REVIEW_PKG dependencies on DBMS_SQL

Line 437: l_cursor := dbms_sql.open_cursor;

433: ':l_result := pos_asn_review_pkg.g_temp_table(:p_index).value' ||
434: to_char(p_col) || '; ' ||
435: ' end;';
436:
437: l_cursor := dbms_sql.open_cursor;
438: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
439: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
440: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
441:

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

434: to_char(p_col) || '; ' ||
435: ' end;';
436:
437: l_cursor := dbms_sql.open_cursor;
438: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
439: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
440: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
441:
442: l_execute := dbms_sql.execute(l_cursor);

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

435: ' end;';
436:
437: l_cursor := dbms_sql.open_cursor;
438: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
439: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
440: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
441:
442: l_execute := dbms_sql.execute(l_cursor);
443: dbms_sql.variable_value(l_cursor, 'l_result', l_result);

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

436:
437: l_cursor := dbms_sql.open_cursor;
438: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
439: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
440: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
441:
442: l_execute := dbms_sql.execute(l_cursor);
443: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
444: dbms_sql.close_cursor(l_cursor);

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

438: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
439: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
440: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
441:
442: l_execute := dbms_sql.execute(l_cursor);
443: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
444: dbms_sql.close_cursor(l_cursor);
445: return l_result;
446:

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

439: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
440: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
441:
442: l_execute := dbms_sql.execute(l_cursor);
443: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
444: dbms_sql.close_cursor(l_cursor);
445: return l_result;
446:
447: ELSE

Line 444: dbms_sql.close_cursor(l_cursor);

440: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
441:
442: l_execute := dbms_sql.execute(l_cursor);
443: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
444: dbms_sql.close_cursor(l_cursor);
445: return l_result;
446:
447: ELSE
448: