eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_PO_REQ_ACCT2 dependencies on DBMS_SQL

Line 547: v_cursor_id := dbms_sql.open_cursor;

543: ***/
544:
545: l_insert_sql := l_insert_sql || ' where cart_id = :cart_id and cart_line_id = :cart_line_id and distribution_id = :distribution_id ';
546:
547: v_cursor_id := dbms_sql.open_cursor;
548: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
549:
550: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
551:

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

544:
545: l_insert_sql := l_insert_sql || ' where cart_id = :cart_id and cart_line_id = :cart_line_id and distribution_id = :distribution_id ';
546:
547: v_cursor_id := dbms_sql.open_cursor;
548: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
549:
550: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
551:
552: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );

Line 550: l_err_pos := dbms_sql.LAST_ERROR_POSITION;

546:
547: v_cursor_id := dbms_sql.open_cursor;
548: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
549:
550: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
551:
552: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
553: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );

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

548: dbms_sql.parse( v_cursor_id, l_insert_sql, DBMS_SQL.native);
549:
550: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
551:
552: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
553: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );

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

549:
550: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
551:
552: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
553: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );

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

550: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
551:
552: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
553: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );

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

551:
552: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
553: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
559: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );

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

552: dbms_sql.bind_variable(v_cursor_id, ':cart_line_id', v_cart_line_id );
553: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
559: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
560: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );

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

553: dbms_sql.bind_variable(v_cursor_id, ':cart_id', v_cart_id );
554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
559: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
560: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
561: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );

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

554: dbms_sql.bind_variable(v_cursor_id, ':distribution_id', v_distribution_id );
555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
559: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
560: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
561: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
562:

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

555: dbms_sql.bind_variable(v_cursor_id, ':charge_account_id', v_account_id );
556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
559: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
560: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
561: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
562:
563: for ix in 1..l loop

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

556: dbms_sql.bind_variable(v_cursor_id, ':charge_account_num', v_account_num );
557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
559: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
560: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
561: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
562:
563: for ix in 1..l loop
564: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );

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

557: dbms_sql.bind_variable(v_cursor_id, ':allocation_type', v_allocation_type );
558: dbms_sql.bind_variable(v_cursor_id, ':allocation_value', v_allocation_value );
559: dbms_sql.bind_variable(v_cursor_id, ':last_updated_by', l_shopper_id );
560: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
561: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
562:
563: for ix in 1..l loop
564: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
565: end loop;

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

560: dbms_sql.bind_variable(v_cursor_id, ':last_update_date', sysdate );
561: dbms_sql.bind_variable(v_cursor_id, ':last_update_login', l_shopper_id );
562:
563: for ix in 1..l loop
564: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
565: end loop;
566: /*
567: l_call := dbms_sql.open_cursor;
568: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);

Line 567: l_call := dbms_sql.open_cursor;

563: for ix in 1..l loop
564: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
565: end loop;
566: /*
567: l_call := dbms_sql.open_cursor;
568: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
569: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
570: l_ret := dbms_sql.execute(l_call);
571: dbms_sql.close_cursor(l_call);

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

564: dbms_sql.bind_variable(v_cursor_id, ':a' || to_char(ix), v_segment_bind(ix) );
565: end loop;
566: /*
567: l_call := dbms_sql.open_cursor;
568: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
569: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
570: l_ret := dbms_sql.execute(l_call);
571: dbms_sql.close_cursor(l_call);
572: ***/

Line 569: l_err_pos := dbms_sql.LAST_ERROR_POSITION;

565: end loop;
566: /*
567: l_call := dbms_sql.open_cursor;
568: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
569: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
570: l_ret := dbms_sql.execute(l_call);
571: dbms_sql.close_cursor(l_call);
572: ***/
573: l_ret := dbms_sql.execute(v_cursor_id);

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

566: /*
567: l_call := dbms_sql.open_cursor;
568: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
569: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
570: l_ret := dbms_sql.execute(l_call);
571: dbms_sql.close_cursor(l_call);
572: ***/
573: l_ret := dbms_sql.execute(v_cursor_id);
574: dbms_sql.close_cursor(v_cursor_id);

Line 571: dbms_sql.close_cursor(l_call);

567: l_call := dbms_sql.open_cursor;
568: dbms_sql.parse(l_call,l_insert_sql ,dbms_sql.native);
569: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
570: l_ret := dbms_sql.execute(l_call);
571: dbms_sql.close_cursor(l_call);
572: ***/
573: l_ret := dbms_sql.execute(v_cursor_id);
574: dbms_sql.close_cursor(v_cursor_id);
575:

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

569: l_err_pos := dbms_sql.LAST_ERROR_POSITION;
570: l_ret := dbms_sql.execute(l_call);
571: dbms_sql.close_cursor(l_call);
572: ***/
573: l_ret := dbms_sql.execute(v_cursor_id);
574: dbms_sql.close_cursor(v_cursor_id);
575:
576:
577: -- update the other account id based on charge account id

Line 574: dbms_sql.close_cursor(v_cursor_id);

570: l_ret := dbms_sql.execute(l_call);
571: dbms_sql.close_cursor(l_call);
572: ***/
573: l_ret := dbms_sql.execute(v_cursor_id);
574: dbms_sql.close_cursor(v_cursor_id);
575:
576:
577: -- update the other account id based on charge account id
578: icx_req_custom.cart_custom_build_req_account2(v_cart_line_id,

Line 606: if dbms_sql.IS_OPEN(v_cursor_id) then

602: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
603: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
604: icx_util.add_error(l_err_mesg);
605: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,v_line_number,v_cart_line_id);
606: if dbms_sql.IS_OPEN(v_cursor_id) then
607: dbms_sql.close_cursor(v_cursor_id);
608: end if;
609: end;
610:

Line 607: dbms_sql.close_cursor(v_cursor_id);

603: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
604: icx_util.add_error(l_err_mesg);
605: ICX_REQ_SUBMIT.storeerror(v_cart_id, l_err_mesg,v_line_number,v_cart_line_id);
606: if dbms_sql.IS_OPEN(v_cursor_id) then
607: dbms_sql.close_cursor(v_cursor_id);
608: end if;
609: end;
610:
611: