662:
663: BEGIN
664: LOG_MESSAGE('Creating MOVE OUT lines');
665:
666: Update mrp_org_transfer_release
667: set part_condition ='G'
668: where transaction_id= l_ro_release.Out_req_transaction_id;
669:
670: mrp_create_schedule_iso.Create_IR_ISO(errbuf,retcode ,l_req_header_id,l_iso_header_id, l_ro_release.Out_req_transaction_id, l_ro_release.batch_id );
1294: BEGIN
1295:
1296: Savepoint Before_MOVE_IN ;
1297:
1298: Update mrp_org_transfer_release
1299: set part_condition ='B'
1300: where transaction_id= l_ro_release.In_req_transaction_id;
1301:
1302:
1304: l_iso_header_id1 := l_iso_header_id;
1305: l_req_header_id1:= l_req_header_id ;
1306:
1307: if (retcode=0 ) then
1308: Update mrp_org_transfer_release
1309: set part_condition ='G'
1310: where transaction_id= l_ro_release.out_req_transaction_id;
1311:
1312: mrp_create_schedule_iso.Create_IR_ISO(errbuf,retcode ,l_req_header_id,l_iso_header_id, l_ro_release.out_req_transaction_id, l_ro_release.batch_id );
1415: retcode := global_retcode;
1416:
1417: DELETE FROM MRP_IRO_RELEASE WHERE BATCH_ID=p_batch_id ;
1418: Commit;
1419: DELETE FROm MRP_ORG_TRANSFER_RELEASE WHERE BATCH_ID=p_batch_id;
1420: Commit;
1421: END Release_new_IRO;
1422:
1423: