APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 83: l_rebuild_job_name mtl_transactions_interface.rebuild_job_name%type;

79: x_error_mssg1 Varchar2(200);
80: l_eam_one_step_mat_issue varchar2(1);
81: l_rebuild_item_id number := null;
82: l_rebuild_activity_id number := null;
83: l_rebuild_job_name mtl_transactions_interface.rebuild_job_name%type;
84: l_rebuild_job_temp Number;
85: l_prefix wip_eam_parameters.easy_work_order_prefix%type;
86: l_lot_number Varchar2(80);
87: l_fm_serial_number Varchar2(30);

Line 554: update mtl_transactions_interface

550: end if;
551: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
552: 'Inserting rebuild item id: '|| l_rebuild_item_id);
553: end if;
554: update mtl_transactions_interface
555: set rebuild_item_id=l_rebuild_item_id
556: where transaction_interface_id= x_tmp_id;
557: end;
558: end if;

Line 563: update mtl_transactions_interface

559:
560: if (p_rebuild_serial_number is not null) then
561: begin
562: --dbms_output.put_line('p_rebuild_serial_number ' || p_rebuild_serial_number);
563: update mtl_transactions_interface
564: set rebuild_serial_number=p_rebuild_serial_number
565: where transaction_interface_id= x_tmp_id;
566: end;
567: end if;

Line 582: update mtl_transactions_interface

578: end if;
579: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
580: 'Inserting rebuild activity id: '|| l_rebuild_activity_id);
581: end if;
582: update mtl_transactions_interface
583: set rebuild_activity_id=l_rebuild_activity_id
584: where transaction_interface_id= x_tmp_id;
585: end;
586: end if;

Line 607: update mtl_transactions_interface

603:
604: p_rebuild_job_name := l_rebuild_job_name;
605:
606: --dbms_output.put_line('p_rebuild_job_name ' || l_rebuild_job_name);
607: update mtl_transactions_interface
608: set rebuild_job_name=l_rebuild_job_name
609: where transaction_interface_id= x_tmp_id;
610:
611: if (p_reference is not null) then

Line 613: update mtl_transactions_interface

609: where transaction_interface_id= x_tmp_id;
610:
611: if (p_reference is not null) then
612: begin
613: update mtl_transactions_interface
614: set transaction_reference=p_reference
615: where transaction_interface_id= x_tmp_id;
616: end;
617: end if;

Line 622: update mtl_transactions_interface

618:
619: if (l_reason_id is not null) then
620: begin
621: --dbms_output.put_line('l_reason_id ' || l_reason_id);
622: update mtl_transactions_interface
623: set reason_id=l_reason_id
624: where transaction_interface_id= x_tmp_id;
625: end;
626: end if;

Line 629: from mtl_transactions_interface

625: end;
626: end if;
627:
628: select transaction_header_id into l_tx_hdr_id
629: from mtl_transactions_interface
630: where transaction_interface_id = x_tmp_id;
631:
632:
633: -- only call txn processor if online processing. 4(form level) is treated as 1.

Line 659: FROM mtl_transactions_interface

655: ) then
656:
657: BEGIN
658: SELECT error_explanation into x_error_mssg1
659: FROM mtl_transactions_interface
660: WHERE TRANSACTION_header_id = l_tx_hdr_id ;
661: EXCEPTION
662: WHEN others THEN
663: x_error_mssg1:='Error from Inventory transaction manager';

Line 677: FROM mtl_transactions_interface

673: --fix for 3454251.error out even if the return code is -1
674: elsif(l_txmgr_ret_code=-1) then
675: BEGIN
676: SELECT error_explanation into x_error_mssg1
677: FROM mtl_transactions_interface
678: WHERE TRANSACTION_header_id = l_tx_hdr_id ;
679: EXCEPTION
680: WHEN others THEN
681: x_error_mssg1:='Error from Inventory transaction manager';