APPS.FA_MASSADD_SPECIAL_PKG dependencies on DBMS_SQL

Line 217: l_rowid_tbl dbms_sql.varchar2_table;

213: TYPE char_tab IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
214: TYPE rowid_tab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
215:
216: l_rowid varchar2(30);
217: l_rowid_tbl dbms_sql.varchar2_table;
218: l_upd_rowid char_tab;
219:
220: -- bulk operations
221: i number;

Line 270: l_cursor_id := dbms_sql.open_cursor;

266: end if;
267:
268: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
269:
270: l_cursor_id := dbms_sql.open_cursor;
271:
272: l_sql_statement := 'select row_id ' ||
273: ' from fa_mass_additions_v ' ||
274: p_where_clause ||

Line 277: dbms_sql.parse(l_cursor_id, l_sql_statement, DBMS_SQL.NATIVE);

273: ' from fa_mass_additions_v ' ||
274: p_where_clause ||
275: ' and posting_status not in (''POSTED'', ''MERGED'', ''SPLIT'')';
276:
277: dbms_sql.parse(l_cursor_id, l_sql_statement, DBMS_SQL.NATIVE);
278: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);
279:
280: l_ret_val := DBMS_SQL.EXECUTE(l_cursor_id);
281:

Line 278: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);

274: p_where_clause ||
275: ' and posting_status not in (''POSTED'', ''MERGED'', ''SPLIT'')';
276:
277: dbms_sql.parse(l_cursor_id, l_sql_statement, DBMS_SQL.NATIVE);
278: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);
279:
280: l_ret_val := DBMS_SQL.EXECUTE(l_cursor_id);
281:
282: loop

Line 280: l_ret_val := DBMS_SQL.EXECUTE(l_cursor_id);

276:
277: dbms_sql.parse(l_cursor_id, l_sql_statement, DBMS_SQL.NATIVE);
278: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);
279:
280: l_ret_val := DBMS_SQL.EXECUTE(l_cursor_id);
281:
282: loop
283:
284: -- reset the array to 1

Line 285: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);

281:
282: loop
283:
284: -- reset the array to 1
285: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);
286:
287: l_num_rows := dbms_sql.fetch_rows(l_cursor_id);
288: dbms_sql.column_value(l_cursor_id, 1, l_rowid_tbl);
289:

Line 287: l_num_rows := dbms_sql.fetch_rows(l_cursor_id);

283:
284: -- reset the array to 1
285: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);
286:
287: l_num_rows := dbms_sql.fetch_rows(l_cursor_id);
288: dbms_sql.column_value(l_cursor_id, 1, l_rowid_tbl);
289:
290: if (l_num_rows = 0) then
291: exit;

Line 288: dbms_sql.column_value(l_cursor_id, 1, l_rowid_tbl);

284: -- reset the array to 1
285: dbms_sql.define_array(l_cursor_id, 1, l_rowid_tbl, l_batch_size, 1);
286:
287: l_num_rows := dbms_sql.fetch_rows(l_cursor_id);
288: dbms_sql.column_value(l_cursor_id, 1, l_rowid_tbl);
289:
290: if (l_num_rows = 0) then
291: exit;
292: end if;

Line 378: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

374: exit when l_num_rows < l_batch_size;
375:
376: end loop;
377:
378: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
379: commit;
380:
381: -- returning success here even though individual lines may have failed.
382: if (x_failure_count = 0) then