APPS.POS_ASN_SEARCH_PKG dependencies on DBMS_SQL

Line 857: v_cursor_id := DBMS_SQL.open_cursor;

853: BEGIN
854:
855: delete pos_asn_search_result where session_id = p_session_id;
856:
857: v_cursor_id := DBMS_SQL.open_cursor;
858:
859: v_stmt :=
860: 'insert into pos_asn_search_result select ' || to_char(p_session_id) || ',
861: PO_HEADER_ID,

Line 890: DBMS_SQL.parse(v_cursor_id, v_stmt, dbms_sql.native);

886: CATEGORY
887: from POS_ASN_PO_SHIPMENTS_V
888: where ' || p_where_clause;
889:
890: DBMS_SQL.parse(v_cursor_id, v_stmt, dbms_sql.native);
891:
892: result := DBMS_SQL.execute(v_cursor_id);
893:
894: DBMS_SQL.close_cursor(v_cursor_id);

Line 892: result := DBMS_SQL.execute(v_cursor_id);

888: where ' || p_where_clause;
889:
890: DBMS_SQL.parse(v_cursor_id, v_stmt, dbms_sql.native);
891:
892: result := DBMS_SQL.execute(v_cursor_id);
893:
894: DBMS_SQL.close_cursor(v_cursor_id);
895:
896: commit;

Line 894: DBMS_SQL.close_cursor(v_cursor_id);

890: DBMS_SQL.parse(v_cursor_id, v_stmt, dbms_sql.native);
891:
892: result := DBMS_SQL.execute(v_cursor_id);
893:
894: DBMS_SQL.close_cursor(v_cursor_id);
895:
896: commit;
897:
898: END UpdateResultSet;

Line 1624: l_cursor := dbms_sql.open_cursor;

1620: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
1621: to_char(p_col) || '; ' ||
1622: ' end;';
1623:
1624: l_cursor := dbms_sql.open_cursor;
1625: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1626: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1627: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1628:

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

1621: to_char(p_col) || '; ' ||
1622: ' end;';
1623:
1624: l_cursor := dbms_sql.open_cursor;
1625: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1626: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1627: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1628:
1629: l_execute := dbms_sql.execute(l_cursor);

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

1622: ' end;';
1623:
1624: l_cursor := dbms_sql.open_cursor;
1625: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1626: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1627: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1628:
1629: l_execute := dbms_sql.execute(l_cursor);
1630: dbms_sql.variable_value(l_cursor, 'l_result', l_result);

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

1623:
1624: l_cursor := dbms_sql.open_cursor;
1625: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1626: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1627: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1628:
1629: l_execute := dbms_sql.execute(l_cursor);
1630: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1631: dbms_sql.close_cursor(l_cursor);

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

1625: dbms_sql.parse(l_cursor, sql_statement, dbms_sql.v7);
1626: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1627: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1628:
1629: l_execute := dbms_sql.execute(l_cursor);
1630: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1631: dbms_sql.close_cursor(l_cursor);
1632: return l_result;
1633:

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

1626: dbms_sql.bind_variable(l_cursor, 'l_result', l_result, 2000);
1627: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1628:
1629: l_execute := dbms_sql.execute(l_cursor);
1630: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1631: dbms_sql.close_cursor(l_cursor);
1632: return l_result;
1633:
1634: ELSE

Line 1631: dbms_sql.close_cursor(l_cursor);

1627: dbms_sql.bind_variable(l_cursor, 'p_index', p_index);
1628:
1629: l_execute := dbms_sql.execute(l_cursor);
1630: dbms_sql.variable_value(l_cursor, 'l_result', l_result);
1631: dbms_sql.close_cursor(l_cursor);
1632: return l_result;
1633:
1634: ELSE
1635: