APPS.ICX_REQ_ACCT2 dependencies on DBMS_SQL

Line 296: v_cursor_id := dbms_sql.open_cursor;

292:
293: l_insert_sql := l_insert_sql || ')';
294:
295:
296: v_cursor_id := dbms_sql.open_cursor;
297: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
298:
299: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
300:

Line 297: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);

293: l_insert_sql := l_insert_sql || ')';
294:
295:
296: v_cursor_id := dbms_sql.open_cursor;
297: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
298:
299: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
300:
301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );

Line 299: l_err_pos := dbms_sql.LAST_ERROR_POSITION;

295:
296: v_cursor_id := dbms_sql.open_cursor;
297: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
298:
299: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
300:
301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );

Line 301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );

297: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
298:
299: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
300:
301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );
304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );

Line 302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );

298:
299: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
300:
301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );
304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );

Line 303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );

299: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
300:
301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );
304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );

Line 304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );

300:
301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );
304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );

Line 305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );

301: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );
304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );

Line 306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );

302: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );
304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );

Line 307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );

303: dbms_sql.bind_variable(v_cursor_id, ':distribution_num', l_dist_num );
304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );

Line 308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );

304: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );
312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );

Line 309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );

305: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );
312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );
313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );

Line 310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );

306: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', l_alloc_type );
307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );
312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );
313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );
314: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );

Line 311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );

307: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', l_alloc_percent );
308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );
312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );
313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );
314: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
315:

Line 312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );

308: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );
312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );
313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );
314: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
315:
316: for ix in 1..l_num_ak_cols loop

Line 313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );

309: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );
312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );
313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );
314: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
315:
316: for ix in 1..l_num_ak_cols loop
317: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );

Line 314: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );

310: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
311: dbms_sql.bind_variable(v_cursor_id, ':creation_date', sysdate );
312: dbms_sql.bind_variable(v_cursor_id, ':created_by', l_shopper_id );
313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );
314: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
315:
316: for ix in 1..l_num_ak_cols loop
317: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
318:

Line 317: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );

313: dbms_sql.bind_variable(v_cursor_id, ':org_id', v_oo_id );
314: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
315:
316: for ix in 1..l_num_ak_cols loop
317: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
318:
319: end loop;
320:
321: -- l_call := dbms_sql.open_cursor;

Line 321: -- l_call := dbms_sql.open_cursor;

317: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
318:
319: end loop;
320:
321: -- l_call := dbms_sql.open_cursor;
322: -- dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
323: -- l_ret := dbms_sql.execute(l_call);
324: -- dbms_sql.close_cursor(l_call);
325: l_ret := dbms_sql.execute(v_cursor_id);

Line 322: -- dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);

318:
319: end loop;
320:
321: -- l_call := dbms_sql.open_cursor;
322: -- dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
323: -- l_ret := dbms_sql.execute(l_call);
324: -- dbms_sql.close_cursor(l_call);
325: l_ret := dbms_sql.execute(v_cursor_id);
326: dbms_sql.close_cursor(v_cursor_id);

Line 323: -- l_ret := dbms_sql.execute(l_call);

319: end loop;
320:
321: -- l_call := dbms_sql.open_cursor;
322: -- dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
323: -- l_ret := dbms_sql.execute(l_call);
324: -- dbms_sql.close_cursor(l_call);
325: l_ret := dbms_sql.execute(v_cursor_id);
326: dbms_sql.close_cursor(v_cursor_id);
327:

Line 324: -- dbms_sql.close_cursor(l_call);

320:
321: -- l_call := dbms_sql.open_cursor;
322: -- dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
323: -- l_ret := dbms_sql.execute(l_call);
324: -- dbms_sql.close_cursor(l_call);
325: l_ret := dbms_sql.execute(v_cursor_id);
326: dbms_sql.close_cursor(v_cursor_id);
327:
328:

Line 325: l_ret := dbms_sql.execute(v_cursor_id);

321: -- l_call := dbms_sql.open_cursor;
322: -- dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
323: -- l_ret := dbms_sql.execute(l_call);
324: -- dbms_sql.close_cursor(l_call);
325: l_ret := dbms_sql.execute(v_cursor_id);
326: dbms_sql.close_cursor(v_cursor_id);
327:
328:
329:

Line 326: dbms_sql.close_cursor(v_cursor_id);

322: -- dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
323: -- l_ret := dbms_sql.execute(l_call);
324: -- dbms_sql.close_cursor(l_call);
325: l_ret := dbms_sql.execute(v_cursor_id);
326: dbms_sql.close_cursor(v_cursor_id);
327:
328:
329:
330:

Line 358: if dbms_sql.IS_OPEN(v_cursor_id) then

354: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
355: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || l_dist_num || ') ' || l_err_mesg;
356: icx_util.add_error(l_err_mesg);
357: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,l_dist_num,v_cart_line_id);
358: if dbms_sql.IS_OPEN(v_cursor_id) then
359: dbms_sql.close_cursor(v_cursor_id);
360: end if;
361:
362: end;

Line 359: dbms_sql.close_cursor(v_cursor_id);

355: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || l_dist_num || ') ' || l_err_mesg;
356: icx_util.add_error(l_err_mesg);
357: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,l_dist_num,v_cart_line_id);
358: if dbms_sql.IS_OPEN(v_cursor_id) then
359: dbms_sql.close_cursor(v_cursor_id);
360: end if;
361:
362: end;
363:

Line 500: v_cursor_id := dbms_sql.open_cursor;

496: l_insert_sql := l_insert_sql || ' where cart_id = :cart_id and cart_line_id = :cart_line_id and distribution_id = :distribution_id ';
497:
498:
499:
500: v_cursor_id := dbms_sql.open_cursor;
501: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
502:
503: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
504:

Line 501: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);

497:
498:
499:
500: v_cursor_id := dbms_sql.open_cursor;
501: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
502:
503: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
504:
505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );

Line 503: l_err_pos := dbms_sql.LAST_ERROR_POSITION;

499:
500: v_cursor_id := dbms_sql.open_cursor;
501: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
502:
503: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
504:
505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );

Line 505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );

501: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
502:
503: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
504:
505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );

Line 506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );

502:
503: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
504:
505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );

Line 507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );

503: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
504:
505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );

Line 508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );

504:
505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );

Line 509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );

505: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );

Line 510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );

506: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
514: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );

Line 511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );

507: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
514: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
515:

Line 512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );

508: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
514: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
515:
516: for ix in 1..l loop

Line 513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );

509: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
514: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
515:
516: for ix in 1..l loop
517: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );

Line 514: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );

510: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
511: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
512: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
514: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
515:
516: for ix in 1..l loop
517: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
518: end loop;

Line 517: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );

513: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
514: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
515:
516: for ix in 1..l loop
517: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
518: end loop;
519: /*
520: l_call := dbms_sql.open_cursor;
521: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);

Line 520: l_call := dbms_sql.open_cursor;

516: for ix in 1..l loop
517: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
518: end loop;
519: /*
520: l_call := dbms_sql.open_cursor;
521: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
522: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
523: l_ret := dbms_sql.execute(l_call);
524: dbms_sql.close_cursor(l_call);

Line 521: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);

517: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
518: end loop;
519: /*
520: l_call := dbms_sql.open_cursor;
521: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
522: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
523: l_ret := dbms_sql.execute(l_call);
524: dbms_sql.close_cursor(l_call);
525: ***/

Line 522: l_err_pos := dbms_sql.LAST_ERROR_POSITION;

518: end loop;
519: /*
520: l_call := dbms_sql.open_cursor;
521: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
522: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
523: l_ret := dbms_sql.execute(l_call);
524: dbms_sql.close_cursor(l_call);
525: ***/
526: l_ret := dbms_sql.execute(v_cursor_id);

Line 523: l_ret := dbms_sql.execute(l_call);

519: /*
520: l_call := dbms_sql.open_cursor;
521: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
522: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
523: l_ret := dbms_sql.execute(l_call);
524: dbms_sql.close_cursor(l_call);
525: ***/
526: l_ret := dbms_sql.execute(v_cursor_id);
527: dbms_sql.close_cursor(v_cursor_id);

Line 524: dbms_sql.close_cursor(l_call);

520: l_call := dbms_sql.open_cursor;
521: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
522: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
523: l_ret := dbms_sql.execute(l_call);
524: dbms_sql.close_cursor(l_call);
525: ***/
526: l_ret := dbms_sql.execute(v_cursor_id);
527: dbms_sql.close_cursor(v_cursor_id);
528:

Line 526: l_ret := dbms_sql.execute(v_cursor_id);

522: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
523: l_ret := dbms_sql.execute(l_call);
524: dbms_sql.close_cursor(l_call);
525: ***/
526: l_ret := dbms_sql.execute(v_cursor_id);
527: dbms_sql.close_cursor(v_cursor_id);
528:
529: -- update the other account id based on charge account id
530: icx_req_custom.cart_custom_build_req_account2(v_cart_line_id,

Line 527: dbms_sql.close_cursor(v_cursor_id);

523: l_ret := dbms_sql.execute(l_call);
524: dbms_sql.close_cursor(l_call);
525: ***/
526: l_ret := dbms_sql.execute(v_cursor_id);
527: dbms_sql.close_cursor(v_cursor_id);
528:
529: -- update the other account id based on charge account id
530: icx_req_custom.cart_custom_build_req_account2(v_cart_line_id,
531: v_variance_acct_id,

Line 558: if dbms_sql.IS_OPEN(v_cursor_id) then

554: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
555: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
556: icx_util.add_error(l_err_mesg);
557: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,v_line_number,v_cart_line_id);
558: if dbms_sql.IS_OPEN(v_cursor_id) then
559: dbms_sql.close_cursor(v_cursor_id);
560: end if;
561: end;
562:

Line 559: dbms_sql.close_cursor(v_cursor_id);

555: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
556: icx_util.add_error(l_err_mesg);
557: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,v_line_number,v_cart_line_id);
558: if dbms_sql.IS_OPEN(v_cursor_id) then
559: dbms_sql.close_cursor(v_cursor_id);
560: end if;
561: end;
562:
563: