APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 562: mtl_material_transactions_temp mmtt

558: /* Added for bug 4041420 - Start */
559: SELECT NVL(max(oap.acct_period_id), -1)
560: INTO l_acct_period_id
561: FROM org_acct_periods oap,
562: mtl_material_transactions_temp mmtt
563: WHERE mmtt.transaction_temp_id = p_trx_tmp_id
564: AND oap.organization_id = mmtt.organization_id
565: AND oap.open_flag = 'Y'
566: AND trunc(SYSDATE)

Line 574: UPDATE mtl_material_transactions_temp

570: IF (l_acct_period_id = -1) THEN
571: raise NO_ACCT_PERIOD_EXC;
572: END IF;
573:
574: UPDATE mtl_material_transactions_temp
575: SET transaction_date = SYSDATE,
576: acct_period_id = l_acct_period_id
577: where transaction_temp_id = p_trx_tmp_id;
578: /* Added for bug 4041420 - End */

Line 581: update mtl_material_transactions_temp

577: where transaction_temp_id = p_trx_tmp_id;
578: /* Added for bug 4041420 - End */
579:
580: select mtl_material_transactions_s.nextval into l_header_id from dual;
581: update mtl_material_transactions_temp
582: set transaction_header_id = l_header_id,
583: transaction_status = null, --Added since WIP is no longer doing this in 11.5.10
584: primary_quantity = -1* primary_quantity,
585: transaction_quantity = -1* transaction_quantity

Line 690: update mtl_material_transactions_temp

686:
687: begin
688:
689: if ((l_reason_id is not null) and (p_reference is not null) ) then
690: update mtl_material_transactions_temp
691: set reason_id=l_reason_id,
692: transaction_reference=p_reference
693: where transaction_temp_id=p_transaction_temp_id;
694:

Line 697: update mtl_material_transactions_temp

693: where transaction_temp_id=p_transaction_temp_id;
694:
695: elsif ((l_reason_id is null) and (p_reference is not null) ) then
696:
697: update mtl_material_transactions_temp
698: set transaction_reference=p_reference
699: where transaction_temp_id=p_transaction_temp_id;
700:
701: elsif ((l_reason_id is not null) and (p_reference is null) ) then

Line 703: update mtl_material_transactions_temp

699: where transaction_temp_id=p_transaction_temp_id;
700:
701: elsif ((l_reason_id is not null) and (p_reference is null) ) then
702:
703: update mtl_material_transactions_temp
704: set reason_id=l_reason_id
705: where transaction_temp_id=p_transaction_temp_id;
706:
707: end if;

Line 719: l_rebuild_job_name mtl_material_transactions_temp.rebuild_job_name%type;

715: P_transaction_temp_id IN Number,
716: p_organization_id IN Number)
717:
718: is
719: l_rebuild_job_name mtl_material_transactions_temp.rebuild_job_name%type;
720: l_rebuild_job_temp Number;
721: begin
722:
723: --the program will work if users transact rebuild-item-id

Line 745: update mtl_material_transactions_temp

741:
742: if ((p_rebuild_activity_id is not null) and (p_rebuild_serial_number is not null))
743: then
744:
745: update mtl_material_transactions_temp
746: set rebuild_item_id=p_rebuild_item_id,
747: rebuild_job_name =l_rebuild_job_name,
748: rebuild_activity_id=p_rebuild_activity_id,
749: rebuild_serial_number=p_rebuild_serial_number

Line 754: update mtl_material_transactions_temp

750: where transaction_temp_id=p_transaction_temp_id;
751:
752: elsif ((p_rebuild_activity_id is null) and (p_rebuild_serial_number is not null)) then
753:
754: update mtl_material_transactions_temp
755: set rebuild_item_id=p_rebuild_item_id,
756: rebuild_job_name =l_rebuild_job_name,
757: rebuild_serial_number=p_rebuild_serial_number
758: where transaction_temp_id=p_transaction_temp_id;

Line 761: update mtl_material_transactions_temp

757: rebuild_serial_number=p_rebuild_serial_number
758: where transaction_temp_id=p_transaction_temp_id;
759: elsif ((p_rebuild_activity_id is not null) and (p_rebuild_serial_number is null)) then
760:
761: update mtl_material_transactions_temp
762: set rebuild_item_id=p_rebuild_item_id,
763: rebuild_job_name =l_rebuild_job_name,
764: rebuild_activity_id=p_rebuild_activity_id
765: where transaction_temp_id=p_transaction_temp_id;

Line 768: update mtl_material_transactions_temp

764: rebuild_activity_id=p_rebuild_activity_id
765: where transaction_temp_id=p_transaction_temp_id;
766: elsif ((p_rebuild_activity_id is null) and (p_rebuild_serial_number is null)) then
767:
768: update mtl_material_transactions_temp
769: set rebuild_item_id=p_rebuild_item_id,
770: rebuild_job_name =l_rebuild_job_name
771: where transaction_temp_id=p_transaction_temp_id;
772: