1866: IF p_trolin_rec.transaction_source_type_id IS NOT NULL THEN
1867: BEGIN
1868: SELECT 1
1869: INTO l_batch_exists
1870: FROM dual
1871: WHERE EXISTS (SELECT gmd.line_no
1872: FROM gme_material_details gmd,mtl_txn_request_lines mtrl
1873: WHERE gmd.material_detail_id=p_trolin_rec.txn_source_line_id
1874: AND mtrl.organization_id=p_trolin_rec.organization_id