DBA Data[Home] [Help]

APPS.MSC_SRP_RELEASE dependencies on MRP_ORG_TRANSFER_RELEASE

Line 665: Update mrp_org_transfer_release

661:
662: BEGIN
663: LOG_MESSAGE('Creating MOVE OUT lines');
664:
665: Update mrp_org_transfer_release
666: set part_condition ='G'
667: where transaction_id= l_ro_release.Out_req_transaction_id;
668:
669: 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 );

Line 1301: Update mrp_org_transfer_release

1297: BEGIN
1298:
1299: Savepoint Before_MOVE_IN ;
1300:
1301: Update mrp_org_transfer_release
1302: set part_condition ='B'
1303: where transaction_id= l_ro_release.In_req_transaction_id;
1304:
1305:

Line 1311: Update mrp_org_transfer_release

1307: l_iso_header_id1 := l_iso_header_id;
1308: l_req_header_id1:= l_req_header_id ;
1309:
1310: if (retcode=0 ) then
1311: Update mrp_org_transfer_release
1312: set part_condition ='G'
1313: where transaction_id= l_ro_release.out_req_transaction_id;
1314:
1315: 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 );

Line 1422: DELETE FROm MRP_ORG_TRANSFER_RELEASE WHERE BATCH_ID=p_batch_id;

1418: retcode := global_retcode;
1419:
1420: DELETE FROM MRP_IRO_RELEASE WHERE BATCH_ID=p_batch_id ;
1421: Commit;
1422: DELETE FROm MRP_ORG_TRANSFER_RELEASE WHERE BATCH_ID=p_batch_id;
1423: Commit;
1424: END Release_new_IRO;
1425:
1426: