APPS.ARP_TBAT_PKG dependencies on DBMS_SQL

Line 198: | dbms_sql.bind_variable |

194: | |
195: | SCOPE - PRIVATE |
196: | |
197: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
198: | dbms_sql.bind_variable |
199: | arp_util.debug |
200: | |
201: | ARGUMENTS : IN: |
202: | p_update_cursor - ID of the update cursor |

Line 238: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

234: /*------------------+
235: | Dummy constants |
236: +------------------*/
237:
238: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
239: AR_TEXT_DUMMY);
240: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
241: AR_NUMBER_DUMMY);
242: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

Line 240: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

236: +------------------*/
237:
238: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
239: AR_TEXT_DUMMY);
240: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
241: AR_NUMBER_DUMMY);
242: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
243: AR_DATE_DUMMY);
244: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

Line 242: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

238: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
239: AR_TEXT_DUMMY);
240: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
241: AR_NUMBER_DUMMY);
242: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
243: AR_DATE_DUMMY);
244: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
245: AR_FLAG_DUMMY);
246:

Line 244: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',

240: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
241: AR_NUMBER_DUMMY);
242: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
243: AR_DATE_DUMMY);
244: dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
245: AR_FLAG_DUMMY);
246:
247: /*------------------+
248: | WHO variables |

Line 251: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',

247: /*------------------+
248: | WHO variables |
249: +------------------*/
250:
251: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
252: pg_user_id);
253:
254: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
255: pg_login_id);

Line 254: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',

250:
251: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
252: pg_user_id);
253:
254: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
255: pg_login_id);
256:
257: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
258: pg_conc_login_id);

Line 257: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',

253:
254: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
255: pg_login_id);
256:
257: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
258: pg_conc_login_id);
259:
260:
261: /*----------------------------------------------+

Line 265: dbms_sql.bind_variable(p_update_cursor, ':batch_id',

261: /*----------------------------------------------+
262: | Bind variables for all columns in the table |
263: +----------------------------------------------*/
264:
265: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
266: p_batch_rec.batch_id);
267: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
268: p_batch_rec.last_update_date);
269: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',

Line 267: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',

263: +----------------------------------------------*/
264:
265: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
266: p_batch_rec.batch_id);
267: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
268: p_batch_rec.last_update_date);
269: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
270: p_batch_rec.last_updated_by);
271: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

Line 269: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',

265: dbms_sql.bind_variable(p_update_cursor, ':batch_id',
266: p_batch_rec.batch_id);
267: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
268: p_batch_rec.last_update_date);
269: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
270: p_batch_rec.last_updated_by);
271: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
272: p_batch_rec.creation_date);
273: dbms_sql.bind_variable(p_update_cursor, ':created_by',

Line 271: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

267: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
268: p_batch_rec.last_update_date);
269: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
270: p_batch_rec.last_updated_by);
271: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
272: p_batch_rec.creation_date);
273: dbms_sql.bind_variable(p_update_cursor, ':created_by',
274: p_batch_rec.created_by);
275: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

Line 273: dbms_sql.bind_variable(p_update_cursor, ':created_by',

269: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
270: p_batch_rec.last_updated_by);
271: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
272: p_batch_rec.creation_date);
273: dbms_sql.bind_variable(p_update_cursor, ':created_by',
274: p_batch_rec.created_by);
275: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
276: p_batch_rec.last_update_login);
277: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',

Line 275: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

271: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
272: p_batch_rec.creation_date);
273: dbms_sql.bind_variable(p_update_cursor, ':created_by',
274: p_batch_rec.created_by);
275: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
276: p_batch_rec.last_update_login);
277: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
278: p_batch_rec.program_application_id);
279: dbms_sql.bind_variable(p_update_cursor, ':program_id',

Line 277: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',

273: dbms_sql.bind_variable(p_update_cursor, ':created_by',
274: p_batch_rec.created_by);
275: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
276: p_batch_rec.last_update_login);
277: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
278: p_batch_rec.program_application_id);
279: dbms_sql.bind_variable(p_update_cursor, ':program_id',
280: p_batch_rec.program_id);
281: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',

Line 279: dbms_sql.bind_variable(p_update_cursor, ':program_id',

275: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
276: p_batch_rec.last_update_login);
277: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
278: p_batch_rec.program_application_id);
279: dbms_sql.bind_variable(p_update_cursor, ':program_id',
280: p_batch_rec.program_id);
281: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
282: p_batch_rec.program_update_date);
283: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',

Line 281: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',

277: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
278: p_batch_rec.program_application_id);
279: dbms_sql.bind_variable(p_update_cursor, ':program_id',
280: p_batch_rec.program_id);
281: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
282: p_batch_rec.program_update_date);
283: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
284: p_batch_rec.set_of_books_id);
285: dbms_sql.bind_variable(p_update_cursor, ':name',

Line 283: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',

279: dbms_sql.bind_variable(p_update_cursor, ':program_id',
280: p_batch_rec.program_id);
281: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
282: p_batch_rec.program_update_date);
283: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
284: p_batch_rec.set_of_books_id);
285: dbms_sql.bind_variable(p_update_cursor, ':name',
286: p_batch_rec.name);
287: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',

Line 285: dbms_sql.bind_variable(p_update_cursor, ':name',

281: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
282: p_batch_rec.program_update_date);
283: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
284: p_batch_rec.set_of_books_id);
285: dbms_sql.bind_variable(p_update_cursor, ':name',
286: p_batch_rec.name);
287: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
288: p_batch_rec.batch_source_id);
289: dbms_sql.bind_variable(p_update_cursor, ':batch_date',

Line 287: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',

283: dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
284: p_batch_rec.set_of_books_id);
285: dbms_sql.bind_variable(p_update_cursor, ':name',
286: p_batch_rec.name);
287: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
288: p_batch_rec.batch_source_id);
289: dbms_sql.bind_variable(p_update_cursor, ':batch_date',
290: p_batch_rec.batch_date);
291: dbms_sql.bind_variable(p_update_cursor, ':gl_date',

Line 289: dbms_sql.bind_variable(p_update_cursor, ':batch_date',

285: dbms_sql.bind_variable(p_update_cursor, ':name',
286: p_batch_rec.name);
287: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
288: p_batch_rec.batch_source_id);
289: dbms_sql.bind_variable(p_update_cursor, ':batch_date',
290: p_batch_rec.batch_date);
291: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
292: p_batch_rec.gl_date);
293: dbms_sql.bind_variable(p_update_cursor, ':status',

Line 291: dbms_sql.bind_variable(p_update_cursor, ':gl_date',

287: dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
288: p_batch_rec.batch_source_id);
289: dbms_sql.bind_variable(p_update_cursor, ':batch_date',
290: p_batch_rec.batch_date);
291: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
292: p_batch_rec.gl_date);
293: dbms_sql.bind_variable(p_update_cursor, ':status',
294: p_batch_rec.status);
295: dbms_sql.bind_variable(p_update_cursor, ':type',

Line 293: dbms_sql.bind_variable(p_update_cursor, ':status',

289: dbms_sql.bind_variable(p_update_cursor, ':batch_date',
290: p_batch_rec.batch_date);
291: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
292: p_batch_rec.gl_date);
293: dbms_sql.bind_variable(p_update_cursor, ':status',
294: p_batch_rec.status);
295: dbms_sql.bind_variable(p_update_cursor, ':type',
296: p_batch_rec.type);
297: dbms_sql.bind_variable(p_update_cursor, ':control_count',

Line 295: dbms_sql.bind_variable(p_update_cursor, ':type',

291: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
292: p_batch_rec.gl_date);
293: dbms_sql.bind_variable(p_update_cursor, ':status',
294: p_batch_rec.status);
295: dbms_sql.bind_variable(p_update_cursor, ':type',
296: p_batch_rec.type);
297: dbms_sql.bind_variable(p_update_cursor, ':control_count',
298: p_batch_rec.control_count);
299: dbms_sql.bind_variable(p_update_cursor, ':control_amount',

Line 297: dbms_sql.bind_variable(p_update_cursor, ':control_count',

293: dbms_sql.bind_variable(p_update_cursor, ':status',
294: p_batch_rec.status);
295: dbms_sql.bind_variable(p_update_cursor, ':type',
296: p_batch_rec.type);
297: dbms_sql.bind_variable(p_update_cursor, ':control_count',
298: p_batch_rec.control_count);
299: dbms_sql.bind_variable(p_update_cursor, ':control_amount',
300: p_batch_rec.control_amount);
301: dbms_sql.bind_variable(p_update_cursor, ':comments',

Line 299: dbms_sql.bind_variable(p_update_cursor, ':control_amount',

295: dbms_sql.bind_variable(p_update_cursor, ':type',
296: p_batch_rec.type);
297: dbms_sql.bind_variable(p_update_cursor, ':control_count',
298: p_batch_rec.control_count);
299: dbms_sql.bind_variable(p_update_cursor, ':control_amount',
300: p_batch_rec.control_amount);
301: dbms_sql.bind_variable(p_update_cursor, ':comments',
302: p_batch_rec.comments);
303: dbms_sql.bind_variable(p_update_cursor, ':currency_code',

Line 301: dbms_sql.bind_variable(p_update_cursor, ':comments',

297: dbms_sql.bind_variable(p_update_cursor, ':control_count',
298: p_batch_rec.control_count);
299: dbms_sql.bind_variable(p_update_cursor, ':control_amount',
300: p_batch_rec.control_amount);
301: dbms_sql.bind_variable(p_update_cursor, ':comments',
302: p_batch_rec.comments);
303: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
304: p_batch_rec.currency_code);
305: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',

Line 303: dbms_sql.bind_variable(p_update_cursor, ':currency_code',

299: dbms_sql.bind_variable(p_update_cursor, ':control_amount',
300: p_batch_rec.control_amount);
301: dbms_sql.bind_variable(p_update_cursor, ':comments',
302: p_batch_rec.comments);
303: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
304: p_batch_rec.currency_code);
305: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
306: p_batch_rec.exchange_rate_type);
307: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',

Line 305: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',

301: dbms_sql.bind_variable(p_update_cursor, ':comments',
302: p_batch_rec.comments);
303: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
304: p_batch_rec.currency_code);
305: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
306: p_batch_rec.exchange_rate_type);
307: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
308: p_batch_rec.exchange_date);
309: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',

Line 307: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',

303: dbms_sql.bind_variable(p_update_cursor, ':currency_code',
304: p_batch_rec.currency_code);
305: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
306: p_batch_rec.exchange_rate_type);
307: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
308: p_batch_rec.exchange_date);
309: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
310: p_batch_rec.exchange_rate);
311: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',

Line 309: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',

305: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
306: p_batch_rec.exchange_rate_type);
307: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
308: p_batch_rec.exchange_date);
309: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
310: p_batch_rec.exchange_rate);
311: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
312: p_batch_rec.purged_children_flag);
313: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

Line 311: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',

307: dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
308: p_batch_rec.exchange_date);
309: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
310: p_batch_rec.exchange_rate);
311: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
312: p_batch_rec.purged_children_flag);
313: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
314: p_batch_rec.attribute_category);
315: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

Line 313: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

309: dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
310: p_batch_rec.exchange_rate);
311: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
312: p_batch_rec.purged_children_flag);
313: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
314: p_batch_rec.attribute_category);
315: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
316: p_batch_rec.attribute1);
317: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

Line 315: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

311: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
312: p_batch_rec.purged_children_flag);
313: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
314: p_batch_rec.attribute_category);
315: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
316: p_batch_rec.attribute1);
317: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
318: p_batch_rec.attribute2);
319: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

Line 317: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

313: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
314: p_batch_rec.attribute_category);
315: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
316: p_batch_rec.attribute1);
317: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
318: p_batch_rec.attribute2);
319: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
320: p_batch_rec.attribute3);
321: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

Line 319: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

315: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
316: p_batch_rec.attribute1);
317: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
318: p_batch_rec.attribute2);
319: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
320: p_batch_rec.attribute3);
321: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
322: p_batch_rec.attribute4);
323: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

Line 321: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

317: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
318: p_batch_rec.attribute2);
319: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
320: p_batch_rec.attribute3);
321: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
322: p_batch_rec.attribute4);
323: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
324: p_batch_rec.attribute5);
325: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

Line 323: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

319: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
320: p_batch_rec.attribute3);
321: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
322: p_batch_rec.attribute4);
323: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
324: p_batch_rec.attribute5);
325: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
326: p_batch_rec.attribute6);
327: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

Line 325: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

321: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
322: p_batch_rec.attribute4);
323: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
324: p_batch_rec.attribute5);
325: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
326: p_batch_rec.attribute6);
327: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
328: p_batch_rec.attribute7);
329: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

Line 327: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

323: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
324: p_batch_rec.attribute5);
325: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
326: p_batch_rec.attribute6);
327: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
328: p_batch_rec.attribute7);
329: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
330: p_batch_rec.attribute8);
331: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

Line 329: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

325: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
326: p_batch_rec.attribute6);
327: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
328: p_batch_rec.attribute7);
329: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
330: p_batch_rec.attribute8);
331: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
332: p_batch_rec.attribute9);
333: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

Line 331: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

327: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
328: p_batch_rec.attribute7);
329: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
330: p_batch_rec.attribute8);
331: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
332: p_batch_rec.attribute9);
333: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
334: p_batch_rec.attribute10);
335: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

Line 333: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

329: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
330: p_batch_rec.attribute8);
331: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
332: p_batch_rec.attribute9);
333: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
334: p_batch_rec.attribute10);
335: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
336: p_batch_rec.attribute11);
337: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

Line 335: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

331: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
332: p_batch_rec.attribute9);
333: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
334: p_batch_rec.attribute10);
335: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
336: p_batch_rec.attribute11);
337: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
338: p_batch_rec.attribute12);
339: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

Line 337: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

333: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
334: p_batch_rec.attribute10);
335: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
336: p_batch_rec.attribute11);
337: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
338: p_batch_rec.attribute12);
339: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
340: p_batch_rec.attribute13);
341: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

Line 339: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

335: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
336: p_batch_rec.attribute11);
337: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
338: p_batch_rec.attribute12);
339: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
340: p_batch_rec.attribute13);
341: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
342: p_batch_rec.attribute14);
343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

Line 341: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

337: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
338: p_batch_rec.attribute12);
339: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
340: p_batch_rec.attribute13);
341: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
342: p_batch_rec.attribute14);
343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
344: p_batch_rec.attribute15);
345:

Line 343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

339: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
340: p_batch_rec.attribute13);
341: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
342: p_batch_rec.attribute14);
343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
344: p_batch_rec.attribute15);
345:
346: dbms_sql.bind_variable(p_update_cursor, ':issue_date',
347: p_batch_rec.issue_date);

Line 346: dbms_sql.bind_variable(p_update_cursor, ':issue_date',

342: p_batch_rec.attribute14);
343: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
344: p_batch_rec.attribute15);
345:
346: dbms_sql.bind_variable(p_update_cursor, ':issue_date',
347: p_batch_rec.issue_date);
348: dbms_sql.bind_variable(p_update_cursor, ':maturity_date',
349: p_batch_rec.maturity_date);
350: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',

Line 348: dbms_sql.bind_variable(p_update_cursor, ':maturity_date',

344: p_batch_rec.attribute15);
345:
346: dbms_sql.bind_variable(p_update_cursor, ':issue_date',
347: p_batch_rec.issue_date);
348: dbms_sql.bind_variable(p_update_cursor, ':maturity_date',
349: p_batch_rec.maturity_date);
350: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
351: p_batch_rec.special_instructions);
352: dbms_sql.bind_variable(p_update_cursor, ':batch_process_status',

Line 350: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',

346: dbms_sql.bind_variable(p_update_cursor, ':issue_date',
347: p_batch_rec.issue_date);
348: dbms_sql.bind_variable(p_update_cursor, ':maturity_date',
349: p_batch_rec.maturity_date);
350: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
351: p_batch_rec.special_instructions);
352: dbms_sql.bind_variable(p_update_cursor, ':batch_process_status',
353: p_batch_rec.batch_process_status);
354: dbms_sql.bind_variable(p_update_cursor, ':selection_criteria_id',

Line 352: dbms_sql.bind_variable(p_update_cursor, ':batch_process_status',

348: dbms_sql.bind_variable(p_update_cursor, ':maturity_date',
349: p_batch_rec.maturity_date);
350: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
351: p_batch_rec.special_instructions);
352: dbms_sql.bind_variable(p_update_cursor, ':batch_process_status',
353: p_batch_rec.batch_process_status);
354: dbms_sql.bind_variable(p_update_cursor, ':selection_criteria_id',
355: p_batch_rec.selection_criteria_id);
356: dbms_sql.bind_variable(p_update_cursor, ':request_id',

Line 354: dbms_sql.bind_variable(p_update_cursor, ':selection_criteria_id',

350: dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
351: p_batch_rec.special_instructions);
352: dbms_sql.bind_variable(p_update_cursor, ':batch_process_status',
353: p_batch_rec.batch_process_status);
354: dbms_sql.bind_variable(p_update_cursor, ':selection_criteria_id',
355: p_batch_rec.selection_criteria_id);
356: dbms_sql.bind_variable(p_update_cursor, ':request_id',
357: p_batch_rec.request_id);
358:

Line 356: dbms_sql.bind_variable(p_update_cursor, ':request_id',

352: dbms_sql.bind_variable(p_update_cursor, ':batch_process_status',
353: p_batch_rec.batch_process_status);
354: dbms_sql.bind_variable(p_update_cursor, ':selection_criteria_id',
355: p_batch_rec.selection_criteria_id);
356: dbms_sql.bind_variable(p_update_cursor, ':request_id',
357: p_batch_rec.request_id);
358:
359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');
360:

Line 625: | dbms_sql.open_cursor |

621: | SCOPE - PRIVATE |
622: | |
623: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
624: | arp_util.debug |
625: | dbms_sql.open_cursor |
626: | dbms_sql.parse |
627: | dbms_sql.execute |
628: | dbms_sql.close_cursor |
629: | |

Line 626: | dbms_sql.parse |

622: | |
623: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
624: | arp_util.debug |
625: | dbms_sql.open_cursor |
626: | dbms_sql.parse |
627: | dbms_sql.execute |
628: | dbms_sql.close_cursor |
629: | |
630: | ARGUMENTS : IN: |

Line 627: | dbms_sql.execute |

623: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
624: | arp_util.debug |
625: | dbms_sql.open_cursor |
626: | dbms_sql.parse |
627: | dbms_sql.execute |
628: | dbms_sql.close_cursor |
629: | |
630: | ARGUMENTS : IN: |
631: | p_update_cursor - identifies the cursor to use |

Line 628: | dbms_sql.close_cursor |

624: | arp_util.debug |
625: | dbms_sql.open_cursor |
626: | dbms_sql.parse |
627: | dbms_sql.execute |
628: | dbms_sql.close_cursor |
629: | |
630: | ARGUMENTS : IN: |
631: | p_update_cursor - identifies the cursor to use |
632: | p_where_clause - identifies which rows to update |

Line 655: ra_batch_array dbms_sql.number_table;

651:
652: l_count number;
653: l_update_statement varchar2(10000);
654: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
655: ra_batch_array dbms_sql.number_table;
656:
657: BEGIN
658: arp_util.debug('arp_tbat_pkg.generic_update()+');
659:

Line 670: p_update_cursor := dbms_sql.open_cursor;

666:
667: IF (p_update_cursor is null)
668: THEN
669:
670: p_update_cursor := dbms_sql.open_cursor;
671:
672: /*---------------------------------+
673: | Construct the update statement |
674: +---------------------------------*/

Line 689: dbms_sql.parse(p_update_cursor,

685: /*-----------------------------------------------+
686: | Parse, bind, execute and close the statement |
687: +-----------------------------------------------*/
688:
689: dbms_sql.parse(p_update_cursor,
690: l_update_statement,
691: dbms_sql.v7);
692:
693: /*---------------------------+

Line 691: dbms_sql.v7);

687: +-----------------------------------------------*/
688:
689: dbms_sql.parse(p_update_cursor,
690: l_update_statement,
691: dbms_sql.v7);
692:
693: /*---------------------------+
694: | Bind output variable |
695: +---------------------------*/

Line 696: dbms_sql.bind_array(p_update_cursor,':ra_batch_key_value',

692:
693: /*---------------------------+
694: | Bind output variable |
695: +---------------------------*/
696: dbms_sql.bind_array(p_update_cursor,':ra_batch_key_value',
697: ra_batch_array);
698:
699:
700: END IF;

Line 708: dbms_sql.bind_variable(p_update_cursor, ':where_1',

704: /*-----------------------------------------+
705: | Bind the variables in the where clause |
706: +-----------------------------------------*/
707:
708: dbms_sql.bind_variable(p_update_cursor, ':where_1',
709: p_where1);
710:
711: l_count := dbms_sql.execute(p_update_cursor);
712:

Line 711: l_count := dbms_sql.execute(p_update_cursor);

707:
708: dbms_sql.bind_variable(p_update_cursor, ':where_1',
709: p_where1);
710:
711: l_count := dbms_sql.execute(p_update_cursor);
712:
713: arp_util.debug( to_char(l_count) || ' rows updated');
714:
715: /*------------------------------------------+

Line 719: dbms_sql.variable_value( p_update_cursor, ':ra_batch_key_value',

715: /*------------------------------------------+
716: | get RETURNING COLUMN into OUT NOCOPY bind array |
717: +------------------------------------------*/
718:
719: dbms_sql.variable_value( p_update_cursor, ':ra_batch_key_value',
720: ra_batch_array);
721:
722:
723: /*------------------------------------------------------------+

Line 751: to_char(dbms_sql.last_error_position));

747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;
753: END;
754:
755: