502: IF (l_debug = 1) THEN
503: print_debug('Number of MOL updated: '||SQL%rowcount,4);
504: END IF;
505: -- 13564609 starts
506: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
507:
508: THEN
509: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
510:
505: -- 13564609 starts
506: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
507:
508: THEN
509: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
510:
511: END IF;
512:
513: print_debug('serial control code :'||l_ser_ctrl_code,4);
654: print_debug('Number of MOL updated: '||SQL%rowcount,4);
655: END IF;
656:
657: -- 13564609 starts
658: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
659:
660: THEN
661: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
662:
657: -- 13564609 starts
658: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
659:
660: THEN
661: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
662:
663: END IF;
664:
665: print_debug('serial control code :'||l_ser_ctrl_code,4);
808: IF (l_debug = 1) THEN
809: print_debug('Number of MOL updated: '||SQL%rowcount,4);
810: END IF;
811: -- 13564609 starts
812: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
813:
814: THEN
815: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
816:
811: -- 13564609 starts
812: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
813:
814: THEN
815: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
816:
817: END IF;
818:
819: print_debug('serial control code :'||l_ser_ctrl_code,4);
964: IF (l_debug = 1) THEN
965: print_debug('Number of MOL updated: '||SQL%rowcount,4);
966: END IF;
967: -- 13564609 starts
968: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
969:
970: THEN
971: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
972:
967: -- 13564609 starts
968: IF (inv_cache.set_item_rec(l_rti_rec.to_organization_id,l_rti_rec.item_id))
969:
970: THEN
971: l_ser_ctrl_code := inv_cache.item_rec.serial_number_control_code;
972:
973: END IF;
974:
975: print_debug('serial control code :'||l_ser_ctrl_code,4);