APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 789: mtl_material_transactions_temp mmtt

785: /* Added for bug 4041420 - Start */
786: SELECT NVL(max(oap.acct_period_id), -1)
787: INTO l_acct_period_id
788: FROM org_acct_periods oap,
789: mtl_material_transactions_temp mmtt
790: WHERE mmtt.transaction_temp_id = p_trx_tmp_id
791: AND oap.organization_id = mmtt.organization_id
792: AND oap.open_flag = 'Y'
793: AND trunc(SYSDATE)

Line 801: UPDATE mtl_material_transactions_temp

797: IF (l_acct_period_id = -1) THEN
798: raise NO_ACCT_PERIOD_EXC;
799: END IF;
800:
801: UPDATE mtl_material_transactions_temp
802: SET transaction_date = SYSDATE,
803: acct_period_id = l_acct_period_id
804: where transaction_temp_id = p_trx_tmp_id;
805: /* Added for bug 4041420 - End */

Line 808: update mtl_material_transactions_temp

804: where transaction_temp_id = p_trx_tmp_id;
805: /* Added for bug 4041420 - End */
806:
807: select mtl_material_transactions_s.nextval into l_header_id from dual;
808: update mtl_material_transactions_temp
809: set transaction_header_id = l_header_id,
810: transaction_status = null, --Added since WIP is no longer doing this in 11.5.10
811: primary_quantity = -1* primary_quantity,
812: transaction_quantity = -1* transaction_quantity

Line 917: update mtl_material_transactions_temp

913:
914: begin
915:
916: if ((l_reason_id is not null) and (p_reference is not null) ) then
917: update mtl_material_transactions_temp
918: set reason_id=l_reason_id,
919: transaction_reference=p_reference
920: where transaction_temp_id=p_transaction_temp_id;
921:

Line 924: update mtl_material_transactions_temp

920: where transaction_temp_id=p_transaction_temp_id;
921:
922: elsif ((l_reason_id is null) and (p_reference is not null) ) then
923:
924: update mtl_material_transactions_temp
925: set transaction_reference=p_reference
926: where transaction_temp_id=p_transaction_temp_id;
927:
928: elsif ((l_reason_id is not null) and (p_reference is null) ) then

Line 930: update mtl_material_transactions_temp

926: where transaction_temp_id=p_transaction_temp_id;
927:
928: elsif ((l_reason_id is not null) and (p_reference is null) ) then
929:
930: update mtl_material_transactions_temp
931: set reason_id=l_reason_id
932: where transaction_temp_id=p_transaction_temp_id;
933:
934: end if;

Line 946: l_rebuild_job_name mtl_material_transactions_temp.rebuild_job_name%type;

942: P_transaction_temp_id IN Number,
943: p_organization_id IN Number)
944:
945: is
946: l_rebuild_job_name mtl_material_transactions_temp.rebuild_job_name%type;
947: l_rebuild_job_temp Number;
948: begin
949:
950: --the program will work if users transact rebuild-item-id

Line 972: update mtl_material_transactions_temp

968:
969: if ((p_rebuild_activity_id is not null) and (p_rebuild_serial_number is not null))
970: then
971:
972: update mtl_material_transactions_temp
973: set rebuild_item_id=p_rebuild_item_id,
974: rebuild_job_name =l_rebuild_job_name,
975: rebuild_activity_id=p_rebuild_activity_id,
976: rebuild_serial_number=p_rebuild_serial_number

Line 981: update mtl_material_transactions_temp

977: where transaction_temp_id=p_transaction_temp_id;
978:
979: elsif ((p_rebuild_activity_id is null) and (p_rebuild_serial_number is not null)) then
980:
981: update mtl_material_transactions_temp
982: set rebuild_item_id=p_rebuild_item_id,
983: rebuild_job_name =l_rebuild_job_name,
984: rebuild_serial_number=p_rebuild_serial_number
985: where transaction_temp_id=p_transaction_temp_id;

Line 988: update mtl_material_transactions_temp

984: rebuild_serial_number=p_rebuild_serial_number
985: where transaction_temp_id=p_transaction_temp_id;
986: elsif ((p_rebuild_activity_id is not null) and (p_rebuild_serial_number is null)) then
987:
988: update mtl_material_transactions_temp
989: set rebuild_item_id=p_rebuild_item_id,
990: rebuild_job_name =l_rebuild_job_name,
991: rebuild_activity_id=p_rebuild_activity_id
992: where transaction_temp_id=p_transaction_temp_id;

Line 995: update mtl_material_transactions_temp

991: rebuild_activity_id=p_rebuild_activity_id
992: where transaction_temp_id=p_transaction_temp_id;
993: elsif ((p_rebuild_activity_id is null) and (p_rebuild_serial_number is null)) then
994:
995: update mtl_material_transactions_temp
996: set rebuild_item_id=p_rebuild_item_id,
997: rebuild_job_name =l_rebuild_job_name
998: where transaction_temp_id=p_transaction_temp_id;
999: